Query Metrics
17
Database Queries
12
Different statements
5.92 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.83 ms |
SELECT t0.route AS route_1, t0.id AS id_2, t0.page_name AS page_name_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
"app_landing_page_show"
]
|
| 2 | 0.34 ms |
SELECT t0.phone AS phone_1, t0.address_street AS address_street_2, t0.credits AS credits_3, t0.id AS id_4, t0.email AS email_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.legal_site_name AS legal_site_name_8, t0.legal_siret AS legal_siret_9, t0.legal_siren AS legal_siren_10, t0.legal_rcs AS legal_rcs_11, t0.legal_address AS legal_address_12, t0.legal_zipcode AS legal_zipcode_13, t0.legal_city AS legal_city_14, t0.legal_phone AS legal_phone_15, t0.legal_email AS legal_email_16, t0.legal_publication_owner AS legal_publication_owner_17, t0.legal_site_url AS legal_site_url_18, t0.default_title AS default_title_19, t0.default_meta_desc AS default_meta_desc_20 FROM site_settings t0
Parameters:
[] |
| 3 | 0.51 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.cover_name AS cover_name_5, t0.cover_size AS cover_size_6, t0.cover_updated_at AS cover_updated_at_7, t0.cover_alt AS cover_alt_8, t0.published AS published_9, t0.citation_over_title AS citation_over_title_10, t0.citation AS citation_11, t0.faq_over_title AS faq_over_title_12, t0.faq_title AS faq_title_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16 FROM landing_page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"h1-lorem-ipsum-is-simply-dummy-text"
]
|
| 4 | 0.48 ms |
SELECT t0.id AS id_1, t0.cover_name AS cover_name_2, t0.cover_size AS cover_size_3, t0.cover_updated_at AS cover_updated_at_4, t0.cover_alt AS cover_alt_5, t0.name AS name_6, t0.icon_name AS icon_name_7, t0.icon_size AS icon_size_8, t0.icon_updated_at AS icon_updated_at_9, t0.icon_alt AS icon_alt_10, t0.resume AS resume_11, t0.intro_sub_title AS intro_sub_title_12, t0.intro_title AS intro_title_13, t0.intro_paragraphe AS intro_paragraphe_14, t0.intro_visuel_panoramique_name AS intro_visuel_panoramique_name_15, t0.intro_visuel_panoramique_size AS intro_visuel_panoramique_size_16, t0.intro_visuel_panoramique_updated_at AS intro_visuel_panoramique_updated_at_17, t0.intro_visuel_panoramique_alt AS intro_visuel_panoramique_alt_18, t0.intro_paragraphe2 AS intro_paragraphe2_19, t0.intro_paragraphe3 AS intro_paragraphe3_20, t0.why_call_sub_title AS why_call_sub_title_21, t0.why_call_title AS why_call_title_22, t0.citationsub_title AS citationsub_title_23, t0.why_call_paragraphe AS why_call_paragraphe_24, t0.why_call_paragraphe2 AS why_call_paragraphe2_25, t0.contact_title AS contact_title_26, t0.contact_paragraphe AS contact_paragraphe_27, t0.meta_title AS meta_title_28, t0.meta_description AS meta_description_29, t0.position AS position_30, t0.slug AS slug_31, t0.citation AS citation_32, t0.author AS author_33 FROM expertise_public t0
Parameters:
[] |
| 5 | 0.40 ms |
SELECT t0.id AS id_1, t0.cover_name AS cover_name_2, t0.cover_size AS cover_size_3, t0.cover_updated_at AS cover_updated_at_4, t0.cover_alt AS cover_alt_5, t0.name AS name_6, t0.icon_name AS icon_name_7, t0.icon_size AS icon_size_8, t0.icon_updated_at AS icon_updated_at_9, t0.icon_alt AS icon_alt_10, t0.resume AS resume_11, t0.intro_sub_title AS intro_sub_title_12, t0.intro_title AS intro_title_13, t0.intro_paragraphe AS intro_paragraphe_14, t0.intro_visuel_panoramique_name AS intro_visuel_panoramique_name_15, t0.intro_visuel_panoramique_size AS intro_visuel_panoramique_size_16, t0.intro_visuel_panoramique_updated_at AS intro_visuel_panoramique_updated_at_17, t0.intro_visuel_panoramique_alt AS intro_visuel_panoramique_alt_18, t0.intro_paragraphe2 AS intro_paragraphe2_19, t0.intro_paragraphe3 AS intro_paragraphe3_20, t0.why_call_sub_title AS why_call_sub_title_21, t0.why_call_title AS why_call_title_22, t0.citationsub_title AS citationsub_title_23, t0.why_call_paragraphe AS why_call_paragraphe_24, t0.why_call_paragraphe2 AS why_call_paragraphe2_25, t0.contact_title AS contact_title_26, t0.contact_paragraphe AS contact_paragraphe_27, t0.meta_title AS meta_title_28, t0.meta_description AS meta_description_29, t0.position AS position_30, t0.slug AS slug_31, t0.citation AS citation_32, t0.author AS author_33 FROM expertise_prive t0
Parameters:
[] |
| 6 | 0.36 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.cover_name AS cover_name_3, t0.cover_size AS cover_size_4, t0.cover_updated_at AS cover_updated_at_5, t0.cover_alt AS cover_alt_6, t0.firm_name AS firm_name_7, t0.logo_name AS logo_name_8, t0.logo_size AS logo_size_9, t0.logo_updated_at AS logo_updated_at_10, t0.logo_alt AS logo_alt_11, t0.resume AS resume_12, t0.intro_title AS intro_title_13, t0.intro_paragraph AS intro_paragraph_14, t0.intro_visuel_panoramique_name AS intro_visuel_panoramique_name_15, t0.intro_visuel_panoramique_size AS intro_visuel_panoramique_size_16, t0.intro_visuel_panoramique_updated_at AS intro_visuel_panoramique_updated_at_17, t0.intro_visuel_panoramique_alt AS intro_visuel_panoramique_alt_18, t0.intro_video_url AS intro_video_url_19, t0.more_sectors AS more_sectors_20, t0.more_expertises AS more_expertises_21, t0.more_title AS more_title_22, t0.more_paragraph AS more_paragraph_23, t0.blue_sub_title AS blue_sub_title_24, t0.blue_title AS blue_title_25, t0.blue_paragraph1 AS blue_paragraph1_26, t0.blue_paragraph2 AS blue_paragraph2_27, t0.key_number1_number AS key_number1_number_28, t0.key_number1_libelle AS key_number1_libelle_29, t0.key_number2_number AS key_number2_number_30, t0.key_number2_libelle AS key_number2_libelle_31, t0.key_number3_number AS key_number3_number_32, t0.key_number3_libelle AS key_number3_libelle_33, t0.key_number4_number AS key_number4_number_34, t0.key_number4_libelle AS key_number4_libelle_35, t0.contact_title AS contact_title_36, t0.contact_paragraph AS contact_paragraph_37, t0.display_on_menu AS display_on_menu_38, t0.meta_title AS meta_title_39, t0.meta_description AS meta_description_40, t0.position AS position_41, t0.slug AS slug_42, t0.city_id AS city_id_43 FROM reference_public t0 WHERE t0.display_on_menu = ?
Parameters:
[
1
]
|
| 7 | 0.29 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM reference_city t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 8 | 0.22 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM reference_city t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 9 | 0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM reference_city t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 10 | 0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.cover_name AS cover_name_3, t0.cover_size AS cover_size_4, t0.cover_updated_at AS cover_updated_at_5, t0.cover_alt AS cover_alt_6, t0.firm_name AS firm_name_7, t0.logo_name AS logo_name_8, t0.logo_size AS logo_size_9, t0.logo_updated_at AS logo_updated_at_10, t0.logo_alt AS logo_alt_11, t0.resume AS resume_12, t0.intro_title AS intro_title_13, t0.intro_paragraph AS intro_paragraph_14, t0.intro_visuel_panoramique_name AS intro_visuel_panoramique_name_15, t0.intro_visuel_panoramique_size AS intro_visuel_panoramique_size_16, t0.intro_visuel_panoramique_updated_at AS intro_visuel_panoramique_updated_at_17, t0.intro_visuel_panoramique_alt AS intro_visuel_panoramique_alt_18, t0.intro_video_url AS intro_video_url_19, t0.more_sectors AS more_sectors_20, t0.more_expertises AS more_expertises_21, t0.more_title AS more_title_22, t0.more_paragraph AS more_paragraph_23, t0.blue_sub_title AS blue_sub_title_24, t0.blue_title AS blue_title_25, t0.blue_paragraph1 AS blue_paragraph1_26, t0.blue_paragraph2 AS blue_paragraph2_27, t0.key_number1_number AS key_number1_number_28, t0.key_number1_libelle AS key_number1_libelle_29, t0.key_number2_number AS key_number2_number_30, t0.key_number2_libelle AS key_number2_libelle_31, t0.key_number3_number AS key_number3_number_32, t0.key_number3_libelle AS key_number3_libelle_33, t0.key_number4_number AS key_number4_number_34, t0.key_number4_libelle AS key_number4_libelle_35, t0.contact_title AS contact_title_36, t0.contact_paragraph AS contact_paragraph_37, t0.display_on_menu AS display_on_menu_38, t0.meta_title AS meta_title_39, t0.meta_description AS meta_description_40, t0.position AS position_41, t0.slug AS slug_42, t0.city_id AS city_id_43 FROM reference_prive t0 WHERE t0.display_on_menu = ?
Parameters:
[
1
]
|
| 11 | 0.22 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM reference_city t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 12 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM reference_city t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 13 | 0.19 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM reference_city t0 WHERE t0.id = ?
Parameters:
[
14
]
|
| 14 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.cover_name AS cover_name_3, t0.cover_size AS cover_size_4, t0.cover_updated_at AS cover_updated_at_5, t0.cover_alt AS cover_alt_6, t0.section1_sub_title AS section1_sub_title_7, t0.section1_title AS section1_title_8, t0.section1_paragraphe AS section1_paragraphe_9, t0.section1_visuel_left_name AS section1_visuel_left_name_10, t0.section1_visuel_left_size AS section1_visuel_left_size_11, t0.section1_visuel_left_updated_at AS section1_visuel_left_updated_at_12, t0.section1_visuel_left_alt AS section1_visuel_left_alt_13, t0.section2_sub_title AS section2_sub_title_14, t0.section2_title AS section2_title_15, t0.section2_paragraphe AS section2_paragraphe_16, t0.section2_visuel_name AS section2_visuel_name_17, t0.section2_visuel_size AS section2_visuel_size_18, t0.section2_visuel_updated_at AS section2_visuel_updated_at_19, t0.section2_visuel_alt AS section2_visuel_alt_20, t0.citationsub_title AS citationsub_title_21, t0.section_blue_sub_title AS section_blue_sub_title_22, t0.section_blue_title AS section_blue_title_23, t0.section_blue_paragraphe1 AS section_blue_paragraphe1_24, t0.section_blue_paragraphe2 AS section_blue_paragraphe2_25, t0.section4_sub_title AS section4_sub_title_26, t0.section4_title AS section4_title_27, t0.section4_paragraphe AS section4_paragraphe_28, t0.section4_visuel_right_name AS section4_visuel_right_name_29, t0.section4_visuel_right_size AS section4_visuel_right_size_30, t0.section4_visuel_right_updated_at AS section4_visuel_right_updated_at_31, t0.section4_visuel_right_alt AS section4_visuel_right_alt_32, t0.objectif_sub_title AS objectif_sub_title_33, t0.objectif_title AS objectif_title_34, t0.contact_title AS contact_title_35, t0.contact_paragraphe AS contact_paragraphe_36, t0.meta_title AS meta_title_37, t0.meta_description AS meta_description_38, t0.citation AS citation_39, t0.author AS author_40, t0.slug AS slug_41, t0.position AS position_42, t0.is_published AS is_published_43 FROM solution t0 WHERE t0.is_published = ?
Parameters:
[
1
]
|
| 15 | 0.49 ms |
SELECT t0.id AS id_1, t0.template_type AS template_type_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.paragraph_over_title AS paragraph_over_title_5, t0.paragraph_title AS paragraph_title_6, t0.paragraph AS paragraph_7, t0.cta_text AS cta_text_8, t0.cta_link AS cta_link_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.image_updated_at AS image_updated_at_12, t0.image_alt AS image_alt_13, t0.second_paragraph_over_title AS second_paragraph_over_title_14, t0.second_paragraph_title AS second_paragraph_title_15, t0.second_paragraph AS second_paragraph_16, t0.landing_page_id AS landing_page_id_17 FROM landing_page_section t0 WHERE t0.landing_page_id = ?
Parameters:
[
2
]
|
| 16 | 0.22 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt AS image_alt_5, t0.link AS link_6, t0.landing_page_id AS landing_page_id_7 FROM landing_page_partner t0 WHERE t0.landing_page_id = ?
Parameters:
[
2
]
|
| 17 | 0.39 ms |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.position AS position_4, t0.landing_page_id AS landing_page_id_5 FROM landing_page_faq t0 WHERE t0.landing_page_id = ? ORDER BY t0.position ASC
Parameters:
[
2
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Cofondateur\SocleTechniqueBundle\Entity\SEOPage | No errors. |
| App\Entity\SEOPage | No errors. |
| Cofondateur\SocleTechniqueBundle\Entity\SiteSettings | No errors. |
| App\Entity\SiteSettings | No errors. |
| App\Entity\LandingPage | No errors. |
| App\Entity\LandingPageSection | No errors. |
| App\Entity\LandingPagePartner | No errors. |
| App\Entity\LandingPageFaq | No errors. |
| App\Entity\ExpertisePublic | No errors. |
| App\Entity\BlockExpertise | No errors. |
| App\Entity\ReferencePublic |
|
| App\Entity\ExpertisePrive | No errors. |
| App\Entity\ReferencePrive |
|
| App\Entity\ReferenceCity | No errors. |
| App\Entity\ReferenceBloc |
|
| App\Entity\ReferenceMedia | No errors. |
| App\Entity\Solution | No errors. |
| App\Entity\Homepage | No errors. |
| App\Entity\Actualite |
|
| App\Entity\SolutionReference | No errors. |
| App\Entity\SolutionObjectif | No errors. |