Query Metrics

54 Database Queries
22 Different statements
47.47 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.marque AS marque_2, t0.categorie AS categorie_3, t0.type AS type_4, t0.intervention AS intervention_5, t0.duree AS duree_6, t0.count AS count_7, t0.original_duree AS original_duree_8, t0.intervention_categorie_id AS intervention_categorie_id_9 FROM intervention t0 WHERE t0.id = ?
Parameters:
[
  "42"
]
2 0.63 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.rank AS rank_4, t0.text AS text_5, t0.faq_id AS faq_id_6 FROM groupe_service t0 WHERE t0.category = ? ORDER BY t0.rank ASC
Parameters:
[
  "Entretien courant"
]
3 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.count_sub_intervention AS count_sub_intervention_3 FROM intervention_categorie t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Entretien courant"
]
4 1.24 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.opening_hours_periods AS opening_hours_periods_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.ville AS ville_5, e0_.telephone AS telephone_6, e0_.email AS email_7, e0_.concession_email AS concession_email_8, e0_.concession_telephone AS concession_telephone_9, e0_.latitude AS latitude_10, e0_.longtitude AS longtitude_11, e0_.detail_stockage AS detail_stockage_12 FROM etablissement e0_ WHERE e0_.latitude IS NOT NULL AND e0_.count_car > 0 AND e0_.longtitude IS NOT NULL AND e0_.publie = 1 AND e0_.detail_stockage IS NULL ORDER BY e0_.name ASC
Parameters:
[]
5 6.53 ms
SELECT b0_.id AS id_0, b0_.post_id AS post_id_1, b0_.date AS date_2, b0_.modified_date AS modified_date_3, b0_.title AS title_4, b0_.content AS content_5, b0_.text AS text_6, b0_.tag_id AS tag_id_7, b0_.tag_name AS tag_name_8, b0_.media_id AS media_id_9, b0_.media_source_url AS media_source_url_10, b0_.link AS link_11 FROM blog_post b0_ INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id WHERE b0_.tag_id IS NOT NULL AND b1_.category_id <> 1 ORDER BY b0_.date DESC LIMIT 16
Parameters:
[]
6 0.57 ms
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.count_sub_intervention AS count_sub_intervention_2 FROM intervention_categorie i0_ WHERE i0_.id <> ? ORDER BY i0_.count_sub_intervention DESC
Parameters:
[
  1
]
7 1.40 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  6
]
8 0.58 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  7
]
9 0.40 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  4
]
10 0.60 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  5
]
11 0.38 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  2
]
12 0.48 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  8
]
13 0.36 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  9
]
14 1.43 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  10
]
15 0.43 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  11
]
16 0.39 ms
SELECT i0_.id AS id_0, i0_.marque AS marque_1, i0_.categorie AS categorie_2, i0_.type AS type_3, i0_.intervention AS intervention_4, i0_.duree AS duree_5, i0_.count AS count_6, i0_.original_duree AS original_duree_7 FROM intervention i0_ WHERE i0_.intervention_categorie_id = ? GROUP BY i0_.type ORDER BY i0_.count DESC
Parameters:
[
  3
]
17 0.22 ms
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.count_sub_intervention AS count_sub_intervention_2 FROM intervention_categorie i0_ WHERE i0_.id <> 1
Parameters:
[]
18 0.82 ms
SELECT distinct cm.name FROM etablissement e
                INNER JOIN etablissement_car_marque ecm ON ecm.etablissement_id = e.id
                INNER JOIN car_marque cm ON cm.id = ecm.car_marque_id
