Query Metrics
52
Database Queries
9
Different statements
50.47 ms
Query time
0
Invalid entities
142
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
33.21 ms (65.79%) |
6 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.no_index AS no_index_28, c1_.seo_title AS seo_title_29, c1_.seo_description AS seo_description_30, c1_.seo_keywords AS seo_keywords_31, c1_.seo_sitemap_priority AS seo_sitemap_priority_32, c1_.seo_sitemap_change_freq AS seo_sitemap_change_freq_33, c1_.og_title AS og_title_34, c1_.og_type AS og_type_35, c1_.og_description AS og_description_36, c1_.og_site_name AS og_site_name_37, c1_.twitter_card AS twitter_card_38, c1_.twitter_site AS twitter_site_39, c1_.twitter_title AS twitter_title_40, c1_.twitter_description AS twitter_description_41, c1_.twitter_creator AS twitter_creator_42, c1_.created_at AS created_at_43, c1_.updated_at AS updated_at_44, c2_.id AS id_45, c2_.name AS name_46, c2_.methods AS methods_47, c2_.path AS path_48, c2_.controller AS controller_49, c2_.defaults AS defaults_50, c2_.requirements AS requirements_51, c3_.id AS id_52, c3_.name AS name_53, c3_.information AS information_54, c3_.link_type AS link_type_55, c3_.link_value AS link_value_56, c3_.is_visible AS is_visible_57, c3_.lvl AS lvl_58, c3_.lft AS lft_59, c3_.rgt AS rgt_60, c3_.li_class AS li_class_61, c3_.ul_class AS ul_class_62, c3_.link_class AS link_class_63, c3_.icon_class AS icon_class_64, c3_.connected AS connected_65, c3_.role AS role_66, c3_.params AS params_67, c3_.blank AS blank_68, c3_.anchor AS anchor_69, c4_.id AS id_70, c4_.slug AS slug_71, c4_.label AS label_72, c4_.locale AS locale_73, c4_.host AS host_74, c4_.localhost AS localhost_75, c4_.host_multilingual AS host_multilingual_76, c4_.`default` AS default_77, c4_.flag_icon AS flag_icon_78, c4_.visible AS visible_79, c4_.template_filter AS template_filter_80, c5_.id AS id_81, c5_.code AS code_82, c5_.label AS label_83, c5_.type AS type_84, c5_.value AS value_85, c5_.position AS position_86, c5_.parent_heritance AS parent_heritance_87, c5_.active AS active_88, c0_.page_id AS page_id_89, c0_.tree_root AS tree_root_90, c0_.parent_id AS parent_id_91, c0_.menu_id AS menu_id_92, c1_.route_id AS route_id_93, c1_.site_id AS site_id_94, c1_.tree_root AS tree_root_95, c1_.parent_id AS parent_id_96, c1_.og_image_id AS og_image_id_97, c1_.twitter_image_id AS twitter_image_id_98, c2_.discr AS discr_99, c3_.page_id AS page_id_100, c3_.tree_root AS tree_root_101, c3_.parent_id AS parent_id_102, c3_.menu_id AS menu_id_103, c5_.page_id AS page_id_104, c5_.shared_block_parent_id AS shared_block_parent_id_105, c5_.declination_id AS declination_id_106 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = ? ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC
Parameters:
[
54
]
|
|
7.08 ms (14.03%) |
27 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.category AS category_3, t0.file_name AS file_name_4, t0.mime_type AS mime_type_5, t0.extension AS extension_6, t0.crop_data AS crop_data_7, t0.description AS description_8, t0.permalink AS permalink_9, t0.alt AS alt_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM wd_media__media t0 WHERE t0.id = ?
Parameters:
[
124
]
|
|
2.78 ms (5.51%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = ?
Parameters:
[
54
]
|
|
2.07 ms (4.09%) |
6 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = ? AND t0.site_id = ? LIMIT 1
Parameters:
[ "main_menu" 1 ] |
|
2.05 ms (4.07%) |
1 |
SELECT t0.username_canonical AS username_canonical_1, t0.email_canonical AS email_canonical_2, t0.newsletter_update AS newsletter_update_3, t0.certified AS certified_4, t0.email_new_account AS email_new_account_5, t0.certified_at AS certified_at_6, t0.access_quiz AS access_quiz_7, t0.rgpd AS rgpd_8, t0.rgpd_update AS rgpd_update_9, t0.firm AS firm_10, t0.url AS url_11, t0.firm_description AS firm_description_12, t0.firm_contact_firstname AS firm_contact_firstname_13, t0.firm_contact_lastname AS firm_contact_lastname_14, t0.firm_contact_address AS firm_contact_address_15, t0.firm_contact_zip_code AS firm_contact_zip_code_16, t0.firm_contact_town AS firm_contact_town_17, t0.firm_contact_country AS firm_contact_country_18, t0.firm_contact_email AS firm_contact_email_19, t0.firm_contact_phone AS firm_contact_phone_20, t0.firm_contact_mobile AS firm_contact_mobile_21, t0.firm_siret AS firm_siret_22, t0.firm_bill_firstname AS firm_bill_firstname_23, t0.firm_bill_lastname AS firm_bill_lastname_24, t0.firm_bill_address AS firm_bill_address_25, t0.firm_bill_zip_code AS firm_bill_zip_code_26, t0.firm_bill_town AS firm_bill_town_27, t0.firm_bill_country AS firm_bill_country_28, t0.firm_bill_email AS firm_bill_email_29, t0.firm_bill_phone AS firm_bill_phone_30, t0.firm_bill_mobile AS firm_bill_mobile_31, t0.firm_tva AS firm_tva_32, t0.description_why AS description_why_33, t0.firm_syndic AS firm_syndic_34, t0.id AS id_35, t0.username AS username_36, t0.email AS email_37, t0.password AS password_38, t0.permissions AS permissions_39, t0.token AS token_40, t0.confirmation_token AS confirmation_token_41, t0.password_requested_at AS password_requested_at_42, t0.last_login AS last_login_43, t0.enabled AS enabled_44, t0.newsletter AS newsletter_45, t0.newsletter_accepted_at AS newsletter_accepted_at_46, t0.is_banned AS is_banned_47, t0.ban_reason AS ban_reason_48, t0.firstname AS firstname_49, t0.lastname AS lastname_50, t0.gender AS gender_51, t0.locale AS locale_52, t0.last_update_password AS last_update_password_53, t0.notify_update_password_at AS notify_update_password_at_54, t0.notify_inactivity_at AS notify_inactivity_at_55, t0.rgpd_accepted_at AS rgpd_accepted_at_56, t0.anonymized_at AS anonymized_at_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.azure_id AS azure_id_60, t0.firm_picture_id AS firm_picture_id_61 FROM user__user t0 WHERE t0.certified = ?
Parameters:
[
1
]
|
|
1.15 ms (2.28%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.template AS template_2, c0_.slug AS slug_3, c0_.breadcrumb AS breadcrumb_4, c0_.active AS active_5, c0_.roles AS roles_6, c0_.lft AS lft_7, c0_.lvl AS lvl_8, c0_.rgt AS rgt_9, c0_.no_index AS no_index_10, c0_.seo_title AS seo_title_11, c0_.seo_description AS seo_description_12, c0_.seo_keywords AS seo_keywords_13, c0_.seo_sitemap_priority AS seo_sitemap_priority_14, c0_.seo_sitemap_change_freq AS seo_sitemap_change_freq_15, c0_.og_title AS og_title_16, c0_.og_type AS og_type_17, c0_.og_description AS og_description_18, c0_.og_site_name AS og_site_name_19, c0_.twitter_card AS twitter_card_20, c0_.twitter_site AS twitter_site_21, c0_.twitter_title AS twitter_title_22, c0_.twitter_description AS twitter_description_23, c0_.twitter_creator AS twitter_creator_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c1_.id AS id_27, c1_.name AS name_28, c1_.methods AS methods_29, c1_.path AS path_30, c1_.controller AS controller_31, c1_.defaults AS defaults_32, c1_.requirements AS requirements_33, c2_.id AS id_34, c2_.slug AS slug_35, c2_.label AS label_36, c2_.locale AS locale_37, c2_.host AS host_38, c2_.localhost AS localhost_39, c2_.host_multilingual AS host_multilingual_40, c2_.`default` AS default_41, c2_.flag_icon AS flag_icon_42, c2_.visible AS visible_43, c2_.template_filter AS template_filter_44, c3_.id AS id_45, c3_.title AS title_46, c3_.technic_name AS technic_name_47, c3_.locale AS locale_48, c3_.active AS active_49, c3_.params AS params_50, c3_.seo_title AS seo_title_51, c3_.seo_description AS seo_description_52, c3_.seo_keywords AS seo_keywords_53, c3_.seo_sitemap_priority AS seo_sitemap_priority_54, c3_.seo_sitemap_change_freq AS seo_sitemap_change_freq_55, c3_.og_title AS og_title_56, c3_.og_type AS og_type_57, c3_.og_description AS og_description_58, c3_.og_site_name AS og_site_name_59, c3_.twitter_card AS twitter_card_60, c3_.twitter_site AS twitter_site_61, c3_.twitter_title AS twitter_title_62, c3_.twitter_description AS twitter_description_63, c3_.twitter_creator AS twitter_creator_64, c0_.route_id AS route_id_65, c0_.site_id AS site_id_66, c0_.tree_root AS tree_root_67, c0_.parent_id AS parent_id_68, c0_.og_image_id AS og_image_id_69, c0_.twitter_image_id AS twitter_image_id_70, c1_.discr AS discr_71, c3_.page_id AS page_id_72, c3_.og_image_id AS og_image_id_73, c3_.twitter_image_id AS twitter_image_id_74 FROM cms__page c0_ LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id AND c1_.discr IN ('base') LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id WHERE c1_.name = ?
Parameters:
[
"cms_route_39"
]
|
|
0.79 ms (1.56%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.methods AS methods_3, t0.path AS path_4, t0.controller AS controller_5, t0.defaults AS defaults_6, t0.requirements AS requirements_7, t8.id AS id_9, t8.title AS title_10, t8.template AS template_11, t8.slug AS slug_12, t8.breadcrumb AS breadcrumb_13, t8.active AS active_14, t8.roles AS roles_15, t8.lft AS lft_16, t8.lvl AS lvl_17, t8.rgt AS rgt_18, t8.no_index AS no_index_19, t8.seo_title AS seo_title_20, t8.seo_description AS seo_description_21, t8.seo_keywords AS seo_keywords_22, t8.seo_sitemap_priority AS seo_sitemap_priority_23, t8.seo_sitemap_change_freq AS seo_sitemap_change_freq_24, t8.og_title AS og_title_25, t8.og_type AS og_type_26, t8.og_description AS og_description_27, t8.og_site_name AS og_site_name_28, t8.twitter_card AS twitter_card_29, t8.twitter_site AS twitter_site_30, t8.twitter_title AS twitter_title_31, t8.twitter_description AS twitter_description_32, t8.twitter_creator AS twitter_creator_33, t8.created_at AS created_at_34, t8.updated_at AS updated_at_35, t8.route_id AS route_id_36, t8.site_id AS site_id_37, t8.tree_root AS tree_root_38, t8.parent_id AS parent_id_39, t8.og_image_id AS og_image_id_40, t8.twitter_image_id AS twitter_image_id_41, t0.discr FROM cms__route t0 LEFT JOIN cms__page t8 ON t8.route_id = t0.id WHERE t0.discr IN ('base')
Parameters:
[] |
|
0.68 ms (1.35%) |
2 |
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1
Parameters:
[ "title" 39 ] |
|
0.67 ms (1.33%) |
2 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1
Parameters:
[
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 |
|---|---|
| WebEtDesign\CmsBundle\Entity\CmsMenuItem | 30 |
| App\Entity\User\User | 28 |
| WebEtDesign\CmsBundle\Entity\CmsContent | 28 |
| WebEtDesign\MediaBundle\Entity\Media | 27 |
| WebEtDesign\CmsBundle\Entity\CmsPage | 11 |
| WebEtDesign\CmsBundle\Entity\AbstractCmsRoute | 11 |
| WebEtDesign\CmsBundle\Entity\CmsMenu | 6 |
| WebEtDesign\CmsBundle\Entity\CmsSite | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| WebEtDesign\CmsBundle\Entity\CmsPage | No errors. |
| WebEtDesign\CmsBundle\Entity\AbstractCmsRoute | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsRoute | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsSite | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsPageDeclination | No errors. |
| WebEtDesign\MediaBundle\Entity\Media | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsContent | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsMenuItem | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsMenu | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsSharedBlock | No errors. |
| WebEtDesign\UserBundle\Entity\WDUser | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\Quiz | No errors. |
| App\Entity\User\Group | No errors. |