Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

5 Database Queries

4 Different statements

2.72 ms Query time

5 Invalid entities

Queries

Group similar statements


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
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
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 WHERE t0.slug = ? LIMIT 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 IS NULL LIMIT 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

#▲	Time	Info
1	0.93 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_expertise_public_show"`] View formatted query View runnable query Explain query 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 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 = 'app_expertise_public_show' LIMIT 1;
2	0.47 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: [] View formatted query View runnable query Explain query 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 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;
3	0.70 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 WHERE t0.slug = ? LIMIT 1 Parameters: [`"1.png"`] View formatted query View runnable query Explain query 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 WHERE t0.slug = ? LIMIT 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 WHERE t0.slug = '1.png' LIMIT 1;
4	0.35 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 IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query 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 IS NULL LIMIT 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 IS NULL LIMIT 1;
5	0.26 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: [] View formatted query View runnable query Explain query 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 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;

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\ExpertisePublic	No errors.
App\Entity\BlockExpertise	No errors.
App\Entity\ReferencePublic	The mappings App\Entity\ReferencePublic#blocs and App\Entity\ReferenceBloc#referencePublic are inconsistent with each other.
App\Entity\ExpertisePrive	No errors.
App\Entity\ReferenceCity	No errors.
App\Entity\ReferenceBloc	The association App\Entity\ReferenceBloc#referencePublic refers to the inverse side field App\Entity\ReferencePublic#referenceBlocs which does not exist. The association App\Entity\ReferenceBloc#referencePrive refers to the inverse side field App\Entity\ReferencePrive#referenceBlocs which does not exist.
App\Entity\ReferenceMedia	No errors.
App\Entity\Solution	No errors.
App\Entity\Homepage	No errors.
App\Entity\Actualite	The mappings App\Entity\Actualite#referencesPrive and App\Entity\ReferencePrive#actualites are inconsistent with each other.
App\Entity\SolutionReference	No errors.
App\Entity\Team	No errors.
App\Entity\SolutionObjectif	No errors.
App\Entity\LandingPagePartner	No errors.
App\Entity\Presentation	No errors.
App\Entity\HashtagTeam	No errors.
App\Entity\JobOfferType	No errors.
App\Entity\Contact	No errors.
App\Entity\ContactLanding	No errors.
App\Entity\ActualiteParagraph	No errors.
App\Entity\ContactPage	No errors.
Cofondateur\SocleTechniqueBundle\Entity\User	No errors.
App\Entity\User	No errors.
App\Entity\ActualiteGalleriePhoto	No errors.
App\Entity\ExpertisePage	No errors.
App\Entity\PartenairesHp	No errors.
App\Entity\JobOfferParagraph	No errors.
App\Entity\LandingPage	No errors.
App\Entity\JobOffer	No errors.
App\Entity\ActualiteHashtag	No errors.
App\Entity\ActualiteGallerieVideo	No errors.
App\Entity\JobOfferPage	No errors.
App\Entity\ReferencePrive	The mappings App\Entity\ReferencePrive#blocs and App\Entity\ReferenceBloc#referencePrive are inconsistent with each other. The association App\Entity\ReferencePrive#actualites refers to the owning side field App\Entity\Actualite#ReferencePrive which does not exist.
App\Entity\LandingPageFaq	No errors.
App\Entity\LandingPageSection	No errors.
App\Entity\TeamMember	No errors.
App\Entity\JobOfferCandidacy	No errors.
App\Entity\SolutionPage	No errors.
App\Entity\ReferencePage	No errors.
App\Entity\CategoryActualite	No errors.
App\Entity\ValeursEngagements	No errors.
App\Entity\Accordeons	No errors.
Cofondateur\SocleTechniqueBundle\Entity\ProductTranslation	No errors.
Cofondateur\SocleTechniqueBundle\Entity\Product	The target entity 'Cofondateur\SocleTechniqueBundle\Entity\User' specified on Cofondateur\SocleTechniqueBundle\Entity\Product#updatedBy is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
Vich\UploaderBundle\Entity\File	No errors.
Lexik\Bundle\TranslationBundle\Model\Translation	No errors.
Lexik\Bundle\TranslationBundle\Entity\Translation	No errors.
Lexik\Bundle\TranslationBundle\Model\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Model\File	No errors.
Lexik\Bundle\TranslationBundle\Entity\File	No errors.

Symfony Profiler

https://noocarb.asb-digital.fr/expertises-decarbonation/publique/1.png

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping