Symfony Profiler

Query Metrics

38 Database Queries

20 Different statements

40.36 ms Query time

0 Invalid entities

Queries

default connection


SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.natcode AS natcode_2, c0_.state AS state_3, c0_.brand_logo AS brand_logo_4, c0_.description AS description_5, c0_.ranking_score AS ranking_score_6, c0_.ranking_score_vn AS ranking_score_vn_7, c0_.regroupement AS regroupement_8, c0_.total_vo AS total_vo_9, c0_.total_vn AS total_vn_10, e1_.id AS id_11, e1_.name AS name_12, e1_.alias AS alias_13, e1_.adresse AS adresse_14, e1_.postal_code AS postal_code_15, e1_.telephone AS telephone_16, e1_.contact_nom AS contact_nom_17, e1_.photos AS photos_18, e1_.fax AS fax_19, e1_.state AS state_20, e1_.count_car AS count_car_21, e1_.ville AS ville_22, e1_.latitude AS latitude_23, e1_.longtitude AS longtitude_24, e1_.description AS description_25, e1_.cgi_code AS cgi_code_26, e1_.time_week_morning_start AS time_week_morning_start_27, e1_.time_week_morning_end AS time_week_morning_end_28, e1_.time_week_afternoon_start AS time_week_afternoon_start_29, e1_.time_week_afternoon_end AS time_week_afternoon_end_30, e1_.time_we_morning_start AS time_we_morning_start_31, e1_.time_we_morning_end AS time_we_morning_end_32, e1_.time_we_afternoon_start AS time_we_afternoon_start_33, e1_.time_we_afternoon_end AS time_we_afternoon_end_34, e1_.autolink_id AS autolink_id_35, e1_.email AS email_36, e1_.image AS image_37, e1_.siren AS siren_38, e1_.autodiscount_name AS autodiscount_name_39, e1_.autodiscount_email AS autodiscount_email_40, e1_.autodiscount_phone AS autodiscount_phone_41, e1_.concession_email AS concession_email_42, e1_.concession_telephone AS concession_telephone_43, e1_.virtuel AS virtuel_44, e1_.id_base_tressol AS id_base_tressol_45, e1_.id_google AS id_google_46, e1_.affaire AS affaire_47, e1_.siret AS siret_48, e1_.garage_auto AS garage_auto_49, e1_.garage_moto AS garage_moto_50, e1_.occasion_pro AS occasion_pro_51, e1_.publie AS publie_52, e1_.experts AS experts_53, e1_.total_review AS total_review_54, e1_.average_review_rating AS average_review_rating_55, e1_.seo_description AS seo_description_56, e1_.opening_hours_text AS opening_hours_text_57, e1_.opening_hours_periods AS opening_hours_periods_58, e1_.raison_sociale AS raison_sociale_59, e1_.detail_stockage AS detail_stockage_60, e1_.street_number AS street_number_61, e1_.route AS route_62, e1_.bigquery AS bigquery_63, e1_.email_lead_vo AS email_lead_vo_64, e1_.disabled_google AS disabled_google_65, e1_.enable_json_lead AS enable_json_lead_66, e1_.show_if_no_stock AS show_if_no_stock_67, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_68, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_69, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_70, e1_.mecaplanning_site_code AS mecaplanning_site_code_71, e1_.mecaplanning_site_id AS mecaplanning_site_id_72, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_73, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_74, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_75 FROM car_marque c0_ INNER JOIN etablissement_car_marque e2_ ON c0_.id = e2_.car_marque_id INNER JOIN etablissement e1_ ON e1_.id = e2_.etablissement_id WHERE e1_.detail_stockage IS NULL AND e1_.publie = 1 AND c0_.state = 1 AND (e1_.count_car > 0 OR e1_.show_if_no_stock = 1) ORDER BY c0_.name ASC
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.alias AS alias_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.telephone AS telephone_5, e0_.contact_nom AS contact_nom_6, e0_.photos AS photos_7, e0_.fax AS fax_8, e0_.state AS state_9, e0_.count_car AS count_car_10, e0_.ville AS ville_11, e0_.latitude AS latitude_12, e0_.longtitude AS longtitude_13, e0_.description AS description_14, e0_.cgi_code AS cgi_code_15, e0_.time_week_morning_start AS time_week_morning_start_16, e0_.time_week_morning_end AS time_week_morning_end_17, e0_.time_week_afternoon_start AS time_week_afternoon_start_18, e0_.time_week_afternoon_end AS time_week_afternoon_end_19, e0_.time_we_morning_start AS time_we_morning_start_20, e0_.time_we_morning_end AS time_we_morning_end_21, e0_.time_we_afternoon_start AS time_we_afternoon_start_22, e0_.time_we_afternoon_end AS time_we_afternoon_end_23, e0_.autolink_id AS autolink_id_24, e0_.email AS email_25, e0_.image AS image_26, e0_.siren AS siren_27, e0_.autodiscount_name AS autodiscount_name_28, e0_.autodiscount_email AS autodiscount_email_29, e0_.autodiscount_phone AS autodiscount_phone_30, e0_.concession_email AS concession_email_31, e0_.concession_telephone AS concession_telephone_32, e0_.virtuel AS virtuel_33, e0_.id_base_tressol AS id_base_tressol_34, e0_.id_google AS id_google_35, e0_.affaire AS affaire_36, e0_.siret AS siret_37, e0_.garage_auto AS garage_auto_38, e0_.garage_moto AS garage_moto_39, e0_.occasion_pro AS occasion_pro_40, e0_.publie AS publie_41, e0_.experts AS experts_42, e0_.total_review AS total_review_43, e0_.average_review_rating AS average_review_rating_44, e0_.seo_description AS seo_description_45, e0_.opening_hours_text AS opening_hours_text_46, e0_.opening_hours_periods AS opening_hours_periods_47, e0_.raison_sociale AS raison_sociale_48, e0_.detail_stockage AS detail_stockage_49, e0_.street_number AS street_number_50, e0_.route AS route_51, e0_.bigquery AS bigquery_52, e0_.email_lead_vo AS email_lead_vo_53, e0_.disabled_google AS disabled_google_54, e0_.enable_json_lead AS enable_json_lead_55, e0_.show_if_no_stock AS show_if_no_stock_56, e0_.mecaplanning_ent_id AS mecaplanning_ent_id_57, e0_.mecaplanning_ent_key AS mecaplanning_ent_key_58, e0_.mecaplanning_dms_id AS mecaplanning_dms_id_59, e0_.mecaplanning_site_code AS mecaplanning_site_code_60, e0_.mecaplanning_site_id AS mecaplanning_site_id_61, e0_.mecaplanning_workshop_code AS mecaplanning_workshop_code_62, e0_.mecaplanning_workshop_id AS mecaplanning_workshop_id_63, e0_.mecaplanning_porovider_name AS mecaplanning_porovider_name_64 FROM etablissement e0_ WHERE e0_.detail_stockage IS NOT NULL AND e0_.publie = 1 AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1)
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 FROM etablissement e0_ WHERE e0_.id IN (?) AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1) AND e0_.publie = 1 AND e0_.latitude IS NOT NULL AND e0_.longtitude IS NOT NULL
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
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 OR e0_.show_if_no_stock = 1) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1 ORDER BY e0_.name ASC
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
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
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
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
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
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
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
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
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
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
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 = ?
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
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'
SELECT DATABASE()
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
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
SELECT DATABASE()
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
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
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, t0.url AS url_6 FROM promo t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 WHERE t0.state = ? ORDER BY t0.name ASC
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
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
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 OR e0_.show_if_no_stock = 1) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1) OR e0_.id = ?) AND e0_.detail_stockage IS NULL ORDER BY e0_.name ASC
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
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
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
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

