Query Metrics
3
Database Queries
2
Different statements
3.99 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.70 ms |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.created_at AS created_at_2, h0_.updated_at AS updated_at_3, h0_.is_visible AS is_visible_4, h0_.slug AS slug_5, h0_.lft AS lft_6, h0_.lvl AS lvl_7, h0_.rgt AS rgt_8, h0_.position AS position_9, h0_.route_name AS route_name_10, h0_.meta_title AS meta_title_11, h0_.meta_keywords AS meta_keywords_12, h0_.meta_description AS meta_description_13, h1_.title AS title_14, h1_.content_before AS content_before_15, h1_.content_after AS content_after_16, h1_.link AS link_17, h1_.is_blank AS is_blank_18, h1_.image AS image_19, h3_.link AS link_20, h3_.is_blank AS is_blank_21, h4_.link AS link_22, h4_.is_blank AS is_blank_23, h5_.document_type AS document_type_24, h0_.discr AS discr_25, h0_.tree_root AS tree_root_26, h0_.parent_id AS parent_id_27 FROM h_site_structure h0_ LEFT JOIN h_site_structure_page h1_ ON h0_.id = h1_.id LEFT JOIN h_site_structure_menu h2_ ON h0_.id = h2_.id LEFT JOIN h_site_structure_link h3_ ON h0_.id = h3_.id LEFT JOIN h_site_structure_inner_link h4_ ON h0_.id = h4_.id LEFT JOIN h_site_structure_document h5_ ON h0_.id = h5_.id WHERE LOWER(h0_.route_name) = LOWER(?)
Parameters:
[
"partner.login"
]
|
| 2 | 0.61 ms |
SELECT t0.id AS id_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_visible AS is_visible_10, t0.slug AS slug_11, t0.lft AS lft_12, t0.lvl AS lvl_13, t0.rgt AS rgt_14, t0.position AS position_15, t0.route_name AS route_name_16, t0.meta_title AS meta_title_17, t0.meta_keywords AS meta_keywords_18, t0.meta_description AS meta_description_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.discr, t1.title AS title_22, t1.content_before AS content_before_23, t1.content_after AS content_after_24, t1.link AS link_25, t1.is_blank AS is_blank_26, t1.image AS image_27, t3.link AS link_28, t3.is_blank AS is_blank_29, t4.link AS link_30, t4.is_blank AS is_blank_31, t5.document_type AS document_type_32 FROM h_site_structure t0 LEFT JOIN h_site_structure_page t1 ON t0.id = t1.id LEFT JOIN h_site_structure_menu t2 ON t0.id = t2.id LEFT JOIN h_site_structure_link t3 ON t0.id = t3.id LEFT JOIN h_site_structure_inner_link t4 ON t0.id = t4.id LEFT JOIN h_site_structure_document t5 ON t0.id = t5.id WHERE t0.id = ?
Parameters:
[
"ae5b871e-78b6-41c9-9ad1-40c9cde39326"
]
|
| 3 | 0.67 ms |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.created_at AS created_at_2, h0_.updated_at AS updated_at_3, h0_.is_visible AS is_visible_4, h0_.slug AS slug_5, h0_.lft AS lft_6, h0_.lvl AS lvl_7, h0_.rgt AS rgt_8, h0_.position AS position_9, h0_.route_name AS route_name_10, h0_.meta_title AS meta_title_11, h0_.meta_keywords AS meta_keywords_12, h0_.meta_description AS meta_description_13, h1_.title AS title_14, h1_.content_before AS content_before_15, h1_.content_after AS content_after_16, h1_.link AS link_17, h1_.is_blank AS is_blank_18, h1_.image AS image_19, h3_.link AS link_20, h3_.is_blank AS is_blank_21, h4_.link AS link_22, h4_.is_blank AS is_blank_23, h5_.document_type AS document_type_24, h0_.discr AS discr_25, h0_.tree_root AS tree_root_26, h0_.parent_id AS parent_id_27 FROM h_site_structure h0_ LEFT JOIN h_site_structure_page h1_ ON h0_.id = h1_.id LEFT JOIN h_site_structure_menu h2_ ON h0_.id = h2_.id LEFT JOIN h_site_structure_link h3_ ON h0_.id = h3_.id LEFT JOIN h_site_structure_inner_link h4_ ON h0_.id = h4_.id LEFT JOIN h_site_structure_document h5_ ON h0_.id = h5_.id WHERE LOWER(h0_.route_name) = LOWER(?)
Parameters:
[
"partner.index"
]
|
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.