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: 874
-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
}