#▲	Time	Info
1	3.31 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.natcode AS natcode_2, c0_.state AS state_3, c0_.brand_logo AS brand_logo_4, c0_.description AS description_5, c0_.ranking_score AS ranking_score_6, c0_.ranking_score_vn AS ranking_score_vn_7, c0_.regroupement AS regroupement_8, c0_.total_vo AS total_vo_9, c0_.total_vn AS total_vn_10, e1_.id AS id_11, e1_.name AS name_12, e1_.alias AS alias_13, e1_.adresse AS adresse_14, e1_.postal_code AS postal_code_15, e1_.telephone AS telephone_16, e1_.contact_nom AS contact_nom_17, e1_.photos AS photos_18, e1_.fax AS fax_19, e1_.state AS state_20, e1_.count_car AS count_car_21, e1_.ville AS ville_22, e1_.latitude AS latitude_23, e1_.longtitude AS longtitude_24, e1_.description AS description_25, e1_.cgi_code AS cgi_code_26, e1_.time_week_morning_start AS time_week_morning_start_27, e1_.time_week_morning_end AS time_week_morning_end_28, e1_.time_week_afternoon_start AS time_week_afternoon_start_29, e1_.time_week_afternoon_end AS time_week_afternoon_end_30, e1_.time_we_morning_start AS time_we_morning_start_31, e1_.time_we_morning_end AS time_we_morning_end_32, e1_.time_we_afternoon_start AS time_we_afternoon_start_33, e1_.time_we_afternoon_end AS time_we_afternoon_end_34, e1_.autolink_id AS autolink_id_35, e1_.email AS email_36, e1_.image AS image_37, e1_.siren AS siren_38, e1_.autodiscount_name AS autodiscount_name_39, e1_.autodiscount_email AS autodiscount_email_40, e1_.autodiscount_phone AS autodiscount_phone_41, e1_.concession_email AS concession_email_42, e1_.concession_telephone AS concession_telephone_43, e1_.virtuel AS virtuel_44, e1_.id_base_tressol AS id_base_tressol_45, e1_.id_google AS id_google_46, e1_.affaire AS affaire_47, e1_.siret AS siret_48, e1_.garage_auto AS garage_auto_49, e1_.garage_moto AS garage_moto_50, e1_.occasion_pro AS occasion_pro_51, e1_.publie AS publie_52, e1_.experts AS experts_53, e1_.total_review AS total_review_54, e1_.average_review_rating AS average_review_rating_55, e1_.seo_description AS seo_description_56, e1_.opening_hours_text AS opening_hours_text_57, e1_.opening_hours_periods AS opening_hours_periods_58, e1_.raison_sociale AS raison_sociale_59, e1_.detail_stockage AS detail_stockage_60, e1_.street_number AS street_number_61, e1_.route AS route_62, e1_.bigquery AS bigquery_63, e1_.email_lead_vo AS email_lead_vo_64, e1_.disabled_google AS disabled_google_65, e1_.enable_json_lead AS enable_json_lead_66, e1_.show_if_no_stock AS show_if_no_stock_67, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_68, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_69, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_70, e1_.mecaplanning_site_code AS mecaplanning_site_code_71, e1_.mecaplanning_site_id AS mecaplanning_site_id_72, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_73, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_74, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_75 FROM car_marque c0_ INNER JOIN etablissement_car_marque e2_ ON c0_.id = e2_.car_marque_id INNER JOIN etablissement e1_ ON e1_.id = e2_.etablissement_id WHERE e1_.detail_stockage IS NULL AND e1_.publie = 1 AND c0_.state = 1 AND (e1_.count_car > 0 OR e1_.show_if_no_stock = 1) ORDER BY c0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.natcode AS natcode_2, c0_.state AS state_3, c0_.brand_logo AS brand_logo_4, c0_.description AS description_5, c0_.ranking_score AS ranking_score_6, c0_.ranking_score_vn AS ranking_score_vn_7, c0_.regroupement AS regroupement_8, c0_.total_vo AS total_vo_9, c0_.total_vn AS total_vn_10, e1_.id AS id_11, e1_.name AS name_12, e1_.alias AS alias_13, e1_.adresse AS adresse_14, e1_.postal_code AS postal_code_15, e1_.telephone AS telephone_16, e1_.contact_nom AS contact_nom_17, e1_.photos AS photos_18, e1_.fax AS fax_19, e1_.state AS state_20, e1_.count_car AS count_car_21, e1_.ville AS ville_22, e1_.latitude AS latitude_23, e1_.longtitude AS longtitude_24, e1_.description AS description_25, e1_.cgi_code AS cgi_code_26, e1_.time_week_morning_start AS time_week_morning_start_27, e1_.time_week_morning_end AS time_week_morning_end_28, e1_.time_week_afternoon_start AS time_week_afternoon_start_29, e1_.time_week_afternoon_end AS time_week_afternoon_end_30, e1_.time_we_morning_start AS time_we_morning_start_31, e1_.time_we_morning_end AS time_we_morning_end_32, e1_.time_we_afternoon_start AS time_we_afternoon_start_33, e1_.time_we_afternoon_end AS time_we_afternoon_end_34, e1_.autolink_id AS autolink_id_35, e1_.email AS email_36, e1_.image AS image_37, e1_.siren AS siren_38, e1_.autodiscount_name AS autodiscount_name_39, e1_.autodiscount_email AS autodiscount_email_40, e1_.autodiscount_phone AS autodiscount_phone_41, e1_.concession_email AS concession_email_42, e1_.concession_telephone AS concession_telephone_43, e1_.virtuel AS virtuel_44, e1_.id_base_tressol AS id_base_tressol_45, e1_.id_google AS id_google_46, e1_.affaire AS affaire_47, e1_.siret AS siret_48, e1_.garage_auto AS garage_auto_49, e1_.garage_moto AS garage_moto_50, e1_.occasion_pro AS occasion_pro_51, e1_.publie AS publie_52, e1_.experts AS experts_53, e1_.total_review AS total_review_54, e1_.average_review_rating AS average_review_rating_55, e1_.seo_description AS seo_description_56, e1_.opening_hours_text AS opening_hours_text_57, e1_.opening_hours_periods AS opening_hours_periods_58, e1_.raison_sociale AS raison_sociale_59, e1_.detail_stockage AS detail_stockage_60, e1_.street_number AS street_number_61, e1_.route AS route_62, e1_.bigquery AS bigquery_63, e1_.email_lead_vo AS email_lead_vo_64, e1_.disabled_google AS disabled_google_65, e1_.enable_json_lead AS enable_json_lead_66, e1_.show_if_no_stock AS show_if_no_stock_67, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_68, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_69, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_70, e1_.mecaplanning_site_code AS mecaplanning_site_code_71, e1_.mecaplanning_site_id AS mecaplanning_site_id_72, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_73, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_74, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_75 FROM car_marque c0_ INNER JOIN etablissement_car_marque e2_ ON c0_.id = e2_.car_marque_id INNER JOIN etablissement e1_ ON e1_.id = e2_.etablissement_id WHERE e1_.detail_stockage IS NULL AND e1_.publie = 1 AND c0_.state = 1 AND ( e1_.count_car > 0 OR e1_.show_if_no_stock = 1 ) ORDER BY c0_.name ASC SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.natcode AS natcode_2, c0_.state AS state_3, c0_.brand_logo AS brand_logo_4, c0_.description AS description_5, c0_.ranking_score AS ranking_score_6, c0_.ranking_score_vn AS ranking_score_vn_7, c0_.regroupement AS regroupement_8, c0_.total_vo AS total_vo_9, c0_.total_vn AS total_vn_10, e1_.id AS id_11, e1_.name AS name_12, e1_.alias AS alias_13, e1_.adresse AS adresse_14, e1_.postal_code AS postal_code_15, e1_.telephone AS telephone_16, e1_.contact_nom AS contact_nom_17, e1_.photos AS photos_18, e1_.fax AS fax_19, e1_.state AS state_20, e1_.count_car AS count_car_21, e1_.ville AS ville_22, e1_.latitude AS latitude_23, e1_.longtitude AS longtitude_24, e1_.description AS description_25, e1_.cgi_code AS cgi_code_26, e1_.time_week_morning_start AS time_week_morning_start_27, e1_.time_week_morning_end AS time_week_morning_end_28, e1_.time_week_afternoon_start AS time_week_afternoon_start_29, e1_.time_week_afternoon_end AS time_week_afternoon_end_30, e1_.time_we_morning_start AS time_we_morning_start_31, e1_.time_we_morning_end AS time_we_morning_end_32, e1_.time_we_afternoon_start AS time_we_afternoon_start_33, e1_.time_we_afternoon_end AS time_we_afternoon_end_34, e1_.autolink_id AS autolink_id_35, e1_.email AS email_36, e1_.image AS image_37, e1_.siren AS siren_38, e1_.autodiscount_name AS autodiscount_name_39, e1_.autodiscount_email AS autodiscount_email_40, e1_.autodiscount_phone AS autodiscount_phone_41, e1_.concession_email AS concession_email_42, e1_.concession_telephone AS concession_telephone_43, e1_.virtuel AS virtuel_44, e1_.id_base_tressol AS id_base_tressol_45, e1_.id_google AS id_google_46, e1_.affaire AS affaire_47, e1_.siret AS siret_48, e1_.garage_auto AS garage_auto_49, e1_.garage_moto AS garage_moto_50, e1_.occasion_pro AS occasion_pro_51, e1_.publie AS publie_52, e1_.experts AS experts_53, e1_.total_review AS total_review_54, e1_.average_review_rating AS average_review_rating_55, e1_.seo_description AS seo_description_56, e1_.opening_hours_text AS opening_hours_text_57, e1_.opening_hours_periods AS opening_hours_periods_58, e1_.raison_sociale AS raison_sociale_59, e1_.detail_stockage AS detail_stockage_60, e1_.street_number AS street_number_61, e1_.route AS route_62, e1_.bigquery AS bigquery_63, e1_.email_lead_vo AS email_lead_vo_64, e1_.disabled_google AS disabled_google_65, e1_.enable_json_lead AS enable_json_lead_66, e1_.show_if_no_stock AS show_if_no_stock_67, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_68, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_69, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_70, e1_.mecaplanning_site_code AS mecaplanning_site_code_71, e1_.mecaplanning_site_id AS mecaplanning_site_id_72, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_73, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_74, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_75 FROM car_marque c0_ INNER JOIN etablissement_car_marque e2_ ON c0_.id = e2_.car_marque_id INNER JOIN etablissement e1_ ON e1_.id = e2_.etablissement_id WHERE e1_.detail_stockage IS NULL AND e1_.publie = 1 AND c0_.state = 1 AND (e1_.count_car > 0 OR e1_.show_if_no_stock = 1) ORDER BY c0_.name ASC;
2	1.11 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.alias AS alias_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.telephone AS telephone_5, e0_.contact_nom AS contact_nom_6, e0_.photos AS photos_7, e0_.fax AS fax_8, e0_.state AS state_9, e0_.count_car AS count_car_10, e0_.ville AS ville_11, e0_.latitude AS latitude_12, e0_.longtitude AS longtitude_13, e0_.description AS description_14, e0_.cgi_code AS cgi_code_15, e0_.time_week_morning_start AS time_week_morning_start_16, e0_.time_week_morning_end AS time_week_morning_end_17, e0_.time_week_afternoon_start AS time_week_afternoon_start_18, e0_.time_week_afternoon_end AS time_week_afternoon_end_19, e0_.time_we_morning_start AS time_we_morning_start_20, e0_.time_we_morning_end AS time_we_morning_end_21, e0_.time_we_afternoon_start AS time_we_afternoon_start_22, e0_.time_we_afternoon_end AS time_we_afternoon_end_23, e0_.autolink_id AS autolink_id_24, e0_.email AS email_25, e0_.image AS image_26, e0_.siren AS siren_27, e0_.autodiscount_name AS autodiscount_name_28, e0_.autodiscount_email AS autodiscount_email_29, e0_.autodiscount_phone AS autodiscount_phone_30, e0_.concession_email AS concession_email_31, e0_.concession_telephone AS concession_telephone_32, e0_.virtuel AS virtuel_33, e0_.id_base_tressol AS id_base_tressol_34, e0_.id_google AS id_google_35, e0_.affaire AS affaire_36, e0_.siret AS siret_37, e0_.garage_auto AS garage_auto_38, e0_.garage_moto AS garage_moto_39, e0_.occasion_pro AS occasion_pro_40, e0_.publie AS publie_41, e0_.experts AS experts_42, e0_.total_review AS total_review_43, e0_.average_review_rating AS average_review_rating_44, e0_.seo_description AS seo_description_45, e0_.opening_hours_text AS opening_hours_text_46, e0_.opening_hours_periods AS opening_hours_periods_47, e0_.raison_sociale AS raison_sociale_48, e0_.detail_stockage AS detail_stockage_49, e0_.street_number AS street_number_50, e0_.route AS route_51, e0_.bigquery AS bigquery_52, e0_.email_lead_vo AS email_lead_vo_53, e0_.disabled_google AS disabled_google_54, e0_.enable_json_lead AS enable_json_lead_55, e0_.show_if_no_stock AS show_if_no_stock_56, e0_.mecaplanning_ent_id AS mecaplanning_ent_id_57, e0_.mecaplanning_ent_key AS mecaplanning_ent_key_58, e0_.mecaplanning_dms_id AS mecaplanning_dms_id_59, e0_.mecaplanning_site_code AS mecaplanning_site_code_60, e0_.mecaplanning_site_id AS mecaplanning_site_id_61, e0_.mecaplanning_workshop_code AS mecaplanning_workshop_code_62, e0_.mecaplanning_workshop_id AS mecaplanning_workshop_id_63, e0_.mecaplanning_porovider_name AS mecaplanning_porovider_name_64 FROM etablissement e0_ WHERE e0_.detail_stockage IS NOT NULL AND e0_.publie = 1 AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1) Parameters: [] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.alias AS alias_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.telephone AS telephone_5, e0_.contact_nom AS contact_nom_6, e0_.photos AS photos_7, e0_.fax AS fax_8, e0_.state AS state_9, e0_.count_car AS count_car_10, e0_.ville AS ville_11, e0_.latitude AS latitude_12, e0_.longtitude AS longtitude_13, e0_.description AS description_14, e0_.cgi_code AS cgi_code_15, e0_.time_week_morning_start AS time_week_morning_start_16, e0_.time_week_morning_end AS time_week_morning_end_17, e0_.time_week_afternoon_start AS time_week_afternoon_start_18, e0_.time_week_afternoon_end AS time_week_afternoon_end_19, e0_.time_we_morning_start AS time_we_morning_start_20, e0_.time_we_morning_end AS time_we_morning_end_21, e0_.time_we_afternoon_start AS time_we_afternoon_start_22, e0_.time_we_afternoon_end AS time_we_afternoon_end_23, e0_.autolink_id AS autolink_id_24, e0_.email AS email_25, e0_.image AS image_26, e0_.siren AS siren_27, e0_.autodiscount_name AS autodiscount_name_28, e0_.autodiscount_email AS autodiscount_email_29, e0_.autodiscount_phone AS autodiscount_phone_30, e0_.concession_email AS concession_email_31, e0_.concession_telephone AS concession_telephone_32, e0_.virtuel AS virtuel_33, e0_.id_base_tressol AS id_base_tressol_34, e0_.id_google AS id_google_35, e0_.affaire AS affaire_36, e0_.siret AS siret_37, e0_.garage_auto AS garage_auto_38, e0_.garage_moto AS garage_moto_39, e0_.occasion_pro AS occasion_pro_40, e0_.publie AS publie_41, e0_.experts AS experts_42, e0_.total_review AS total_review_43, e0_.average_review_rating AS average_review_rating_44, e0_.seo_description AS seo_description_45, e0_.opening_hours_text AS opening_hours_text_46, e0_.opening_hours_periods AS opening_hours_periods_47, e0_.raison_sociale AS raison_sociale_48, e0_.detail_stockage AS detail_stockage_49, e0_.street_number AS street_number_50, e0_.route AS route_51, e0_.bigquery AS bigquery_52, e0_.email_lead_vo AS email_lead_vo_53, e0_.disabled_google AS disabled_google_54, e0_.enable_json_lead AS enable_json_lead_55, e0_.show_if_no_stock AS show_if_no_stock_56, e0_.mecaplanning_ent_id AS mecaplanning_ent_id_57, e0_.mecaplanning_ent_key AS mecaplanning_ent_key_58, e0_.mecaplanning_dms_id AS mecaplanning_dms_id_59, e0_.mecaplanning_site_code AS mecaplanning_site_code_60, e0_.mecaplanning_site_id AS mecaplanning_site_id_61, e0_.mecaplanning_workshop_code AS mecaplanning_workshop_code_62, e0_.mecaplanning_workshop_id AS mecaplanning_workshop_id_63, e0_.mecaplanning_porovider_name AS mecaplanning_porovider_name_64 FROM etablissement e0_ WHERE e0_.detail_stockage IS NOT NULL AND e0_.publie = 1 AND ( e0_.count_car > 0 OR e0_.show_if_no_stock = 1 ) SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.alias AS alias_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.telephone AS telephone_5, e0_.contact_nom AS contact_nom_6, e0_.photos AS photos_7, e0_.fax AS fax_8, e0_.state AS state_9, e0_.count_car AS count_car_10, e0_.ville AS ville_11, e0_.latitude AS latitude_12, e0_.longtitude AS longtitude_13, e0_.description AS description_14, e0_.cgi_code AS cgi_code_15, e0_.time_week_morning_start AS time_week_morning_start_16, e0_.time_week_morning_end AS time_week_morning_end_17, e0_.time_week_afternoon_start AS time_week_afternoon_start_18, e0_.time_week_afternoon_end AS time_week_afternoon_end_19, e0_.time_we_morning_start AS time_we_morning_start_20, e0_.time_we_morning_end AS time_we_morning_end_21, e0_.time_we_afternoon_start AS time_we_afternoon_start_22, e0_.time_we_afternoon_end AS time_we_afternoon_end_23, e0_.autolink_id AS autolink_id_24, e0_.email AS email_25, e0_.image AS image_26, e0_.siren AS siren_27, e0_.autodiscount_name AS autodiscount_name_28, e0_.autodiscount_email AS autodiscount_email_29, e0_.autodiscount_phone AS autodiscount_phone_30, e0_.concession_email AS concession_email_31, e0_.concession_telephone AS concession_telephone_32, e0_.virtuel AS virtuel_33, e0_.id_base_tressol AS id_base_tressol_34, e0_.id_google AS id_google_35, e0_.affaire AS affaire_36, e0_.siret AS siret_37, e0_.garage_auto AS garage_auto_38, e0_.garage_moto AS garage_moto_39, e0_.occasion_pro AS occasion_pro_40, e0_.publie AS publie_41, e0_.experts AS experts_42, e0_.total_review AS total_review_43, e0_.average_review_rating AS average_review_rating_44, e0_.seo_description AS seo_description_45, e0_.opening_hours_text AS opening_hours_text_46, e0_.opening_hours_periods AS opening_hours_periods_47, e0_.raison_sociale AS raison_sociale_48, e0_.detail_stockage AS detail_stockage_49, e0_.street_number AS street_number_50, e0_.route AS route_51, e0_.bigquery AS bigquery_52, e0_.email_lead_vo AS email_lead_vo_53, e0_.disabled_google AS disabled_google_54, e0_.enable_json_lead AS enable_json_lead_55, e0_.show_if_no_stock AS show_if_no_stock_56, e0_.mecaplanning_ent_id AS mecaplanning_ent_id_57, e0_.mecaplanning_ent_key AS mecaplanning_ent_key_58, e0_.mecaplanning_dms_id AS mecaplanning_dms_id_59, e0_.mecaplanning_site_code AS mecaplanning_site_code_60, e0_.mecaplanning_site_id AS mecaplanning_site_id_61, e0_.mecaplanning_workshop_code AS mecaplanning_workshop_code_62, e0_.mecaplanning_workshop_id AS mecaplanning_workshop_id_63, e0_.mecaplanning_porovider_name AS mecaplanning_porovider_name_64 FROM etablissement e0_ WHERE e0_.detail_stockage IS NOT NULL AND e0_.publie = 1 AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1);
3	0.28 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 FROM etablissement e0_ WHERE e0_.id IN (?) AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1) AND e0_.publie = 1 AND e0_.latitude IS NOT NULL AND e0_.longtitude IS NOT NULL Parameters: [`158`] View formatted query View runnable query Explain query 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 FROM etablissement e0_ WHERE e0_.id IN (?) AND ( e0_.count_car > 0 OR e0_.show_if_no_stock = 1 ) AND e0_.publie = 1 AND e0_.latitude IS NOT NULL AND e0_.longtitude IS NOT NULL 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 FROM etablissement e0_ WHERE e0_.id IN (158) AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1) AND e0_.publie = 1 AND e0_.latitude IS NOT NULL AND e0_.longtitude IS NOT NULL;
4	4.97 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: [] View formatted query View runnable query Explain query 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 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;
5	1.27 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 OR e0_.show_if_no_stock = 1) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1 ORDER BY e0_.name ASC Parameters: [] View formatted query View runnable query Explain query 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 OR e0_.show_if_no_stock = 1 ) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1 ORDER BY e0_.name ASC 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 OR e0_.show_if_no_stock = 1) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1 ORDER BY e0_.name ASC;
6	0.98 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: [] View formatted query View runnable query Explain query 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 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;
7	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: [`"estimate"`] View formatted query View runnable query Explain query 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 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 = 'estimate' LIMIT 1;
8	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"`] View formatted query View runnable query Explain query 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 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 = 'totalConcession' LIMIT 1;
9	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: [`"USED_CAR"`] View formatted query View runnable query Explain query 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 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 = 'USED_CAR' LIMIT 1;
10	0.23 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: [`"estimate"`] View formatted query View runnable query Explain query 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 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 = 'estimate' LIMIT 1;
11	0.22 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"`] View formatted query View runnable query Explain query 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 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 = 'totalConcession' LIMIT 1;
12	0.18 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"`] View formatted query View runnable query Explain query 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 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 = 'USED_CAR' LIMIT 1;
13	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: [`"USED_CAR"`] View formatted query View runnable query Explain query 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 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 = 'USED_CAR' LIMIT 1;
14	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"`] View formatted query View runnable query Explain query 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 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 = 'USED_CAR' LIMIT 1;
15	0.41 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: [`"estimate"`] View formatted query View runnable query Explain query 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 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 = 'estimate' LIMIT 1;
16	0.53 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: [`2`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
17	0.49 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
18	1.06 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"tressol-chabrier"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'tressol-chabrier' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
19	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
20	0.64 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"tressol-chabrier"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'tressol-chabrier' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
21	0.12 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
22	0.44 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"`] View formatted query View runnable query Explain query 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' 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 = 'tressol-chabrier' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
23	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
24	0.85 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"`] View formatted query View runnable query Explain query 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 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 = 'tressol-chabrier' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'tressol-chabrier' / ORDER BY k.ORDINAL_POSITION;
25	13.97 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"`] View formatted query View runnable query Explain query 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 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 = 'tressol-chabrier' AND t.TABLE_SCHEMA = 'tressol-chabrier' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
26	0.35 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
27	0.55 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"`] View formatted query View runnable query Explain query 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 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 = 'tressol-chabrier' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
28	0.41 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
29	0.27 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
30	0.48 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, t0.url AS url_6 FROM promo t0 WHERE t0.id = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query 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, t0.url AS url_6 FROM promo t0 WHERE t0.id = ? LIMIT 1 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, t0.url AS url_6 FROM promo t0 WHERE t0.id = 1 LIMIT 1;
31	1.29 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 WHERE t0.state = ? ORDER BY t0.name ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 WHERE t0.state = ? ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 WHERE t0.state = 1 ORDER BY t0.name ASC;
32	0.37 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"`] View formatted query View runnable query Explain query 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 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 = 'totalConcession' LIMIT 1;
33	0.49 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"`] View formatted query View runnable query Explain query 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 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 = 'totalConcession' LIMIT 1;
34	1.72 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 OR e0_.show_if_no_stock = 1) 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`] View formatted query View runnable query Explain query 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 OR e0_.show_if_no_stock = 1 ) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1 ) OR e0_.id = ? ) AND e0_.detail_stockage IS NULL ORDER BY e0_.name ASC 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 OR e0_.show_if_no_stock = 1) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1) OR e0_.id = 158) AND e0_.detail_stockage IS NULL ORDER BY e0_.name ASC;
35	0.44 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: [] View formatted query View runnable query Explain query 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 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;
36	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: [`"totalConcession"`] View formatted query View runnable query Explain query 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 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 = 'totalConcession' LIMIT 1;
37	0.19 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"`] View formatted query View runnable query Explain query 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 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 = 'BRAND' LIMIT 1;
38	0.57 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"`] View formatted query View runnable query Explain query 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 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 = 'totalConcession' LIMIT 1;

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\CarMarque	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\CarModele	No errors.
App\Entity\MarqueNews	No errors.
App\Entity\User	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\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.

Symfony Profiler

GET https://tressol.yeah.agency/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255Cfront%255CGelController%253A%253AgetCompare

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

internal entity manager