Query Metrics
58
Database Queries
23
Different statements
44.30 ms
Query time
15
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
9.70 ms (21.90%) |
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:
[
2956
]
|
3.64 ms (8.21%) |
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 ] |
2.63 ms (5.94%) |
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.60 ms (5.86%) |
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.31 ms (5.21%) |
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.30 ms (5.20%) |
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.11 ms (4.76%) |
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:
[] |
1.95 ms (4.41%) |
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:
[] |
1.78 ms (4.02%) |
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.70 ms (3.83%) |
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:
[
66
]
|
1.64 ms (3.71%) |
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:
[] |
1.52 ms (3.43%) |
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 OFFSET 30
Parameters:
[] |
1.51 ms (3.41%) |
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:
[ [ 2956 2954 2955 2953 2952 2951 2950 2949 2948 2947 ] ] |
1.46 ms (3.30%) |
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:
[ [ 2956 2955 2954 2953 2952 2951 2950 2949 2948 2947 ] ] |
1.40 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:
[] |
1.13 ms (2.55%) |
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.94 ms (2.13%) |
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.83 ms (1.87%) |
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.82 ms (1.84%) |
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.76 ms (1.72%) |
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.57 ms (1.29%) |
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
]
]
|
0.56 ms (1.26%) |
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.44 ms (0.99%) |
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
]
]
|
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. |