Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.post_id AS post_id_1,
  b0_.date AS date_2,
  b0_.modified_date AS modified_date_3,
  b0_.title AS title_4,
  b0_.content AS content_5,
  b0_.text AS text_6,
  b0_.tag_id AS tag_id_7,
  b0_.tag_name AS tag_name_8,
  b0_.media_id AS media_id_9,
  b0_.media_source_url AS media_source_url_10,
  b0_.link AS link_11
FROM
  blog_post b0_
  INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id
  INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id
WHERE
  b0_.tag_id IS NOT NULL
  AND b1_.category_id <> 1
ORDER BY
  b0_.date DESC
LIMIT
  16

SELECT b0_.id AS id_0, b0_.post_id AS post_id_1, b0_.date AS date_2, b0_.modified_date AS modified_date_3, b0_.title AS title_4, b0_.content AS content_5, b0_.text AS text_6, b0_.tag_id AS tag_id_7, b0_.tag_name AS tag_name_8, b0_.media_id AS media_id_9, b0_.media_source_url AS media_source_url_10, b0_.link AS link_11 FROM blog_post b0_ INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id WHERE b0_.tag_id IS NOT NULL AND b1_.category_id <> 1 ORDER BY b0_.date DESC LIMIT 16;

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.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
  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_.mecaplanning_ent_id AS mecaplanning_ent_id_114,
  e1_.mecaplanning_ent_key AS mecaplanning_ent_key_115,
  e1_.mecaplanning_dms_id AS mecaplanning_dms_id_116,
  e1_.mecaplanning_site_code AS mecaplanning_site_code_117,
  e1_.mecaplanning_site_id AS mecaplanning_site_id_118,
  e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_119,
  e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_120,
  e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_121,
  c0_.user_id AS user_id_122
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_.mecaplanning_ent_id AS mecaplanning_ent_id_114, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_115, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_116, e1_.mecaplanning_site_code AS mecaplanning_site_code_117, e1_.mecaplanning_site_id AS mecaplanning_site_id_118, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_119, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_120, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_121, c0_.user_id AS user_id_122 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 ('49688', '49687', '49686', '49685', '49684', '49683', '49682', '49681', '49680', '49679', '49678', '49677', '49676', '49675', '49674', '49673', '49672', '49671', '49670', '49669');

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

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', 'JEE', 'JEEP', 'KIA', 'LAND ROVER', 'LEX', 'LEXUS', 'MASERATI', 'MAZDA', 'MERCEDES', 'MG', 'MINI', 'MITSUBISHI', 'NISSAN', 'OPEL', 'PEUGEOT', 'PORSCHE', 'REN', 'RENAULT', 'SEAT', 'SKODA', 'SSANGYONG', 'SUZUKI', 'TOY', 'TOYOTA', 'VOL', 'VOLKSWAGEN', 'VOLVO', 'VW') ORDER BY c0_.ranking_score DESC LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.ville AS ville_2,
  t0.brand AS brand_3,
  t0.label AS label_4,
  t0.ranking_score AS ranking_score_5
FROM
  popular_ville t0
ORDER BY
  t0.ranking_score DESC
LIMIT
  30

SELECT t0.id AS id_1, t0.ville AS ville_2, t0.brand AS brand_3, t0.label AS label_4, t0.ranking_score AS ranking_score_5 FROM popular_ville t0 ORDER BY t0.ranking_score DESC LIMIT 30;

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
  e0_.code AS code_0,
  e0_.full_word AS full_word_1
FROM
  energie_reference e0_

SELECT e0_.code AS code_0, e0_.full_word AS full_word_1 FROM energie_reference e0_;

SELECT
  c0_.name AS name_0
FROM
  car_marque c0_
