Symfony Profiler

Query Metrics

45 Database Queries

27 Different statements

49.79 ms Query time

0 Invalid entities

Queries

default connection


SELECT DISTINCT cm.name, cm.id FROM car_marque cm
                INNER join etablissement_car_marque ecm ON ecm.car_marque_id = cm.id
SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1
SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1
SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1
SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1
SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1
SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name IN (?)
"START TRANSACTION"
UPDATE car_marque SET ranking_score = ? WHERE id = ?
"COMMIT"
SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.family AS family_5, c0_.puissance AS puissance_6, c0_.puissance_fiscale AS puissance_fiscale_7, c0_.millesime AS millesime_8, c0_.mise_en_circulation AS mise_en_circulation_9, c0_.kilometrage AS kilometrage_10, c0_.kilometrage_garanti AS kilometrage_garanti_11, c0_.emission_co2 AS emission_co2_12, c0_.premiere_main AS premiere_main_13, c0_.nb_portes AS nb_portes_14, c0_.nb_places AS nb_places_15, c0_.eurotax_version AS eurotax_version_16, c0_.label AS label_17, c0_.lieu_stockage AS lieu_stockage_18, c0_.detail_stockage AS detail_stockage_19, c0_.immatriculation AS immatriculation_20, c0_.vp_vu AS vp_vu_21, c0_.offre_type AS offre_type_22, c0_.prix AS prix_23, c0_.garantie AS garantie_24, c0_.eligible_prime_gouv AS eligible_prime_gouv_25, c0_.tva_recuperable AS tva_recuperable_26, c0_.tva_montant AS tva_montant_27, c0_.categorie AS categorie_28, c0_.couleur AS couleur_29, c0_.photos AS photos_30, c0_.carrosserie AS carrosserie_31, c0_.energie_type AS energie_type_32, c0_.contact_afficher AS contact_afficher_33, c0_.telephone_afficher AS telephone_afficher_34, c0_.email_afficher AS email_afficher_35, c0_.boite_de_vitesse_type AS boite_de_vitesse_type_36, c0_.url360 AS url360_37, c0_.options AS options_38, c0_.equipements AS equipements_39, c0_.mensualise AS mensualise_40, c0_.critair AS critair_41, c0_.essai AS essai_42, c0_.cgi_prix AS cgi_prix_43, c0_.cgi_details AS cgi_details_44, c0_.vin AS vin_45, c0_.eligible_contrat_entretien AS eligible_contrat_entretien_46, c0_.usage_principale AS usage_principale_47, c0_.loi_de_roulage AS loi_de_roulage_48, c0_.avantage_principal AS avantage_principal_49, c0_.usage_principal AS usage_principal_50, c0_.type AS type_51, c0_.car_type AS car_type_52, c0_.natcode AS natcode_53, c0_.media_natcode AS media_natcode_54, c0_.published AS published_55, c0_.created_at AS created_at_56, c0_.updated_at AS updated_at_57, e1_.id AS id_58, e1_.name AS name_59, e1_.alias AS alias_60, e1_.adresse AS adresse_61, e1_.postal_code AS postal_code_62, e1_.telephone AS telephone_63, e1_.contact_nom AS contact_nom_64, e1_.photos AS photos_65, e1_.fax AS fax_66, e1_.state AS state_67, e1_.count_car AS count_car_68, e1_.ville AS ville_69, e1_.latitude AS latitude_70, e1_.longtitude AS longtitude_71, e1_.description AS description_72, e1_.cgi_code AS cgi_code_73, e1_.time_week_morning_start AS time_week_morning_start_74, e1_.time_week_morning_end AS time_week_morning_end_75, e1_.time_week_afternoon_start AS time_week_afternoon_start_76, e1_.time_week_afternoon_end AS time_week_afternoon_end_77, e1_.time_we_morning_start AS time_we_morning_start_78, e1_.time_we_morning_end AS time_we_morning_end_79, e1_.time_we_afternoon_start AS time_we_afternoon_start_80, e1_.time_we_afternoon_end AS time_we_afternoon_end_81, e1_.autolink_id AS autolink_id_82, e1_.email AS email_83, e1_.image AS image_84, e1_.siren AS siren_85, e1_.autodiscount_name AS autodiscount_name_86, e1_.autodiscount_email AS autodiscount_email_87, e1_.autodiscount_phone AS autodiscount_phone_88, e1_.concession_email AS concession_email_89, e1_.concession_telephone AS concession_telephone_90, e1_.virtuel AS virtuel_91, e1_.id_base_tressol AS id_base_tressol_92, e1_.id_google AS id_google_93, e1_.affaire AS affaire_94, e1_.siret AS siret_95, e1_.garage_auto AS garage_auto_96, e1_.garage_moto AS garage_moto_97, e1_.occasion_pro AS occasion_pro_98, e1_.publie AS publie_99, e1_.experts AS experts_100, e1_.total_review AS total_review_101, e1_.average_review_rating AS average_review_rating_102, e1_.seo_description AS seo_description_103, e1_.opening_hours_text AS opening_hours_text_104, e1_.opening_hours_periods AS opening_hours_periods_105, e1_.raison_sociale AS raison_sociale_106, e1_.detail_stockage AS detail_stockage_107, e1_.street_number AS street_number_108, e1_.route AS route_109, e1_.bigquery AS bigquery_110, e1_.email_lead_vo AS email_lead_vo_111, e1_.disabled_google AS disabled_google_112, e1_.enable_json_lead AS enable_json_lead_113, e1_.show_if_no_stock AS show_if_no_stock_114, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_115, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_116, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_117, e1_.mecaplanning_site_code AS mecaplanning_site_code_118, e1_.mecaplanning_site_id AS mecaplanning_site_id_119, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_120, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_121, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_122, c0_.user_id AS user_id_123 FROM car c0_ LEFT JOIN car_etablissement c2_ ON c0_.id = c2_.car_id LEFT JOIN etablissement e1_ ON e1_.id = c2_.etablissement_id WHERE c0_.id IN (NULL)
SELECT c0_.modele AS modele_0, COUNT(c0_.modele) AS sclr_1 FROM car c0_ WHERE c0_.marque IN (?) AND c0_.type IN (?, ?) AND c0_.published = 1 GROUP BY c0_.modele ORDER BY sclr_1 DESC
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_name = ? AND b1_.category_id <> 1 ORDER BY b0_.date DESC LIMIT 20
SELECT t0.id AS id_1, t0.label AS label_2, t0.image_url AS image_url_3, t0.query AS query_4, t0.steps AS steps_5 FROM filter_question t0
SELECT c0_.name AS name_0 FROM car_marque c0_ WHERE c0_.state = 0
SELECT DISTINCT c0_.marque AS marque_0 FROM car c0_ WHERE c0_.marque IS NOT NULL AND c0_.marque NOT IN (?) ORDER BY c0_.marque 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 = ?) AND e0_.detail_stockage IS NULL ORDER BY e0_.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 c0_.name = ? AND e1_.publie = 1 AND c0_.state = 1 AND (e1_.count_car > 0 OR e1_.show_if_no_stock = 1)
SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.label AS label_3, t0.image_path AS image_path_4, t0.link AS link_5, t0.text AS text_6, t0.link_label AS link_label_7, t0.marque_id AS marque_id_8 FROM marque_news t0 WHERE t0.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

