Query Metrics
21
Database Queries
12
Different statements
17.27 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.48 ms (54.89%) |
1 |
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
]
|
|
2.92 ms (16.90%) |
1 |
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_reference_public_show"
]
|
|
2.18 ms (12.63%) |
10 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM reference_city t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.36 ms (2.08%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"schema-directeur-des-energies"
]
|
|
0.34 ms (1.99%) |
1 |
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:
[] |
|
0.34 ms (1.95%) |
1 |
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 ORDER BY t0.id DESC LIMIT 3
Parameters:
[] |
|
0.32 ms (1.87%) |
1 |
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:
[] |
|
0.29 ms (1.70%) |
1 |
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:
[] |
|
0.27 ms (1.59%) |
1 |
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.section1_visuel_bottom_name AS section1_visuel_bottom_name_14, t0.section1_visuel_bottom_size AS section1_visuel_bottom_size_15, t0.section1_visuel_bottom_updated_at AS section1_visuel_bottom_updated_at_16, t0.section1_visuel_bottom_alt AS section1_visuel_bottom_alt_17, t0.section2_sub_title AS section2_sub_title_18, t0.section2_title AS section2_title_19, t0.section2_paragraphe AS section2_paragraphe_20, t0.section2_visuel_name AS section2_visuel_name_21, t0.section2_visuel_size AS section2_visuel_size_22, t0.section2_visuel_updated_at AS section2_visuel_updated_at_23, t0.section2_visuel_alt AS section2_visuel_alt_24, t0.citationsub_title AS citationsub_title_25, t0.section_blue_sub_title AS section_blue_sub_title_26, t0.section_blue_title AS section_blue_title_27, t0.section_blue_paragraphe1 AS section_blue_paragraphe1_28, t0.section_blue_paragraphe2 AS section_blue_paragraphe2_29, t0.section4_sub_title AS section4_sub_title_30, t0.section4_title AS section4_title_31, t0.section4_paragraphe AS section4_paragraphe_32, t0.section4_visuel_right_name AS section4_visuel_right_name_33, t0.section4_visuel_right_size AS section4_visuel_right_size_34, t0.section4_visuel_right_updated_at AS section4_visuel_right_updated_at_35, t0.section4_visuel_right_alt AS section4_visuel_right_alt_36, t0.section4_visuel_bottom_name AS section4_visuel_bottom_name_37, t0.section4_visuel_bottom_size AS section4_visuel_bottom_size_38, t0.section4_visuel_bottom_updated_at AS section4_visuel_bottom_updated_at_39, t0.section4_visuel_bottom_alt AS section4_visuel_bottom_alt_40, t0.objectif_sub_title AS objectif_sub_title_41, t0.objectif_title AS objectif_title_42, t0.contact_title AS contact_title_43, t0.contact_paragraphe AS contact_paragraphe_44, t0.meta_title AS meta_title_45, t0.meta_description AS meta_description_46, t0.citation AS citation_47, t0.author AS author_48, t0.slug AS slug_49, t0.position AS position_50, t0.is_published AS is_published_51 FROM solution t0 WHERE t0.is_published = ?
Parameters:
[
1
]
|
|
0.27 ms (1.58%) |
1 |
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
]
|
|
0.25 ms (1.42%) |
1 |
SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.paragraphe AS paragraphe_4, t0.visuel_name AS visuel_name_5, t0.visuel_size AS visuel_size_6, t0.visuel_updated_at AS visuel_updated_at_7, t0.visuel_alt AS visuel_alt_8, t0.pdf_name AS pdf_name_9, t0.pdf_size AS pdf_size_10, t0.pdf_updated_at AS pdf_updated_at_11, t0.cta_link AS cta_link_12, t0.cta_text AS cta_text_13, t0.cta_external AS cta_external_14, t0.reference_public_id AS reference_public_id_15, t0.reference_prive_id AS reference_prive_id_16 FROM reference_bloc t0 WHERE t0.reference_public_id = ?
Parameters:
[
13
]
|
|
0.24 ms (1.39%) |
1 |
SELECT t0.id AS id_1, t0.media_name AS media_name_2, t0.media_size AS media_size_3, t0.media_updated_at AS media_updated_at_4, t0.media_alt AS media_alt_5, t0.position AS position_6, t0.reference_public_id AS reference_public_id_7, t0.reference_prive_id AS reference_prive_id_8 FROM reference_media t0 WHERE t0.reference_public_id = ? ORDER BY t0.position ASC
Parameters:
[
13
]
|
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\ReferencePublic |
|
| App\Entity\ReferenceCity | No errors. |
| App\Entity\ReferenceBloc |
|
| App\Entity\ReferenceMedia | No errors. |
| App\Entity\ExpertisePublic | No errors. |
| App\Entity\Solution | No errors. |
| App\Entity\Homepage | No errors. |
| App\Entity\Actualite |
|
| App\Entity\SolutionReference | No errors. |
| App\Entity\BlockExpertise | No errors. |
| App\Entity\ExpertisePrive | No errors. |
| App\Entity\ReferencePrive |
|