Query Metrics

58 Database Queries
23 Different statements
44.30 ms Query time
15 Invalid entities

Grouped Statements

Show all queries

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
  • The mappings App\Entity\Actuality#contactPositions and App\Entity\ContactPosition#actuality are inconsistent with each other.
  • The mappings App\Entity\Actuality#homepageLarge and App\Entity\Homepage#actualitiesSliderLarge are inconsistent with each other.
  • The mappings App\Entity\Actuality#homepageLittle and App\Entity\Homepage#actualitiesSliderLittle are inconsistent with each other.
App\Entity\ActualityPage No errors.
App\Entity\Theme No errors.
App\Entity\Page
  • The mappings App\Entity\Page#contactPositions and App\Entity\ContactPosition#page are inconsistent with each other.
App\Entity\ThemePublication No errors.
App\Entity\About
  • The mappings App\Entity\About#contactPositions and App\Entity\ContactPosition#about are inconsistent with each other.
App\Entity\Composition
  • The mappings App\Entity\Composition#contactPositions and App\Entity\ContactPosition#composition are inconsistent with each other.
App\Entity\DefinitionPage
  • The mappings App\Entity\DefinitionPage#contactPositions and App\Entity\ContactPosition#definitionPage are inconsistent with each other.
App\Entity\Departement
  • The mappings App\Entity\Departement#contactPositions and App\Entity\ContactPosition#departement are inconsistent with each other.
App\Entity\FullMemberPage
  • The mappings App\Entity\FullMemberPage#contactPositions and App\Entity\ContactPosition#fullMemberPage are inconsistent with each other.
App\Entity\Join
  • The mappings App\Entity\Join#contactPositions and App\Entity\ContactPosition#joinPage are inconsistent with each other.
App\Entity\PartenairePage
  • The mappings App\Entity\PartenairePage#contactPositions and App\Entity\ContactPosition#partenairePage are inconsistent with each other.
App\Entity\Publication
  • The mappings App\Entity\Publication#contactPositions and App\Entity\ContactPosition#publication are inconsistent with each other.
App\Entity\PublicationPage
  • The mappings App\Entity\PublicationPage#contactPositions and App\Entity\ContactPosition#publicationPage are inconsistent with each other.
App\Entity\These
  • The mappings App\Entity\These#contactPositions and App\Entity\ContactPosition#these are inconsistent with each other.
App\Entity\ThesePage
  • The mappings App\Entity\ThesePage#contactPositions and App\Entity\ContactPosition#thesePage are inconsistent with each other.
App\Entity\ManuelPage
  • The mappings App\Entity\ManuelPage#contactPositions and App\Entity\ContactPosition#manuelPage are inconsistent with each other.
App\Entity\Section No errors.
App\Entity\DocumentAssociate
  • The mappings App\Entity\DocumentAssociate#page and App\Entity\Page#documentAssociates are inconsistent with each other.
  • If association App\Entity\DocumentAssociate#page is many-to-one, then the inversed side App\Entity\Page#documentAssociates has to be one-to-many.
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.