Parameters:
[]
19 0.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "intervention_detail"
]
20 0.52 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
21 0.35 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
22 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "intervention_detail"
]
23 0.26 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
24 0.21 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
25 0.25 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
26 0.24 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
27 0.48 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "intervention_detail"
]
28 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.identifier AS identifier_4, t0.content AS content_5, t0.hektor_text_logged AS hektor_text_logged_6, t0.hektor_text_not_logged AS hektor_text_not_logged_7, t0.hektor_text_is_differnet AS hektor_text_is_differnet_8, t0.cms_page_id AS cms_page_id_9 FROM cms_bloc t0 WHERE t0.cms_page_id = ?
Parameters:
[
  52
]
29 0.38 ms
SELECT DATABASE()
Parameters:
[]
30 1.20 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "tressol-chabrier"
]
31 0.42 ms
SELECT DATABASE()
Parameters:
[]
32 1.10 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "tressol-chabrier"
]
33 0.16 ms
SELECT DATABASE()
Parameters:
[]
34 0.52 ms
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
35 0.12 ms
SELECT DATABASE()
Parameters:
[]
36 0.93 ms
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'tressol-chabrier' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
37 14.40 ms
SELECT       c.COLUMN_NAME        AS field,
           IF(
        x.CHECK_CLAUSE IS NOT NULL AND c.COLUMN_TYPE = 'longtext',
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
    LEFT JOIN information_schema.CHECK_CONSTRAINTS x
    ON (
        c.TABLE_SCHEMA = x.CONSTRAINT_SCHEMA
        AND c.TABLE_NAME = x.TABLE_NAME
        AND x.CHECK_CLAUSE = CONCAT('json_valid(`', c.COLUMN_NAME , '`)')
    ) WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "tressol-chabrier"
  "tressol-chabrier"
  "doctrine_migration_versions"
]
38 0.22 ms
SELECT DATABASE()
Parameters:
[]
39 0.37 ms
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
40 0.24 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
41 0.14 ms
SELECT DATABASE()
Parameters:
[]
42 0.45 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.legales_text AS legales_text_5 FROM promo t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
43 0.70 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
44 0.50 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
45 0.47 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "BRAND"
]
46 0.23 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
47 0.31 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "BRAND"
]
48 0.20 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
49 0.23 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "BRAND"
]
50 1.57 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.opening_hours_periods AS opening_hours_periods_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.ville AS ville_5, e0_.telephone AS telephone_6, e0_.email AS email_7, e0_.concession_email AS concession_email_8, e0_.concession_telephone AS concession_telephone_9, e0_.latitude AS latitude_10, e0_.longtitude AS longtitude_11, e0_.detail_stockage AS detail_stockage_12, c1_.name AS name_13 FROM etablissement e0_ LEFT JOIN etablissement_car_marque e2_ ON e0_.id = e2_.etablissement_id LEFT JOIN car_marque c1_ ON c1_.id = e2_.car_marque_id WHERE ((e0_.latitude IS NOT NULL AND e0_.count_car > 0 AND e0_.longtitude IS NOT NULL AND e0_.publie = 1) OR e0_.id = ?) AND e0_.detail_stockage IS NULL ORDER BY e0_.name ASC
Parameters:
[
  158
]
51 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_for_meeting AS name_for_meeting_3, t0.description AS description_4, t0.image_id AS image_id_5 FROM expert t0
Parameters:
[]
52 0.40 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
53 0.29 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "BRAND"
]
54 0.53 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
internal doctrine.dbal.internal_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
internal doctrine.orm.internal_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Intervention No errors.
App\Entity\InterventionCategorie No errors.
App\Entity\GroupeService No errors.
App\Entity\InterventionFAQ No errors.
App\Entity\Etablissement No errors.
App\Entity\BlogPost No errors.
App\Entity\BlogCategory No errors.
App\Entity\CmsPage No errors.
App\Entity\CmsBloc No errors.
App\Entity\DataCount No errors.
App\Entity\User No errors.
App\Entity\CarMarque No errors.
App\Entity\EtablissementService No errors.
App\Entity\ReviewDetail No errors.
App\Entity\ExpertContact No errors.
App\Entity\LeadEstimate No errors.
App\Entity\PrendreRdv No errors.
App\Entity\Meeting No errors.
App\Entity\ClientRequest No errors.
App\Entity\Car No errors.
App\Entity\GroupEtablissement No errors.
App\Entity\Lead No errors.
App\Entity\NewsletterSubscription No errors.
App\Entity\Promo No errors.
App\Entity\PromoSlider No errors.
App\Entity\Bca No errors.
App\Entity\Role No errors.
App\Entity\Newsletters No errors.
App\Entity\VehicleAlert No errors.
App\Entity\Favorite No errors.
App\Entity\Comparative No errors.
App\Entity\UserVehicle No errors.
App\Entity\UserPayment No errors.
App\Entity\MyBuyProject No errors.
App\Entity\Configurator No errors.
App\Entity\Document No errors.
App\Entity\CarModele No errors.
App\Entity\MarqueNews No errors.
App\Entity\Upload No errors.
App\Entity\Expert No errors.
App\Entity\MyMaintainProjectAction No errors.
App\Entity\CarMedia No errors.
App\Entity\CarAddition No errors.
App\Entity\CarEntretien No errors.
App\Entity\MySellProjectAction No errors.
App\Entity\MyBuyProjectAction No errors.

internal entity manager

No loaded entities.