GET https://dev.thelliervoyages.com/actualites/voyage-en-birmanie-venez-decouvrir-les-charmes-du-lac-inle

Query Metrics

79 Database Queries
16 Different statements
8.86 ms Query time
0 Invalid entities
79 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
3.48 ms
(39.23%)
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.12 ms
(12.64%)
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.52 ms
(5.85%)
3
SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.title AS title_4, t0.post_id AS post_id_5 FROM post_image t0 WHERE t0.post_id = ?
Parameters:
[
  60
]
0.51 ms
(5.72%)
6
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:
[
  955
]
0.40 ms
(4.57%)
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:
[
  "voyage-en-birmanie-venez-decouvrir-les-charmes-du-lac-inle"
  "post"
]
0.39 ms
(4.39%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.summary AS summary_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.published_at AS published_at_8, t9.id AS id_10, t9.path AS path_11, t9.alt AS alt_12, t9.title AS title_13, t9.post_id AS post_id_14, t0.category_id AS category_id_15, t0.seo_id AS seo_id_16 FROM post t0 LEFT JOIN post_image t9 ON t9.post_id = t0.id WHERE t0.seo_id = ? LIMIT 1
Parameters:
[
  344
]
0.34 ms
(3.86%)
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.32 ms
(3.67%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.summary AS summary_2, p0_.content AS content_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.enabled AS enabled_6, p0_.published_at AS published_at_7, p0_.category_id AS category_id_8, p0_.seo_id AS seo_id_9 FROM post p0_ WHERE p0_.enabled = ? AND p0_.id <> ? ORDER BY p0_.created_at DESC LIMIT 3
Parameters:
[
  1
  128
]
0.32 ms
(3.57%)
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.31 ms
(3.46%)
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:
[
  "voyage-en-birmanie-venez-decouvrir-les-charmes-du-lac-inle"
]
0.30 ms
(3.35%)
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
(3.07%)
3
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:
[
  "13"
]
0.18 ms
(1.98%)
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"
]
0.17 ms
(1.96%)
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.15 ms
(1.68%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.filter AS filter_3, t0.enabled AS enabled_4 FROM post_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.09 ms
(0.99%)
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"
]

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 7
App\Entity\Post\Post 4
App\Entity\Post\PostImage 4
App\Entity\Config\SocialNetwork 3
App\Entity\Cms\Cms 3
App\Entity\Post\PostCategory 2
App\Entity\Menu\Menu 2
App\Entity\Maintenance 1
App\Entity\File 1
App\Entity\Menu\MenuType 1