WHERE
  c0_.name IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND c0_.total_vo > 0

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', 'JEE', 'JEEP', 'KIA', 'LAND ROVER', 'LEX', 'LEXUS', 'MAZDA', 'MERCEDES', 'MG', 'MINI', 'MITSUBISHI', 'NISSAN', 'OPEL', 'PEUGEOT', 'PORSCHE', 'REN', 'RENAULT', 'SEAT', 'SKODA', 'SSANGYONG', 'SUZUKI', 'TOY', 'TOYOTA', 'VOL', 'VOLKSWAGEN', 'VOLVO', 'VW') AND c0_.total_vo > 0;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.brand_name AS brand_name_2,
  p0_.label AS label_3,
  p0_.ranking_score AS ranking_score_4,
  p0_.ranking_score_vn AS ranking_score_vn_5
FROM
  popular_modele p0_
WHERE
  p0_.ranking_score > 0
ORDER BY
  p0_.ranking_score DESC
LIMIT
  30

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.brand_name AS brand_name_2, p0_.label AS label_3, p0_.ranking_score AS ranking_score_4, p0_.ranking_score_vn AS ranking_score_vn_5 FROM popular_modele p0_ WHERE p0_.ranking_score > 0 ORDER BY p0_.ranking_score DESC LIMIT 30;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.brand_name AS brand_name_2,
  p0_.label AS label_3,
  p0_.ranking_score AS ranking_score_4,
  p0_.ranking_score_vn AS ranking_score_vn_5
FROM
  popular_modele p0_
WHERE
  p0_.ranking_score_vn > 0
ORDER BY
  p0_.ranking_score_vn DESC
LIMIT
  30

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.brand_name AS brand_name_2, p0_.label AS label_3, p0_.ranking_score AS ranking_score_4, p0_.ranking_score_vn AS ranking_score_vn_5 FROM popular_modele p0_ WHERE p0_.ranking_score_vn > 0 ORDER BY p0_.ranking_score_vn DESC LIMIT 30;

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;

SELECT
  DISTINCT c0_.name AS name_0
FROM
  car_marque c0_
WHERE
  c0_.ranking_score_vn > 0
  AND c0_.total_vn > 0
ORDER BY
  c0_.ranking_score_vn DESC
LIMIT
  30

SELECT DISTINCT c0_.name AS name_0 FROM car_marque c0_ WHERE c0_.ranking_score_vn > 0 AND c0_.total_vn > 0 ORDER BY c0_.ranking_score_vn DESC LIMIT 30;

SELECT
  DISTINCT c0_.name AS name_0
FROM
  car_marque c0_
WHERE
  c0_.ranking_score > 0
  AND c0_.total_vo > 0
ORDER BY
  c0_.ranking_score DESC
LIMIT
  30

SELECT DISTINCT c0_.name AS name_0 FROM car_marque c0_ WHERE c0_.ranking_score > 0 AND c0_.total_vo > 0 ORDER BY c0_.ranking_score DESC LIMIT 30;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.ranking_score AS ranking_score_2,
  c0_.ranking_score_vn AS ranking_score_vn_3
FROM
  car_type c0_
WHERE
  c0_.ranking_score > 0
ORDER BY
  c0_.ranking_score DESC
LIMIT
  30

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.ranking_score AS ranking_score_2, c0_.ranking_score_vn AS ranking_score_vn_3 FROM car_type c0_ WHERE c0_.ranking_score > 0 ORDER BY c0_.ranking_score DESC LIMIT 30;

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 = 3;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.ranking_score AS ranking_score_2,
  c0_.ranking_score_vn AS ranking_score_vn_3
FROM
  car_type c0_
WHERE
  c0_.ranking_score_vn > 0
ORDER BY
  c0_.ranking_score_vn DESC
LIMIT
  30

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.ranking_score AS ranking_score_2, c0_.ranking_score_vn AS ranking_score_vn_3 FROM car_type c0_ WHERE c0_.ranking_score_vn > 0 ORDER BY c0_.ranking_score_vn DESC LIMIT 30;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.image_url AS image_url_3,
  t0.type AS type_4,
  t0.query AS query_5
FROM
  popular_search t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.image_url AS image_url_3, t0.type AS type_4, t0.query AS query_5 FROM popular_search t0 WHERE t0.type = 'VO';