array:4 [ "faculty" => "main" "show_on_home" => 1 "sort_by_id" => true "order" => "item.date_from DESC, item.id DESC" ]
Query {#748 -_state: 2 -parsedTypes: [] -dql: "SELECT DISTINCT item FROM Systemsight\Modules\News\Models\NewsItem item WHERE item.show_on_home = :show_on_homeshow_on_home AND DATE(item.date_from) <= :itemDateFrom AND DATE(item.date_to) >= :itemDateTo ORDER BY item.date_from DESC, item.id DESC" -parserResult: null -firstResult: 152 -maxResults: 19 -queryCache: null -expireQueryCache: false -queryCacheTTL: null -useQueryCache: true #parameters: ArrayCollection {#786 -elements: array:3 [ 0 => Parameter {#803 -name: "show_on_homeshow_on_home" -value: 1 -type: "integer" -typeSpecified: false } 1 => Parameter {#750 -name: "itemDateFrom" -value: "2024-07-09" -type: 2 -typeSpecified: false } 2 => Parameter {#768 -name: "itemDateTo" -value: "2024-07-09" -type: 2 -typeSpecified: false } ] } #_resultSetMapping: null #_em: EntityManager {#38 …11} #_hints: [] #_hydrationMode: 1 #_queryCacheProfile: null #_expireResultCache: false #_hydrationCacheProfile: null #cacheable: false #hasCache: false #cacheRegion: null #cacheMode: null #cacheLogger: null #lifetime: 0 }