Query Metrics
60
Database Queries
23
Different statements
57.36 ms
Query time
16
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
12.74 ms (22.20%) |
10 |
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:
[
2985
]
|
4.99 ms (8.71%) |
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 ] |
3.73 ms (6.51%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_9 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.resume AS resume_2, a0_.illustration_name AS illustration_name_3, a0_.illustration_size AS illustration_size_4, a0_.illustration_updated_at AS illustration_updated_at_5, a0_.illustration_alt AS illustration_alt_6, a0_.activate AS activate_7, a0_.quote AS quote_8, a0_.created_at AS created_at_9, a0_.about_associate AS about_associate_10, a0_.composition_associate AS composition_associate_11, a0_.full_member_associate AS full_member_associate_12, a0_.departement_associate AS departement_associate_13, a0_.partner_associate AS partner_associate_14, a0_.publication_associate AS publication_associate_15, a0_.these_associate AS these_associate_16, a0_.actuality_associate AS actuality_associate_17, a0_.definition_associate AS definition_associate_18, a0_.manuel_associate AS manuel_associate_19, a0_.join_associate AS join_associate_20, a0_.old_id AS old_id_21, a0_.meta_title AS meta_title_22, a0_.meta_description AS meta_description_23, a0_.slug AS slug_24 FROM actuality a0_ WHERE a0_.activate = 1) dctrn_result_inner ORDER BY created_at_9 DESC) dctrn_result LIMIT 10
Parameters:
[] |
3.30 ms (5.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.actuality_id IN (?)
Parameters:
[ [ 2985 2984 2982 2983 2980 2979 2978 1 2977 2976 ] ] |
3.27 ms (5.69%) |
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 ] ] |
3.13 ms (5.45%) |
4 |
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
]
|
2.86 ms (4.99%) |
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.resume AS resume_2, a0_.illustration_name AS illustration_name_3, a0_.illustration_size AS illustration_size_4, a0_.illustration_updated_at AS illustration_updated_at_5, a0_.illustration_alt AS illustration_alt_6, a0_.activate AS activate_7, a0_.quote AS quote_8, a0_.created_at AS created_at_9, a0_.about_associate AS about_associate_10, a0_.composition_associate AS composition_associate_11, a0_.full_member_associate AS full_member_associate_12, a0_.departement_associate AS departement_associate_13, a0_.partner_associate AS partner_associate_14, a0_.publication_associate AS publication_associate_15, a0_.these_associate AS these_associate_16, a0_.actuality_associate AS actuality_associate_17, a0_.definition_associate AS definition_associate_18, a0_.manuel_associate AS manuel_associate_19, a0_.join_associate AS join_associate_20, a0_.old_id AS old_id_21, a0_.meta_title AS meta_title_22, a0_.meta_description AS meta_description_23, a0_.slug AS slug_24, a0_.category_id AS category_id_25, a0_.actuality_id AS actuality_id_26, a0_.about_id AS about_id_27, a0_.composition_id AS composition_id_28, a0_.definition_page_id AS definition_page_id_29, a0_.departement_id AS departement_id_30, a0_.full_member_page_id AS full_member_page_id_31, a0_.join_page_id AS join_page_id_32, a0_.page_id AS page_id_33, a0_.partenaire_page_id AS partenaire_page_id_34, a0_.publication_id AS publication_id_35, a0_.publication_page_id AS publication_page_id_36, a0_.these_id AS these_id_37, a0_.these_page_id AS these_page_id_38, a0_.homepage_large_id AS homepage_large_id_39, a0_.homepage_little_id AS homepage_little_id_40, a0_.manuel_page_id AS manuel_page_id_41 FROM actuality a0_ WHERE a0_.activate = 1 AND a0_.id IN (?) ORDER BY a0_.created_at DESC
Parameters:
[ [ 2985 2984 2982 2983 2980 2979 2978 1 2977 2976 ] ] |
2.80 ms (4.88%) |
4 |
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:
[] |
2.65 ms (4.62%) |
4 |
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:
[] |
2.55 ms (4.45%) |
4 |
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:
[] |
2.48 ms (4.32%) |
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.30 ms (4.00%) |
4 |
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:
[] |
2.01 ms (3.50%) |
3 |
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:
[] |
1.81 ms (3.16%) |
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:
[] |
0.90 ms (1.57%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.quote AS quote_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5 FROM actuality_page t0
Parameters:
[] |
0.88 ms (1.54%) |
1 |
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
Parameters:
[] |
0.83 ms (1.44%) |
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_actuality_list"
]
|
0.82 ms (1.43%) |
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.78 ms (1.36%) |
1 |
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.71 ms (1.24%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.resume AS resume_2, a0_.illustration_name AS illustration_name_3, a0_.illustration_size AS illustration_size_4, a0_.illustration_updated_at AS illustration_updated_at_5, a0_.illustration_alt AS illustration_alt_6, a0_.activate AS activate_7, a0_.quote AS quote_8, a0_.created_at AS created_at_9, a0_.about_associate AS about_associate_10, a0_.composition_associate AS composition_associate_11, a0_.full_member_associate AS full_member_associate_12, a0_.departement_associate AS departement_associate_13, a0_.partner_associate AS partner_associate_14, a0_.publication_associate AS publication_associate_15, a0_.these_associate AS these_associate_16, a0_.actuality_associate AS actuality_associate_17, a0_.definition_associate AS definition_associate_18, a0_.manuel_associate AS manuel_associate_19, a0_.join_associate AS join_associate_20, a0_.old_id AS old_id_21, a0_.meta_title AS meta_title_22, a0_.meta_description AS meta_description_23, a0_.slug AS slug_24 FROM actuality a0_ WHERE a0_.activate = 1 ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[] |
0.71 ms (1.23%) |
1 |
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:
[] |
0.58 ms (1.02%) |
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.54 ms (0.94%) |
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\ActualityCategory | No errors. |
App\Entity\ActualityLabel | No errors. |
App\Entity\Actuality |
|
App\Entity\ActualityPage | No errors. |
App\Entity\Theme | No errors. |
App\Entity\Page |
|
App\Entity\ThemePublication | No errors. |
App\Entity\About |
|
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\Homepage | No errors. |
App\Entity\HomepageActuality | 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. |
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. |