GET https://dev.thelliervoyages.com/actualites/marches-noel-camping-car-europe

Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
3.79 ms
(41.11%)
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.48 ms
(16.11%)
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.66 ms
(7.18%)
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.43 ms
(4.64%)
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.34 ms
(3.75%)
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.33 ms
(3.59%)
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.32 ms
(3.52%)
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.30 ms
(3.30%)
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:
[
  277
]
0.30 ms
(3.30%)
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.22 ms
(2.34%)
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.21 ms
(2.28%)
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.21 ms
(2.25%)
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.19 ms
(2.06%)
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
  61
]
0.17 ms
(1.80%)
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:
[
  "marches-noel-camping-car-europe"
  "post"
]
0.14 ms
(1.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 = ? LIMIT 1
Parameters:
[
  "marches-noel-camping-car-europe"
]
0.11 ms
(1.19%)
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