Symfony Profiler

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;

SELECT
  c0_.modele AS modele_0,
  COUNT(c0_.modele) AS sclr_1
FROM
  car c0_
WHERE
  c0_.marque IN (NULL)
  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 (NULL) AND c0_.type IN ('VO', 'CM') AND c0_.published = 1 GROUP BY c0_.modele ORDER BY sclr_1 DESC;

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;

SELECT
  t0.id AS id_1,
  t0.name_full AS name_full_2,
  t0.natcode AS natcode_3,
  t0.marque_natcode AS marque_natcode_4,
  t0.name AS name_5,
  t0.family AS family_6,
  t0.state AS state_7,
  t0.import_begin AS import_begin_8,
  t0.import_end AS import_end_9,
  t0.image_url AS image_url_10,
  t0.ranking_score AS ranking_score_11,
  t0.car_marque_id AS car_marque_id_12
FROM
  car_modele t0
WHERE
  t0.name IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.natcode AS natcode_3, t0.marque_natcode AS marque_natcode_4, t0.name AS name_5, t0.family AS family_6, t0.state AS state_7, t0.import_begin AS import_begin_8, t0.import_end AS import_end_9, t0.image_url AS image_url_10, t0.ranking_score AS ranking_score_11, t0.car_marque_id AS car_marque_id_12 FROM car_modele t0 WHERE t0.name IS NULL LIMIT 1;

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 ('SSANGYONG') AND c0_.type IN ('VO', 'CM') AND c0_.published = 1 GROUP BY c0_.modele ORDER BY sclr_1 DESC;

SELECT
  DATABASE()

SELECT DATABASE();

"COMMIT"

"COMMIT";

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;

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

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 ('851', '835', '829', '828', '825', '816', '798', '791', '787', '786', '785', '784', '781', '780', '779', '775', '769', '757', '756', '751', '750');

UPDATE
  car_marque
SET
  ranking_score = ?
WHERE
  id = ?

UPDATE car_marque SET ranking_score = 14 WHERE id = 64;

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_result_vo_marque' 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 = 'totalConcession' LIMIT 1;

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;

SELECT
  c0_.name AS name_0
FROM
  car_marque c0_
WHERE
  c0_.name IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
ORDER BY
  c0_.ranking_score DESC
LIMIT
  8

SELECT c0_.name AS name_0 FROM car_marque c0_ WHERE c0_.name IN ('ABARTH', 'ALFA ROMEO', 'AUDI', 'BMW', 'CITROEN', 'CUPRA', 'DACIA', 'DS', 'FIAT', 'FORD', 'HONDA', 'HYUNDAI', 'JEEP', 'KIA', 'LAND ROVER', 'LEXUS', 'MASERATI', 'MERCEDES', 'MG', 'MINI', 'MITSUBISHI', 'NISSAN', 'OPEL', 'PEUGEOT', 'PORSCHE', 'RENAULT', 'SEAT', 'SKODA', 'SSANGYONG', 'SUZUKI', 'TOYOTA', 'VOLKSWAGEN', 'VOLVO') ORDER BY c0_.ranking_score DESC LIMIT 8;

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);

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;

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 = 'SSANGYONG' 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 = ?
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;