Query Metrics
76
Database Queries
22
Different statements
62.24 ms
Query time
16
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.91 ms (11.10%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.resume AS resume_3, t0.illustration_name AS illustration_name_4, t0.illustration_size AS illustration_size_5, t0.illustration_updated_at AS illustration_updated_at_6, t0.illustration_alt AS illustration_alt_7, t0.activate AS activate_8, t0.quote AS quote_9, t0.created_at AS created_at_10, t0.about_associate AS about_associate_11, t0.composition_associate AS composition_associate_12, t0.full_member_associate AS full_member_associate_13, t0.departement_associate AS departement_associate_14, t0.partner_associate AS partner_associate_15, t0.publication_associate AS publication_associate_16, t0.these_associate AS these_associate_17, t0.actuality_associate AS actuality_associate_18, t0.definition_associate AS definition_associate_19, t0.manuel_associate AS manuel_associate_20, t0.join_associate AS join_associate_21, t0.old_id AS old_id_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.category_id AS category_id_26, t0.actuality_id AS actuality_id_27, t0.about_id AS about_id_28, t0.composition_id AS composition_id_29, t0.definition_page_id AS definition_page_id_30, t0.departement_id AS departement_id_31, t0.full_member_page_id AS full_member_page_id_32, t0.join_page_id AS join_page_id_33, t0.page_id AS page_id_34, t0.partenaire_page_id AS partenaire_page_id_35, t0.publication_id AS publication_id_36, t0.publication_page_id AS publication_page_id_37, t0.these_id AS these_id_38, t0.these_page_id AS these_page_id_39, t0.homepage_large_id AS homepage_large_id_40, t0.homepage_little_id AS homepage_little_id_41, t0.manuel_page_id AS manuel_page_id_42 FROM actuality t0 WHERE t0.id = ?
Parameters:
[
2980
]
|
4.73 ms (7.60%) |
8 |
SELECT t0.id AS id_1, t0.icon_name AS icon_name_2, t0.icon_size AS icon_size_3, t0.icon_updated_at AS icon_updated_at_4, t0.icon_alt AS icon_alt_5, t0.title AS title_6, t0.quote AS quote_7, t0.about_associate AS about_associate_8, t0.composition_associate AS composition_associate_9, t0.full_member_associate AS full_member_associate_10, t0.departement_associate AS departement_associate_11, t0.partner_associate AS partner_associate_12, t0.publication_associate AS publication_associate_13, t0.these_associate AS these_associate_14, t0.actuality_associate AS actuality_associate_15, t0.manuel_associate AS manuel_associate_16, t0.join_associate AS join_associate_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.position AS position_20 FROM definition_page t0
Parameters:
[] |
4.61 ms (7.40%) |
6 |
SELECT t0.id AS id_1, t0.theme_publication AS theme_publication_2, t0.title AS title_3, t0.icon_name AS icon_name_4, t0.icon_size AS icon_size_5, t0.icon_updated_at AS icon_updated_at_6, t0.icon_alt AS icon_alt_7, t0.quote AS quote_8, t0.about_associate AS about_associate_9, t0.composition_associate AS composition_associate_10, t0.full_member_associate AS full_member_associate_11, t0.departement_associate AS departement_associate_12, t0.partner_associate AS partner_associate_13, t0.publication_associate AS publication_associate_14, t0.these_associate AS these_associate_15, t0.actuality_associate AS actuality_associate_16, t0.definition_associate AS definition_associate_17, t0.manuel_associate AS manuel_associate_18, t0.join_associate AS join_associate_19, t0.activate AS activate_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.position AS position_23, t0.slug AS slug_24, t0.theme_id AS theme_id_25, t0.about_id AS about_id_26, t0.actuality_id AS actuality_id_27, t0.composition_id AS composition_id_28, t0.definition_page_id AS definition_page_id_29, t0.departement_id AS departement_id_30, t0.full_member_page_id AS full_member_page_id_31, t0.join_page_id AS join_page_id_32, t0.page_id AS page_id_33, t0.partenaire_page_id AS partenaire_page_id_34, t0.publication_id AS publication_id_35, t0.publication_page_id AS publication_page_id_36, t0.these_id AS these_id_37, t0.these_page_id AS these_page_id_38, t0.manuel_page_id AS manuel_page_id_39 FROM page t0 WHERE t0.theme_id = ? AND t0.activate = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[ 1 1 ] |
4.60 ms (7.39%) |
8 |
SELECT t0.id AS id_1, t0.icon_name AS icon_name_2, t0.icon_size AS icon_size_3, t0.icon_updated_at AS icon_updated_at_4, t0.icon_alt AS icon_alt_5, t0.title AS title_6, t0.quote AS quote_7, t0.about_associate AS about_associate_8, t0.composition_associate AS composition_associate_9, t0.full_member_associate AS full_member_associate_10, t0.departement_associate AS departement_associate_11, t0.partner_associate AS partner_associate_12, t0.these_associate AS these_associate_13, t0.actuality_associate AS actuality_associate_14, t0.definition_associate AS definition_associate_15, t0.manuel_associate AS manuel_associate_16, t0.join_associate AS join_associate_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.position AS position_20 FROM publication_page t0
Parameters:
[] |
4.44 ms (7.14%) |
8 |
SELECT t0.id AS id_1, t0.icon_name AS icon_name_2, t0.icon_size AS icon_size_3, t0.icon_updated_at AS icon_updated_at_4, t0.icon_alt AS icon_alt_5, t0.title AS title_6, t0.quote AS quote_7, t0.about_associate AS about_associate_8, t0.composition_associate AS composition_associate_9, t0.full_member_associate AS full_member_associate_10, t0.departement_associate AS departement_associate_11, t0.partner_associate AS partner_associate_12, t0.publication_associate AS publication_associate_13, t0.actuality_associate AS actuality_associate_14, t0.definition_associate AS definition_associate_15, t0.manuel_associate AS manuel_associate_16, t0.join_associate AS join_associate_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.position AS position_20 FROM these_page t0
Parameters:
[] |
4.29 ms (6.89%) |
4 |
SELECT t0.id AS id_1, t0.accordeon AS accordeon_2, t0.title AS title_3, t0.position AS position_4, t0.about_id AS about_id_5, t0.composition_id AS composition_id_6, t0.full_member_page_id AS full_member_page_id_7, t0.departement_id AS departement_id_8, t0.partenaire_page_id AS partenaire_page_id_9, t0.page_id AS page_id_10, t0.publication_id AS publication_id_11, t0.publication_page_id AS publication_page_id_12, t0.these_id AS these_id_13, t0.these_page_id AS these_page_id_14, t0.definition_page_id AS definition_page_id_15, t0.actuality_id AS actuality_id_16, t0.join_page_id AS join_page_id_17, t0.manuel_page_id AS manuel_page_id_18 FROM section t0 WHERE t0.actuality_id IN (?)
Parameters:
[
[
2980
]
]
|
4.27 ms (6.86%) |
8 |
SELECT t0.id AS id_1, t0.icon_name AS icon_name_2, t0.icon_size AS icon_size_3, t0.icon_updated_at AS icon_updated_at_4, t0.icon_alt AS icon_alt_5, t0.title AS title_6, t0.about_associate AS about_associate_7, t0.composition_associate AS composition_associate_8, t0.full_member_associate AS full_member_associate_9, t0.departement_associate AS departement_associate_10, t0.publication_associate AS publication_associate_11, t0.these_associate AS these_associate_12, t0.actuality_associate AS actuality_associate_13, t0.definition_associate AS definition_associate_14, t0.manuel_associate AS manuel_associate_15, t0.join_associate AS join_associate_16, t0.quote AS quote_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.position AS position_20 FROM manuel_page t0
Parameters:
[] |
3.80 ms (6.10%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM actuality_label t0 INNER JOIN actuality_actuality_label ON t0.id = actuality_actuality_label.actuality_label_id WHERE actuality_actuality_label.actuality_id = ?
Parameters:
[
2980
]
|
2.78 ms (4.47%) |
4 |
SELECT t0.id AS id_1, t0.color AS color_2, t0.icon_name AS icon_name_3, t0.icon_size AS icon_size_4, t0.icon_updated_at AS icon_updated_at_5, t0.icon_alt AS icon_alt_6, t0.resume AS resume_7, t0.position AS position_8 FROM theme_publication t0
Parameters:
[] |
2.59 ms (4.16%) |
3 |
SELECT t0.id AS id_1, t0.theme_publication AS theme_publication_2, t0.title AS title_3, t0.icon_name AS icon_name_4, t0.icon_size AS icon_size_5, t0.icon_updated_at AS icon_updated_at_6, t0.icon_alt AS icon_alt_7, t0.quote AS quote_8, t0.about_associate AS about_associate_9, t0.composition_associate AS composition_associate_10, t0.full_member_associate AS full_member_associate_11, t0.departement_associate AS departement_associate_12, t0.partner_associate AS partner_associate_13, t0.publication_associate AS publication_associate_14, t0.these_associate AS these_associate_15, t0.actuality_associate AS actuality_associate_16, t0.definition_associate AS definition_associate_17, t0.manuel_associate AS manuel_associate_18, t0.join_associate AS join_associate_19, t0.activate AS activate_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.position AS position_23, t0.slug AS slug_24, t0.theme_id AS theme_id_25, t0.about_id AS about_id_26, t0.actuality_id AS actuality_id_27, t0.composition_id AS composition_id_28, t0.definition_page_id AS definition_page_id_29, t0.departement_id AS departement_id_30, t0.full_member_page_id AS full_member_page_id_31, t0.join_page_id AS join_page_id_32, t0.page_id AS page_id_33, t0.partenaire_page_id AS partenaire_page_id_34, t0.publication_id AS publication_id_35, t0.publication_page_id AS publication_page_id_36, t0.these_id AS these_id_37, t0.these_page_id AS these_page_id_38, t0.manuel_page_id AS manuel_page_id_39 FROM page t0 WHERE t0.theme_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
2.58 ms (4.15%) |
4 |
SELECT t0.id AS id_1, t0.accordeon AS accordeon_2, t0.title AS title_3, t0.position AS position_4, t0.about_id AS about_id_5, t0.composition_id AS composition_id_6, t0.full_member_page_id AS full_member_page_id_7, t0.departement_id AS departement_id_8, t0.partenaire_page_id AS partenaire_page_id_9, t0.page_id AS page_id_10, t0.publication_id AS publication_id_11, t0.publication_page_id AS publication_page_id_12, t0.these_id AS these_id_13, t0.these_page_id AS these_page_id_14, t0.definition_page_id AS definition_page_id_15, t0.actuality_id AS actuality_id_16, t0.join_page_id AS join_page_id_17, t0.manuel_page_id AS manuel_page_id_18 FROM section t0 WHERE t0.page_id IN (?)
Parameters:
[ [ 1 2 3 4 5 ] ] |
2.39 ms (3.84%) |
1 |
SELECT t0.id AS id_1, t0.about_image1_name AS about_image1_name_2, t0.about_image1_size AS about_image1_size_3, t0.about_image1_updated_at AS about_image1_updated_at_4, t0.about_image1_alt AS about_image1_alt_5, t0.about_image2_name AS about_image2_name_6, t0.about_image2_size AS about_image2_size_7, t0.about_image2_updated_at AS about_image2_updated_at_8, t0.about_image2_alt AS about_image2_alt_9, t0.about_image3_name AS about_image3_name_10, t0.about_image3_size AS about_image3_size_11, t0.about_image3_updated_at AS about_image3_updated_at_12, t0.about_image3_alt AS about_image3_alt_13, t0.about_title AS about_title_14, t0.about_paragraph AS about_paragraph_15, t0.cta_text AS cta_text_16, t0.cta_link AS cta_link_17, t0.partner_logo1_name AS partner_logo1_name_18, t0.partner_logo1_size AS partner_logo1_size_19, t0.partner_logo1_updated_at AS partner_logo1_updated_at_20, t0.partner_logo1_alt AS partner_logo1_alt_21, t0.partner1_link AS partner1_link_22, t0.partner_logo2_name AS partner_logo2_name_23, t0.partner_logo2_size AS partner_logo2_size_24, t0.partner_logo2_updated_at AS partner_logo2_updated_at_25, t0.partner_logo2_alt AS partner_logo2_alt_26, t0.partner2_link AS partner2_link_27, t0.quote AS quote_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30 FROM homepage t0
Parameters:
[] |
2.37 ms (3.81%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.actuality_id AS actuality_id_3, t0.homepage_slider_large_id AS homepage_slider_large_id_4, t0.homepage_slider_little_id AS homepage_slider_little_id_5 FROM homepage_actuality t0 WHERE t0.homepage_slider_large_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
2.20 ms (3.53%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.actuality_id AS actuality_id_3, t0.homepage_slider_large_id AS homepage_slider_large_id_4, t0.homepage_slider_little_id AS homepage_slider_little_id_5 FROM homepage_actuality t0 WHERE t0.homepage_slider_little_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
2.19 ms (3.52%) |
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_homepage"
]
|
1.74 ms (2.79%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.old_id AS old_id_3, t0.slug AS slug_4 FROM actuality_category t0 WHERE t0.id = ?
Parameters:
[
5
]
|
1.54 ms (2.47%) |
2 |
SELECT t0.rna AS rna_1, t0.id AS id_2, t0.phone AS phone_3, t0.email AS email_4, t0.address_street AS address_street_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:
[] |
1.37 ms (2.20%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.icon_name AS icon_name_4, t0.icon_size AS icon_size_5, t0.icon_updated_at AS icon_updated_at_6, t0.icon_alt AS icon_alt_7, t0.resume AS resume_8, t0.slug AS slug_9, t0.position AS position_10 FROM theme t0 ORDER BY t0.position ASC
Parameters:
[] |
1.17 ms (1.89%) |
2 |
SELECT t0.id AS id_1, t0.theme_publication AS theme_publication_2, t0.title AS title_3, t0.icon_name AS icon_name_4, t0.icon_size AS icon_size_5, t0.icon_updated_at AS icon_updated_at_6, t0.icon_alt AS icon_alt_7, t0.quote AS quote_8, t0.about_associate AS about_associate_9, t0.composition_associate AS composition_associate_10, t0.full_member_associate AS full_member_associate_11, t0.departement_associate AS departement_associate_12, t0.partner_associate AS partner_associate_13, t0.publication_associate AS publication_associate_14, t0.these_associate AS these_associate_15, t0.actuality_associate AS actuality_associate_16, t0.definition_associate AS definition_associate_17, t0.manuel_associate AS manuel_associate_18, t0.join_associate AS join_associate_19, t0.activate AS activate_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.position AS position_23, t0.slug AS slug_24, t0.theme_id AS theme_id_25, t0.about_id AS about_id_26, t0.actuality_id AS actuality_id_27, t0.composition_id AS composition_id_28, t0.definition_page_id AS definition_page_id_29, t0.departement_id AS departement_id_30, t0.full_member_page_id AS full_member_page_id_31, t0.join_page_id AS join_page_id_32, t0.page_id AS page_id_33, t0.partenaire_page_id AS partenaire_page_id_34, t0.publication_id AS publication_id_35, t0.publication_page_id AS publication_page_id_36, t0.these_id AS these_id_37, t0.these_page_id AS these_page_id_38, t0.manuel_page_id AS manuel_page_id_39 FROM page t0 WHERE t0.activate = ? AND t0.theme_publication = ? ORDER BY t0.position ASC
Parameters:
[ 1 1 ] |
0.73 ms (1.17%) |
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
Parameters:
[] |
0.48 ms (0.77%) |
1 |
SELECT t0.id AS id_1, t0.accordeon AS accordeon_2, t0.title AS title_3, t0.position AS position_4, t0.about_id AS about_id_5, t0.composition_id AS composition_id_6, t0.full_member_page_id AS full_member_page_id_7, t0.departement_id AS departement_id_8, t0.partenaire_page_id AS partenaire_page_id_9, t0.page_id AS page_id_10, t0.publication_id AS publication_id_11, t0.publication_page_id AS publication_page_id_12, t0.these_id AS these_id_13, t0.these_page_id AS these_page_id_14, t0.definition_page_id AS definition_page_id_15, t0.actuality_id AS actuality_id_16, t0.join_page_id AS join_page_id_17, t0.manuel_page_id AS manuel_page_id_18 FROM section t0 WHERE t0.manuel_page_id IN (?)
Parameters:
[
[
1
]
]
|
0.47 ms (0.76%) |
1 |
SELECT t0.id AS id_1, t0.accordeon AS accordeon_2, t0.title AS title_3, t0.position AS position_4, t0.about_id AS about_id_5, t0.composition_id AS composition_id_6, t0.full_member_page_id AS full_member_page_id_7, t0.departement_id AS departement_id_8, t0.partenaire_page_id AS partenaire_page_id_9, t0.page_id AS page_id_10, t0.publication_id AS publication_id_11, t0.publication_page_id AS publication_page_id_12, t0.these_id AS these_id_13, t0.these_page_id AS these_page_id_14, t0.definition_page_id AS definition_page_id_15, t0.actuality_id AS actuality_id_16, t0.join_page_id AS join_page_id_17, t0.manuel_page_id AS manuel_page_id_18 FROM section t0 WHERE t0.publication_page_id IN (?)
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.
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\Homepage | No errors. |
App\Entity\HomepageActuality | No errors. |
App\Entity\Theme | No errors. |
App\Entity\Page |
|
App\Entity\ThemePublication | No errors. |
App\Entity\About |
|
App\Entity\Actuality |
|
App\Entity\Composition |
|
App\Entity\DefinitionPage |
|
App\Entity\Departement |
|
App\Entity\FullMemberPage |
|
App\Entity\Join |
|
App\Entity\PartenairePage |
|
App\Entity\Publication |
|
App\Entity\PublicationPage |
|
App\Entity\These |
|
App\Entity\ThesePage |
|
App\Entity\ManuelPage |
|
App\Entity\Section | No errors. |
App\Entity\DocumentAssociate |
|
App\Entity\ContactAssociate | No errors. |
App\Entity\ContactPosition | No errors. |
App\Entity\Paragraph | No errors. |
App\Entity\ActualityCategory | No errors. |
App\Entity\ActualityLabel | No errors. |
App\Entity\HistoricalFriezeField | No errors. |
App\Entity\TeamMember | No errors. |
App\Entity\FullMember | No errors. |
App\Entity\Partenaire | No errors. |
App\Entity\Book | No errors. |
App\Entity\Logo | No errors. |
App\Entity\Newsletter | No errors. |
App\Entity\Manuel | No errors. |
App\Entity\Definition | No errors. |
App\Entity\Contact | No errors. |
App\Entity\ActualityPage | No errors. |
Cofondateur\SocleTechniqueBundle\Entity\User | No errors. |
App\Entity\User | No errors. |
App\Entity\ContactPage | No errors. |
Cofondateur\SocleTechniqueBundle\Entity\Product |
|
Cofondateur\SocleTechniqueBundle\Entity\ProductTranslation | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |
Lexik\Bundle\TranslationBundle\Model\Translation | No errors. |
Lexik\Bundle\TranslationBundle\Entity\Translation | No errors. |
Lexik\Bundle\TranslationBundle\Model\File | No errors. |
Lexik\Bundle\TranslationBundle\Entity\File | No errors. |
Lexik\Bundle\TranslationBundle\Model\TransUnit | No errors. |
Lexik\Bundle\TranslationBundle\Entity\TransUnit | No errors. |