GET https://dev.thelliervoyages.com/faq

Query Metrics

68 Database Queries
13 Different statements
9.65 ms Query time
0 Invalid entities
65 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
3.18 ms
(32.97%)
38
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3 FROM configuration t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "LOGO_PATH"
]
1.50 ms
(15.55%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.url IN (?) AND t0.page_type = ? LIMIT 1
Parameters:
[
  "faq"
  "cms"
]
1.08 ms
(11.24%)
13
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.route AS route_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.path AS path_10, t0.has_link AS has_link_11, t0.parent_id AS parent_id_12, t0.menu_id AS menu_id_13 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  37
]
0.73 ms
(7.54%)
1
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m1_.id AS id_11, m1_.title AS title_12, m1_.type AS type_13, m1_.url AS url_14, m1_.route AS route_15, m1_.position AS position_16, m1_.enabled AS enabled_17, m1_.updated_at AS updated_at_18, m1_.created_at AS created_at_19, m1_.path AS path_20, m1_.has_link AS has_link_21, m0_.parent_id AS parent_id_22, m0_.menu_id AS menu_id_23, m1_.parent_id AS parent_id_24, m1_.menu_id AS menu_id_25 FROM menu_item m0_ LEFT JOIN menu_item m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu m2_ ON m0_.menu_id = m2_.id LEFT JOIN menu_type m3_ ON m2_.type_id = m3_.id WHERE m0_.parent_id IS NULL AND m0_.enabled = 1 AND m3_.name LIKE '%MENU%' ORDER BY m0_.position ASC, m1_.position ASC
Parameters:
[]
0.69 ms
(7.13%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.enabled AS enabled_5, t0.content AS content_6, t0.seo_id AS seo_id_7 FROM cms t0 WHERE t0.id = ?
Parameters:
[
  "14"
]
0.59 ms
(6.08%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.enabled AS enabled_5, t0.content AS content_6, t0.seo_id AS seo_id_7 FROM cms t0 WHERE t0.seo_id = ? LIMIT 1
Parameters:
[
  955
]
0.46 ms
(4.75%)
1
SELECT t0.id AS id_1, t0.is_activate AS is_activate_2, t0.ips AS ips_3, t0.message AS message_4 FROM maintenance t0 LIMIT 1
Parameters:
[]
0.40 ms
(4.11%)
2
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.url AS url_3, m0_.route AS route_4, m0_.position AS position_5, m0_.enabled AS enabled_6, m0_.updated_at AS updated_at_7, m0_.created_at AS created_at_8, m0_.path AS path_9, m0_.has_link AS has_link_10, m0_.parent_id AS parent_id_11, m0_.menu_id AS menu_id_12 FROM menu_item m0_ INNER JOIN menu m1_ ON m0_.menu_id = m1_.id WHERE m1_.type_id = ? AND m0_.parent_id IS NULL AND m0_.enabled = 1 ORDER BY m0_.position ASC
Parameters:
[
  2
]
0.27 ms
(2.85%)
2
SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.position AS position_4, t0.enabled AS enabled_5 FROM social_network t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
0.20 ms
(2.04%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archived AS archived_5, t0.thumbnail AS thumbnail_6, t0.filename AS filename_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
0.19 ms
(1.96%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "faq"
]
0.19 ms
(1.95%)
2
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.og_title AS og_title_6, t0.twitter_card AS twitter_card_7, t0.page_type AS page_type_8, t0.og_image_id AS og_image_id_9, t0.twitter_image_id AS twitter_image_id_10 FROM seo_meta_data t0 WHERE t0.id = ?
Parameters:
[
  952
]
0.18 ms
(1.82%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_items AS sub_items_3 FROM menu_type t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Footer"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
old_db doctrine.dbal.old_db_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\Menu\MenuItem 34
App\Entity\Configuration 17
App\Entity\SeoMetaData 3
App\Entity\Cms\Cms 3
App\Entity\Config\SocialNetwork 3
App\Entity\Menu\Menu 2
App\Entity\Maintenance 1
App\Entity\File 1
App\Entity\Menu\MenuType 1

Entities Mapping