#▲	Time	Info
1	0.64 ms	SELECT DISTINCT cm.name, cm.id FROM car_marque cm INNER join etablissement_car_marque ecm ON ecm.car_marque_id = cm.id Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT cm.name, cm.id FROM car_marque cm INNER join etablissement_car_marque ecm ON ecm.car_marque_id = cm.id SELECT DISTINCT cm.name, cm.id FROM car_marque cm INNER join etablissement_car_marque ecm ON ecm.car_marque_id = cm.id;
2	0.56 ms	SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 Parameters: [`7785`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = 7785 LIMIT 1;
3	0.17 ms	SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 Parameters: [`8158`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = 8158 LIMIT 1;
4	0.17 ms	SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 Parameters: [`8373`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = 8373 LIMIT 1;
5	0.22 ms	SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 Parameters: [`8411`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = 8411 LIMIT 1;
6	0.19 ms	SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 Parameters: [`8452`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = 8452 LIMIT 1;
7	0.20 ms	SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 Parameters: [`8652`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = ? LIMIT 1 SELECT t0.id AS id_1, t0.natcode AS natcode_2, t0.description AS description_3 FROM model_excluded_configurator t0 WHERE t0.natcode = 8652 LIMIT 1;
8	0.63 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name IN (?) Parameters: [`"MITSUBISHI MOTORS"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name IN (?) SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name IN ('MITSUBISHI MOTORS');
9	0.15 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
10	0.27 ms	UPDATE car_marque SET ranking_score = ? WHERE id = ? Parameters: [`22 22`] View formatted query View runnable query Explain query UPDATE car_marque SET ranking_score = ? WHERE id = ? UPDATE car_marque SET ranking_score = 22 WHERE id = 22;
11	2.79 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
12	3.12 ms	SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.family AS family_5, c0_.puissance AS puissance_6, c0_.puissance_fiscale AS puissance_fiscale_7, c0_.millesime AS millesime_8, c0_.mise_en_circulation AS mise_en_circulation_9, c0_.kilometrage AS kilometrage_10, c0_.kilometrage_garanti AS kilometrage_garanti_11, c0_.emission_co2 AS emission_co2_12, c0_.premiere_main AS premiere_main_13, c0_.nb_portes AS nb_portes_14, c0_.nb_places AS nb_places_15, c0_.eurotax_version AS eurotax_version_16, c0_.label AS label_17, c0_.lieu_stockage AS lieu_stockage_18, c0_.detail_stockage AS detail_stockage_19, c0_.immatriculation AS immatriculation_20, c0_.vp_vu AS vp_vu_21, c0_.offre_type AS offre_type_22, c0_.prix AS prix_23, c0_.garantie AS garantie_24, c0_.eligible_prime_gouv AS eligible_prime_gouv_25, c0_.tva_recuperable AS tva_recuperable_26, c0_.tva_montant AS tva_montant_27, c0_.categorie AS categorie_28, c0_.couleur AS couleur_29, c0_.photos AS photos_30, c0_.carrosserie AS carrosserie_31, c0_.energie_type AS energie_type_32, c0_.contact_afficher AS contact_afficher_33, c0_.telephone_afficher AS telephone_afficher_34, c0_.email_afficher AS email_afficher_35, c0_.boite_de_vitesse_type AS boite_de_vitesse_type_36, c0_.url360 AS url360_37, c0_.options AS options_38, c0_.equipements AS equipements_39, c0_.mensualise AS mensualise_40, c0_.critair AS critair_41, c0_.essai AS essai_42, c0_.cgi_prix AS cgi_prix_43, c0_.cgi_details AS cgi_details_44, c0_.vin AS vin_45, c0_.eligible_contrat_entretien AS eligible_contrat_entretien_46, c0_.usage_principale AS usage_principale_47, c0_.loi_de_roulage AS loi_de_roulage_48, c0_.avantage_principal AS avantage_principal_49, c0_.usage_principal AS usage_principal_50, c0_.type AS type_51, c0_.car_type AS car_type_52, c0_.natcode AS natcode_53, c0_.media_natcode AS media_natcode_54, c0_.published AS published_55, c0_.created_at AS created_at_56, c0_.updated_at AS updated_at_57, e1_.id AS id_58, e1_.name AS name_59, e1_.alias AS alias_60, e1_.adresse AS adresse_61, e1_.postal_code AS postal_code_62, e1_.telephone AS telephone_63, e1_.contact_nom AS contact_nom_64, e1_.photos AS photos_65, e1_.fax AS fax_66, e1_.state AS state_67, e1_.count_car AS count_car_68, e1_.ville AS ville_69, e1_.latitude AS latitude_70, e1_.longtitude AS longtitude_71, e1_.description AS description_72, e1_.cgi_code AS cgi_code_73, e1_.time_week_morning_start AS time_week_morning_start_74, e1_.time_week_morning_end AS time_week_morning_end_75, e1_.time_week_afternoon_start AS time_week_afternoon_start_76, e1_.time_week_afternoon_end AS time_week_afternoon_end_77, e1_.time_we_morning_start AS time_we_morning_start_78, e1_.time_we_morning_end AS time_we_morning_end_79, e1_.time_we_afternoon_start AS time_we_afternoon_start_80, e1_.time_we_afternoon_end AS time_we_afternoon_end_81, e1_.autolink_id AS autolink_id_82, e1_.email AS email_83, e1_.image AS image_84, e1_.siren AS siren_85, e1_.autodiscount_name AS autodiscount_name_86, e1_.autodiscount_email AS autodiscount_email_87, e1_.autodiscount_phone AS autodiscount_phone_88, e1_.concession_email AS concession_email_89, e1_.concession_telephone AS concession_telephone_90, e1_.virtuel AS virtuel_91, e1_.id_base_tressol AS id_base_tressol_92, e1_.id_google AS id_google_93, e1_.affaire AS affaire_94, e1_.siret AS siret_95, e1_.garage_auto AS garage_auto_96, e1_.garage_moto AS garage_moto_97, e1_.occasion_pro AS occasion_pro_98, e1_.publie AS publie_99, e1_.experts AS experts_100, e1_.total_review AS total_review_101, e1_.average_review_rating AS average_review_rating_102, e1_.seo_description AS seo_description_103, e1_.opening_hours_text AS opening_hours_text_104, e1_.opening_hours_periods AS opening_hours_periods_105, e1_.raison_sociale AS raison_sociale_106, e1_.detail_stockage AS detail_stockage_107, e1_.street_number AS street_number_108, e1_.route AS route_109, e1_.bigquery AS bigquery_110, e1_.email_lead_vo AS email_lead_vo_111, e1_.disabled_google AS disabled_google_112, e1_.enable_json_lead AS enable_json_lead_113, e1_.show_if_no_stock AS show_if_no_stock_114, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_115, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_116, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_117, e1_.mecaplanning_site_code AS mecaplanning_site_code_118, e1_.mecaplanning_site_id AS mecaplanning_site_id_119, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_120, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_121, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_122, c0_.user_id AS user_id_123 FROM car c0_ LEFT JOIN car_etablissement c2_ ON c0_.id = c2_.car_id LEFT JOIN etablissement e1_ ON e1_.id = c2_.etablissement_id WHERE c0_.id IN (NULL) Parameters: [] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.family AS family_5, c0_.puissance AS puissance_6, c0_.puissance_fiscale AS puissance_fiscale_7, c0_.millesime AS millesime_8, c0_.mise_en_circulation AS mise_en_circulation_9, c0_.kilometrage AS kilometrage_10, c0_.kilometrage_garanti AS kilometrage_garanti_11, c0_.emission_co2 AS emission_co2_12, c0_.premiere_main AS premiere_main_13, c0_.nb_portes AS nb_portes_14, c0_.nb_places AS nb_places_15, c0_.eurotax_version AS eurotax_version_16, c0_.label AS label_17, c0_.lieu_stockage AS lieu_stockage_18, c0_.detail_stockage AS detail_stockage_19, c0_.immatriculation AS immatriculation_20, c0_.vp_vu AS vp_vu_21, c0_.offre_type AS offre_type_22, c0_.prix AS prix_23, c0_.garantie AS garantie_24, c0_.eligible_prime_gouv AS eligible_prime_gouv_25, c0_.tva_recuperable AS tva_recuperable_26, c0_.tva_montant AS tva_montant_27, c0_.categorie AS categorie_28, c0_.couleur AS couleur_29, c0_.photos AS photos_30, c0_.carrosserie AS carrosserie_31, c0_.energie_type AS energie_type_32, c0_.contact_afficher AS contact_afficher_33, c0_.telephone_afficher AS telephone_afficher_34, c0_.email_afficher AS email_afficher_35, c0_.boite_de_vitesse_type AS boite_de_vitesse_type_36, c0_.url360 AS url360_37, c0_.options AS options_38, c0_.equipements AS equipements_39, c0_.mensualise AS mensualise_40, c0_.critair AS critair_41, c0_.essai AS essai_42, c0_.cgi_prix AS cgi_prix_43, c0_.cgi_details AS cgi_details_44, c0_.vin AS vin_45, c0_.eligible_contrat_entretien AS eligible_contrat_entretien_46, c0_.usage_principale AS usage_principale_47, c0_.loi_de_roulage AS loi_de_roulage_48, c0_.avantage_principal AS avantage_principal_49, c0_.usage_principal AS usage_principal_50, c0_.type AS type_51, c0_.car_type AS car_type_52, c0_.natcode AS natcode_53, c0_.media_natcode AS media_natcode_54, c0_.published AS published_55, c0_.created_at AS created_at_56, c0_.updated_at AS updated_at_57, e1_.id AS id_58, e1_.name AS name_59, e1_.alias AS alias_60, e1_.adresse AS adresse_61, e1_.postal_code AS postal_code_62, e1_.telephone AS telephone_63, e1_.contact_nom AS contact_nom_64, e1_.photos AS photos_65, e1_.fax AS fax_66, e1_.state AS state_67, e1_.count_car AS count_car_68, e1_.ville AS ville_69, e1_.latitude AS latitude_70, e1_.longtitude AS longtitude_71, e1_.description AS description_72, e1_.cgi_code AS cgi_code_73, e1_.time_week_morning_start AS time_week_morning_start_74, e1_.time_week_morning_end AS time_week_morning_end_75, e1_.time_week_afternoon_start AS time_week_afternoon_start_76, e1_.time_week_afternoon_end AS time_week_afternoon_end_77, e1_.time_we_morning_start AS time_we_morning_start_78, e1_.time_we_morning_end AS time_we_morning_end_79, e1_.time_we_afternoon_start AS time_we_afternoon_start_80, e1_.time_we_afternoon_end AS time_we_afternoon_end_81, e1_.autolink_id AS autolink_id_82, e1_.email AS email_83, e1_.image AS image_84, e1_.siren AS siren_85, e1_.autodiscount_name AS autodiscount_name_86, e1_.autodiscount_email AS autodiscount_email_87, e1_.autodiscount_phone AS autodiscount_phone_88, e1_.concession_email AS concession_email_89, e1_.concession_telephone AS concession_telephone_90, e1_.virtuel AS virtuel_91, e1_.id_base_tressol AS id_base_tressol_92, e1_.id_google AS id_google_93, e1_.affaire AS affaire_94, e1_.siret AS siret_95, e1_.garage_auto AS garage_auto_96, e1_.garage_moto AS garage_moto_97, e1_.occasion_pro AS occasion_pro_98, e1_.publie AS publie_99, e1_.experts AS experts_100, e1_.total_review AS total_review_101, e1_.average_review_rating AS average_review_rating_102, e1_.seo_description AS seo_description_103, e1_.opening_hours_text AS opening_hours_text_104, e1_.opening_hours_periods AS opening_hours_periods_105, e1_.raison_sociale AS raison_sociale_106, e1_.detail_stockage AS detail_stockage_107, e1_.street_number AS street_number_108, e1_.route AS route_109, e1_.bigquery AS bigquery_110, e1_.email_lead_vo AS email_lead_vo_111, e1_.disabled_google AS disabled_google_112, e1_.enable_json_lead AS enable_json_lead_113, e1_.show_if_no_stock AS show_if_no_stock_114, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_115, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_116, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_117, e1_.mecaplanning_site_code AS mecaplanning_site_code_118, e1_.mecaplanning_site_id AS mecaplanning_site_id_119, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_120, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_121, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_122, c0_.user_id AS user_id_123 FROM car c0_ LEFT JOIN car_etablissement c2_ ON c0_.id = c2_.car_id LEFT JOIN etablissement e1_ ON e1_.id = c2_.etablissement_id WHERE c0_.id IN (NULL) SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.family AS family_5, c0_.puissance AS puissance_6, c0_.puissance_fiscale AS puissance_fiscale_7, c0_.millesime AS millesime_8, c0_.mise_en_circulation AS mise_en_circulation_9, c0_.kilometrage AS kilometrage_10, c0_.kilometrage_garanti AS kilometrage_garanti_11, c0_.emission_co2 AS emission_co2_12, c0_.premiere_main AS premiere_main_13, c0_.nb_portes AS nb_portes_14, c0_.nb_places AS nb_places_15, c0_.eurotax_version AS eurotax_version_16, c0_.label AS label_17, c0_.lieu_stockage AS lieu_stockage_18, c0_.detail_stockage AS detail_stockage_19, c0_.immatriculation AS immatriculation_20, c0_.vp_vu AS vp_vu_21, c0_.offre_type AS offre_type_22, c0_.prix AS prix_23, c0_.garantie AS garantie_24, c0_.eligible_prime_gouv AS eligible_prime_gouv_25, c0_.tva_recuperable AS tva_recuperable_26, c0_.tva_montant AS tva_montant_27, c0_.categorie AS categorie_28, c0_.couleur AS couleur_29, c0_.photos AS photos_30, c0_.carrosserie AS carrosserie_31, c0_.energie_type AS energie_type_32, c0_.contact_afficher AS contact_afficher_33, c0_.telephone_afficher AS telephone_afficher_34, c0_.email_afficher AS email_afficher_35, c0_.boite_de_vitesse_type AS boite_de_vitesse_type_36, c0_.url360 AS url360_37, c0_.options AS options_38, c0_.equipements AS equipements_39, c0_.mensualise AS mensualise_40, c0_.critair AS critair_41, c0_.essai AS essai_42, c0_.cgi_prix AS cgi_prix_43, c0_.cgi_details AS cgi_details_44, c0_.vin AS vin_45, c0_.eligible_contrat_entretien AS eligible_contrat_entretien_46, c0_.usage_principale AS usage_principale_47, c0_.loi_de_roulage AS loi_de_roulage_48, c0_.avantage_principal AS avantage_principal_49, c0_.usage_principal AS usage_principal_50, c0_.type AS type_51, c0_.car_type AS car_type_52, c0_.natcode AS natcode_53, c0_.media_natcode AS media_natcode_54, c0_.published AS published_55, c0_.created_at AS created_at_56, c0_.updated_at AS updated_at_57, e1_.id AS id_58, e1_.name AS name_59, e1_.alias AS alias_60, e1_.adresse AS adresse_61, e1_.postal_code AS postal_code_62, e1_.telephone AS telephone_63, e1_.contact_nom AS contact_nom_64, e1_.photos AS photos_65, e1_.fax AS fax_66, e1_.state AS state_67, e1_.count_car AS count_car_68, e1_.ville AS ville_69, e1_.latitude AS latitude_70, e1_.longtitude AS longtitude_71, e1_.description AS description_72, e1_.cgi_code AS cgi_code_73, e1_.time_week_morning_start AS time_week_morning_start_74, e1_.time_week_morning_end AS time_week_morning_end_75, e1_.time_week_afternoon_start AS time_week_afternoon_start_76, e1_.time_week_afternoon_end AS time_week_afternoon_end_77, e1_.time_we_morning_start AS time_we_morning_start_78, e1_.time_we_morning_end AS time_we_morning_end_79, e1_.time_we_afternoon_start AS time_we_afternoon_start_80, e1_.time_we_afternoon_end AS time_we_afternoon_end_81, e1_.autolink_id AS autolink_id_82, e1_.email AS email_83, e1_.image AS image_84, e1_.siren AS siren_85, e1_.autodiscount_name AS autodiscount_name_86, e1_.autodiscount_email AS autodiscount_email_87, e1_.autodiscount_phone AS autodiscount_phone_88, e1_.concession_email AS concession_email_89, e1_.concession_telephone AS concession_telephone_90, e1_.virtuel AS virtuel_91, e1_.id_base_tressol AS id_base_tressol_92, e1_.id_google AS id_google_93, e1_.affaire AS affaire_94, e1_.siret AS siret_95, e1_.garage_auto AS garage_auto_96, e1_.garage_moto AS garage_moto_97, e1_.occasion_pro AS occasion_pro_98, e1_.publie AS publie_99, e1_.experts AS experts_100, e1_.total_review AS total_review_101, e1_.average_review_rating AS average_review_rating_102, e1_.seo_description AS seo_description_103, e1_.opening_hours_text AS opening_hours_text_104, e1_.opening_hours_periods AS opening_hours_periods_105, e1_.raison_sociale AS raison_sociale_106, e1_.detail_stockage AS detail_stockage_107, e1_.street_number AS street_number_108, e1_.route AS route_109, e1_.bigquery AS bigquery_110, e1_.email_lead_vo AS email_lead_vo_111, e1_.disabled_google AS disabled_google_112, e1_.enable_json_lead AS enable_json_lead_113, e1_.show_if_no_stock AS show_if_no_stock_114, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_115, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_116, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_117, e1_.mecaplanning_site_code AS mecaplanning_site_code_118, e1_.mecaplanning_site_id AS mecaplanning_site_id_119, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_120, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_121, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_122, c0_.user_id AS user_id_123 FROM car c0_ LEFT JOIN car_etablissement c2_ ON c0_.id = c2_.car_id LEFT JOIN etablissement e1_ ON e1_.id = c2_.etablissement_id WHERE c0_.id IN (NULL);
13	6.16 ms	SELECT c0_.modele AS modele_0, COUNT(c0_.modele) AS sclr_1 FROM car c0_ WHERE c0_.marque IN (?) AND c0_.type IN (?, ?) AND c0_.published = 1 GROUP BY c0_.modele ORDER BY sclr_1 DESC Parameters: [`"MITSUBISHI MOTORS" "VO" "CM"`] View formatted query View runnable query Explain query SELECT c0_.modele AS modele_0, COUNT(c0_.modele) AS sclr_1 FROM car c0_ WHERE c0_.marque IN (?) AND c0_.type IN (?, ?) AND c0_.published = 1 GROUP BY c0_.modele ORDER BY sclr_1 DESC SELECT c0_.modele AS modele_0, COUNT(c0_.modele) AS sclr_1 FROM car c0_ WHERE c0_.marque IN ('MITSUBISHI MOTORS') AND c0_.type IN ('VO', 'CM') AND c0_.published = 1 GROUP BY c0_.modele ORDER BY sclr_1 DESC;
14	1.68 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_name = ? AND b1_.category_id <> 1 ORDER BY b0_.date DESC LIMIT 20 Parameters: [`"MITSUBISHI MOTORS"`] 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_name = ? AND b1_.category_id <> 1 ORDER BY b0_.date DESC LIMIT 20 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_name = 'MITSUBISHI MOTORS' AND b1_.category_id <> 1 ORDER BY b0_.date DESC LIMIT 20;
15	0.25 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.image_url AS image_url_3, t0.query AS query_4, t0.steps AS steps_5 FROM filter_question t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.image_url AS image_url_3, t0.query AS query_4, t0.steps AS steps_5 FROM filter_question t0 SELECT t0.id AS id_1, t0.label AS label_2, t0.image_url AS image_url_3, t0.query AS query_4, t0.steps AS steps_5 FROM filter_question t0;
16	0.20 ms	SELECT c0_.name AS name_0 FROM car_marque c0_ WHERE c0_.state = 0 Parameters: [] View formatted query View runnable query Explain query SELECT c0_.name AS name_0 FROM car_marque c0_ WHERE c0_.state = 0 SELECT c0_.name AS name_0 FROM car_marque c0_ WHERE c0_.state = 0;
17	6.05 ms	SELECT DISTINCT c0_.marque AS marque_0 FROM car c0_ WHERE c0_.marque IS NOT NULL AND c0_.marque NOT IN (?) ORDER BY c0_.marque ASC Parameters: [`"MASERATI"`] View formatted query View runnable query Explain query SELECT DISTINCT c0_.marque AS marque_0 FROM car c0_ WHERE c0_.marque IS NOT NULL AND c0_.marque NOT IN (?) ORDER BY c0_.marque ASC SELECT DISTINCT c0_.marque AS marque_0 FROM car c0_ WHERE c0_.marque IS NOT NULL AND c0_.marque NOT IN ('MASERATI') ORDER BY c0_.marque ASC;
18	1.92 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;
19	1.43 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 c0_.name = ? AND e1_.publie = 1 AND c0_.state = 1 AND (e1_.count_car > 0 OR e1_.show_if_no_stock = 1) Parameters: [`"MITSUBISHI MOTORS"`] 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 c0_.name = ? AND e1_.publie = 1 AND c0_.state = 1 AND ( e1_.count_car > 0 OR e1_.show_if_no_stock = 1 ) 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 c0_.name = 'MITSUBISHI MOTORS' AND e1_.publie = 1 AND c0_.state = 1 AND (e1_.count_car > 0 OR e1_.show_if_no_stock = 1);
20	0.35 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"MITSUBISHI MOTORS"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.natcode AS natcode_3, t0.state AS state_4, t0.brand_logo AS brand_logo_5, t0.description AS description_6, t0.ranking_score AS ranking_score_7, t0.ranking_score_vn AS ranking_score_vn_8, t0.regroupement AS regroupement_9, t0.total_vo AS total_vo_10, t0.total_vn AS total_vn_11 FROM car_marque t0 WHERE t0.name = 'MITSUBISHI MOTORS' LIMIT 1;
21	0.23 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.label AS label_3, t0.image_path AS image_path_4, t0.link AS link_5, t0.text AS text_6, t0.link_label AS link_label_7, t0.marque_id AS marque_id_8 FROM marque_news t0 WHERE t0.marque_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.label AS label_3, t0.image_path AS image_path_4, t0.link AS link_5, t0.text AS text_6, t0.link_label AS link_label_7, t0.marque_id AS marque_id_8 FROM marque_news t0 WHERE t0.marque_id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.label AS label_3, t0.image_path AS image_path_4, t0.link AS link_5, t0.text AS text_6, t0.link_label AS link_label_7, t0.marque_id AS marque_id_8 FROM marque_news t0 WHERE t0.marque_id = 22;
22	0.29 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: [`"acheter_landing_configurateur_marque"`] 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 = 'acheter_landing_configurateur_marque' LIMIT 1;
23	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;
24	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: [`"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;
25	0.25 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: [`"acheter_landing_configurateur_marque"`] 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 = 'acheter_landing_configurateur_marque' LIMIT 1;
26	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"`] 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;
27	0.15 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;
28	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: [`"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;
29	0.43 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;
30	0.55 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: [`"acheter_landing_configurateur_marque"`] 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 = 'acheter_landing_configurateur_marque' LIMIT 1;
31	0.58 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: [`49`] 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 = 49;
32	0.43 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
33	1.05 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;
34	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
35	0.66 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;
36	0.13 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
37	0.45 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';
38	0.10 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
39	0.99 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;
40	13.30 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;
41	0.33 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
42	0.40 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;
43	0.24 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;
44	0.33 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
45	0.49 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;

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\Etablissement	No errors.
App\Entity\ModelExcludedConfigurator	No errors.
App\Entity\CarMarque	No errors.
App\Entity\CarModele	No errors.
App\Entity\MarqueNews	No errors.
App\Entity\Car	No errors.
App\Entity\User	No errors.
App\Entity\BlogPost	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\FilterQuestion	No errors.
App\Entity\CmsPage	No errors.
App\Entity\CmsBloc	No errors.
App\Entity\DataCount	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\GroupEtablissement	No errors.
App\Entity\Lead	No errors.
App\Entity\CarMedia	No errors.
App\Entity\CarAddition	No errors.
App\Entity\CarEntretien	No errors.
App\Entity\Favorite	No errors.
App\Entity\MyBuyProject	No errors.
App\Entity\Bca	No errors.
App\Entity\Role	No errors.
App\Entity\Newsletters	No errors.
App\Entity\VehicleAlert	No errors.
App\Entity\Comparative	No errors.
App\Entity\UserVehicle	No errors.
App\Entity\UserPayment	No errors.
App\Entity\Configurator	No errors.
App\Entity\NewsletterSubscription	No errors.
App\Entity\Document	No errors.
App\Entity\Promo	No errors.
App\Entity\PromoSlider	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%255CHomeController%253A%253ArenderPromo

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