Query Metrics

3 Database Queries
3 Different statements
1.83 ms Query time
0 Invalid entities
12 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.66 ms
(36.14%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM page t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "home"
]
0.64 ms
(34.88%)
1
SELECT c0_.id AS id_0, c0_.iso_code AS iso_code_1, c0_.name AS name_2, c0_.country AS country_3, c0_.active AS active_4, c0_.display_home AS display_home_5, c0_.sort AS sort_6, c0_.city_id AS city_id_7, c0_.zone_id AS zone_id_8, c0_.main_image_id AS main_image_id_9, c0_.gallery_id AS gallery_id_10 FROM country c0_ INNER JOIN iata_city i1_ ON c0_.city_id = i1_.id WHERE c0_.active = 1 AND c0_.display_home = 1 ORDER BY c0_.sort ASC, c0_.name ASC
Parameters:
[]
0.53 ms
(28.98%)
1
SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.resume AS resume_2, s0_.description AS description_3, s0_.eventStart AS eventStart_4, s0_.eventEnd AS eventEnd_5, s0_.sale_start AS sale_start_6, s0_.sale_end AS sale_end_7, s0_.active AS active_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.event_thumbnail_id AS event_thumbnail_id_11, s0_.event_banner_id AS event_banner_id_12 FROM special_event s0_ WHERE s0_.sale_start <= ? AND ? <= s0_.sale_end AND s0_.active = ?
Parameters:
[
  "2026-07-27"
  "2026-07-27"
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Country 3
App\Entity\IataCity 3
App\Entity\Gallery 3
App\Entity\Page 1
App\Entity\Zone 1
App\Entity\Media 1