Symfony Profiler

Query Metrics

50 Database Queries

18 Different statements

27.07 ms Query time

0 Invalid entities

Queries

default connection


SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.moteur_type AS moteur_type_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.user_id AS user_id_60 FROM car t0 WHERE t0.id = ? LIMIT 1
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.opening_hours_periods AS opening_hours_periods_2, e0_.time_week_morning_start AS time_week_morning_start_3, e0_.time_week_morning_end AS time_week_morning_end_4, e0_.time_week_afternoon_start AS time_week_afternoon_start_5, e0_.time_week_afternoon_end AS time_week_afternoon_end_6, e0_.opening_hours_text AS opening_hours_text_7, e0_.adresse AS adresse_8, e0_.postal_code AS postal_code_9, e0_.ville AS ville_10, e0_.telephone AS telephone_11, e0_.email AS email_12, e0_.concession_email AS concession_email_13, e0_.concession_telephone AS concession_telephone_14, e0_.autodiscount_phone AS autodiscount_phone_15, e0_.latitude AS latitude_16, e0_.longtitude AS longtitude_17, e0_.street_number AS street_number_18, e0_.route AS route_19, e0_.disabled_google AS disabled_google_20, e0_.opening_hours_text AS opening_hours_text_21 FROM car c1_ INNER JOIN car_etablissement c2_ ON c1_.id = c2_.car_id INNER JOIN etablissement e0_ ON e0_.id = c2_.etablissement_id WHERE c1_.id = ? AND e0_.publie = 1 AND (e0_.virtuel <> 1 OR e0_.virtuel IS NULL) ORDER BY e0_.name ASC
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.moteur_type AS moteur_type_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.user_id AS user_id_60 FROM car t0 WHERE t0.id = ? AND t0.published = ? LIMIT 1
SELECT c0_.name AS name_0, c0_.date_entretien AS date_entretien_1 FROM car c1_ INNER JOIN car_entretien c0_ ON c1_.id = c0_.car_id WHERE c1_.id = ? AND c0_.name LIKE ? ORDER BY c0_.date_entretien DESC LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.date_entretien AS date_entretien_2, c0_.created_date AS created_date_3, c0_.car_id AS car_id_4 FROM car_entretien c0_ WHERE c0_.car_id = ? AND c0_.name NOT LIKE '%divers%' ORDER BY c0_.date_entretien DESC
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_.moteur_type AS moteur_type_56, c0_.created_at AS created_at_57, c0_.updated_at AS updated_at_58, e1_.id AS id_59, e1_.name AS name_60, e1_.alias AS alias_61, e1_.adresse AS adresse_62, e1_.postal_code AS postal_code_63, e1_.telephone AS telephone_64, e1_.contact_nom AS contact_nom_65, e1_.photos AS photos_66, e1_.fax AS fax_67, e1_.state AS state_68, e1_.count_car AS count_car_69, e1_.ville AS ville_70, e1_.latitude AS latitude_71, e1_.longtitude AS longtitude_72, e1_.description AS description_73, e1_.cgi_code AS cgi_code_74, e1_.time_week_morning_start AS time_week_morning_start_75, e1_.time_week_morning_end AS time_week_morning_end_76, e1_.time_week_afternoon_start AS time_week_afternoon_start_77, e1_.time_week_afternoon_end AS time_week_afternoon_end_78, e1_.time_we_morning_start AS time_we_morning_start_79, e1_.time_we_morning_end AS time_we_morning_end_80, e1_.time_we_afternoon_start AS time_we_afternoon_start_81, e1_.time_we_afternoon_end AS time_we_afternoon_end_82, e1_.autolink_id AS autolink_id_83, e1_.email AS email_84, e1_.image AS image_85, e1_.siren AS siren_86, e1_.autodiscount_name AS autodiscount_name_87, e1_.autodiscount_email AS autodiscount_email_88, e1_.autodiscount_phone AS autodiscount_phone_89, e1_.concession_email AS concession_email_90, e1_.concession_telephone AS concession_telephone_91, e1_.virtuel AS virtuel_92, e1_.id_base_tressol AS id_base_tressol_93, e1_.id_google AS id_google_94, e1_.affaire AS affaire_95, e1_.siret AS siret_96, e1_.garage_auto AS garage_auto_97, e1_.garage_moto AS garage_moto_98, e1_.occasion_pro AS occasion_pro_99, e1_.publie AS publie_100, e1_.experts AS experts_101, e1_.total_review AS total_review_102, e1_.average_review_rating AS average_review_rating_103, e1_.seo_description AS seo_description_104, e1_.opening_hours_text AS opening_hours_text_105, e1_.opening_hours_periods AS opening_hours_periods_106, e1_.raison_sociale AS raison_sociale_107, e1_.detail_stockage AS detail_stockage_108, e1_.street_number AS street_number_109, e1_.route AS route_110, e1_.bigquery AS bigquery_111, e1_.email_lead_vo AS email_lead_vo_112, e1_.disabled_google AS disabled_google_113, e1_.enable_json_lead AS enable_json_lead_114, e1_.show_if_no_stock AS show_if_no_stock_115, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_116, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_117, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_118, e1_.mecaplanning_site_code AS mecaplanning_site_code_119, e1_.mecaplanning_site_id AS mecaplanning_site_id_120, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_121, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_122, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_123, c0_.user_id AS user_id_124 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 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 e0_.code AS code_0, e0_.full_word AS full_word_1 FROM energie_reference e0_
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 p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.popup_type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.popup_type IN (?, ?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
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 p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?)
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.opening_hours_periods AS opening_hours_periods_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.ville AS ville_5, e0_.telephone AS telephone_6, e0_.email AS email_7, e0_.concession_email AS concession_email_8, e0_.concession_telephone AS concession_telephone_9, e0_.latitude AS latitude_10, e0_.longtitude AS longtitude_11, e0_.detail_stockage AS detail_stockage_12, c1_.name AS name_13 FROM etablissement e0_ LEFT JOIN etablissement_car_marque e2_ ON e0_.id = e2_.etablissement_id LEFT JOIN car_marque c1_ ON c1_.id = e2_.car_marque_id WHERE ((e0_.latitude IS NOT NULL AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1) OR e0_.id = ?) AND e0_.detail_stockage IS NULL ORDER BY e0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_for_meeting AS name_for_meeting_3, t0.description AS description_4, t0.image_id AS image_id_5 FROM expert t0
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1

#▲	Time	Info
1	1.15 ms	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.moteur_type AS moteur_type_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.user_id AS user_id_60 FROM car t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"5571"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.moteur_type AS moteur_type_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.user_id AS user_id_60 FROM car t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.moteur_type AS moteur_type_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.user_id AS user_id_60 FROM car t0 WHERE t0.id = '5571' LIMIT 1;
2	1.56 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.opening_hours_periods AS opening_hours_periods_2, e0_.time_week_morning_start AS time_week_morning_start_3, e0_.time_week_morning_end AS time_week_morning_end_4, e0_.time_week_afternoon_start AS time_week_afternoon_start_5, e0_.time_week_afternoon_end AS time_week_afternoon_end_6, e0_.opening_hours_text AS opening_hours_text_7, e0_.adresse AS adresse_8, e0_.postal_code AS postal_code_9, e0_.ville AS ville_10, e0_.telephone AS telephone_11, e0_.email AS email_12, e0_.concession_email AS concession_email_13, e0_.concession_telephone AS concession_telephone_14, e0_.autodiscount_phone AS autodiscount_phone_15, e0_.latitude AS latitude_16, e0_.longtitude AS longtitude_17, e0_.street_number AS street_number_18, e0_.route AS route_19, e0_.disabled_google AS disabled_google_20, e0_.opening_hours_text AS opening_hours_text_21 FROM car c1_ INNER JOIN car_etablissement c2_ ON c1_.id = c2_.car_id INNER JOIN etablissement e0_ ON e0_.id = c2_.etablissement_id WHERE c1_.id = ? AND e0_.publie = 1 AND (e0_.virtuel <> 1 OR e0_.virtuel IS NULL) ORDER BY e0_.name ASC Parameters: [`"5571"`] 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_.time_week_morning_start AS time_week_morning_start_3, e0_.time_week_morning_end AS time_week_morning_end_4, e0_.time_week_afternoon_start AS time_week_afternoon_start_5, e0_.time_week_afternoon_end AS time_week_afternoon_end_6, e0_.opening_hours_text AS opening_hours_text_7, e0_.adresse AS adresse_8, e0_.postal_code AS postal_code_9, e0_.ville AS ville_10, e0_.telephone AS telephone_11, e0_.email AS email_12, e0_.concession_email AS concession_email_13, e0_.concession_telephone AS concession_telephone_14, e0_.autodiscount_phone AS autodiscount_phone_15, e0_.latitude AS latitude_16, e0_.longtitude AS longtitude_17, e0_.street_number AS street_number_18, e0_.route AS route_19, e0_.disabled_google AS disabled_google_20, e0_.opening_hours_text AS opening_hours_text_21 FROM car c1_ INNER JOIN car_etablissement c2_ ON c1_.id = c2_.car_id INNER JOIN etablissement e0_ ON e0_.id = c2_.etablissement_id WHERE c1_.id = ? AND e0_.publie = 1 AND ( e0_.virtuel <> 1 OR e0_.virtuel 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_.time_week_morning_start AS time_week_morning_start_3, e0_.time_week_morning_end AS time_week_morning_end_4, e0_.time_week_afternoon_start AS time_week_afternoon_start_5, e0_.time_week_afternoon_end AS time_week_afternoon_end_6, e0_.opening_hours_text AS opening_hours_text_7, e0_.adresse AS adresse_8, e0_.postal_code AS postal_code_9, e0_.ville AS ville_10, e0_.telephone AS telephone_11, e0_.email AS email_12, e0_.concession_email AS concession_email_13, e0_.concession_telephone AS concession_telephone_14, e0_.autodiscount_phone AS autodiscount_phone_15, e0_.latitude AS latitude_16, e0_.longtitude AS longtitude_17, e0_.street_number AS street_number_18, e0_.route AS route_19, e0_.disabled_google AS disabled_google_20, e0_.opening_hours_text AS opening_hours_text_21 FROM car c1_ INNER JOIN car_etablissement c2_ ON c1_.id = c2_.car_id INNER JOIN etablissement e0_ ON e0_.id = c2_.etablissement_id WHERE c1_.id = '5571' AND e0_.publie = 1 AND (e0_.virtuel <> 1 OR e0_.virtuel IS NULL) ORDER BY e0_.name ASC;
3	0.50 ms	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.moteur_type AS moteur_type_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.user_id AS user_id_60 FROM car t0 WHERE t0.id = ? AND t0.published = ? LIMIT 1 Parameters: [`"5571" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.moteur_type AS moteur_type_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.user_id AS user_id_60 FROM car t0 WHERE t0.id = ? AND t0.published = ? LIMIT 1 SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.moteur_type AS moteur_type_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.user_id AS user_id_60 FROM car t0 WHERE t0.id = '5571' AND t0.published = 1 LIMIT 1;
4	0.38 ms	SELECT c0_.name AS name_0, c0_.date_entretien AS date_entretien_1 FROM car c1_ INNER JOIN car_entretien c0_ ON c1_.id = c0_.car_id WHERE c1_.id = ? AND c0_.name LIKE ? ORDER BY c0_.date_entretien DESC LIMIT 1 Parameters: [`"5571" "%controle technique%"`] View formatted query View runnable query Explain query SELECT c0_.name AS name_0, c0_.date_entretien AS date_entretien_1 FROM car c1_ INNER JOIN car_entretien c0_ ON c1_.id = c0_.car_id WHERE c1_.id = ? AND c0_.name LIKE ? ORDER BY c0_.date_entretien DESC LIMIT 1 SELECT c0_.name AS name_0, c0_.date_entretien AS date_entretien_1 FROM car c1_ INNER JOIN car_entretien c0_ ON c1_.id = c0_.car_id WHERE c1_.id = '5571' AND c0_.name LIKE '%controle technique%' ORDER BY c0_.date_entretien DESC LIMIT 1;
5	0.36 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.date_entretien AS date_entretien_2, c0_.created_date AS created_date_3, c0_.car_id AS car_id_4 FROM car_entretien c0_ WHERE c0_.car_id = ? AND c0_.name NOT LIKE '%divers%' ORDER BY c0_.date_entretien DESC Parameters: [`"5571"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.date_entretien AS date_entretien_2, c0_.created_date AS created_date_3, c0_.car_id AS car_id_4 FROM car_entretien c0_ WHERE c0_.car_id = ? AND c0_.name NOT LIKE '%divers%' ORDER BY c0_.date_entretien DESC SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.date_entretien AS date_entretien_2, c0_.created_date AS created_date_3, c0_.car_id AS car_id_4 FROM car_entretien c0_ WHERE c0_.car_id = '5571' AND c0_.name NOT LIKE '%divers%' ORDER BY c0_.date_entretien DESC;
6	1.51 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_.moteur_type AS moteur_type_56, c0_.created_at AS created_at_57, c0_.updated_at AS updated_at_58, e1_.id AS id_59, e1_.name AS name_60, e1_.alias AS alias_61, e1_.adresse AS adresse_62, e1_.postal_code AS postal_code_63, e1_.telephone AS telephone_64, e1_.contact_nom AS contact_nom_65, e1_.photos AS photos_66, e1_.fax AS fax_67, e1_.state AS state_68, e1_.count_car AS count_car_69, e1_.ville AS ville_70, e1_.latitude AS latitude_71, e1_.longtitude AS longtitude_72, e1_.description AS description_73, e1_.cgi_code AS cgi_code_74, e1_.time_week_morning_start AS time_week_morning_start_75, e1_.time_week_morning_end AS time_week_morning_end_76, e1_.time_week_afternoon_start AS time_week_afternoon_start_77, e1_.time_week_afternoon_end AS time_week_afternoon_end_78, e1_.time_we_morning_start AS time_we_morning_start_79, e1_.time_we_morning_end AS time_we_morning_end_80, e1_.time_we_afternoon_start AS time_we_afternoon_start_81, e1_.time_we_afternoon_end AS time_we_afternoon_end_82, e1_.autolink_id AS autolink_id_83, e1_.email AS email_84, e1_.image AS image_85, e1_.siren AS siren_86, e1_.autodiscount_name AS autodiscount_name_87, e1_.autodiscount_email AS autodiscount_email_88, e1_.autodiscount_phone AS autodiscount_phone_89, e1_.concession_email AS concession_email_90, e1_.concession_telephone AS concession_telephone_91, e1_.virtuel AS virtuel_92, e1_.id_base_tressol AS id_base_tressol_93, e1_.id_google AS id_google_94, e1_.affaire AS affaire_95, e1_.siret AS siret_96, e1_.garage_auto AS garage_auto_97, e1_.garage_moto AS garage_moto_98, e1_.occasion_pro AS occasion_pro_99, e1_.publie AS publie_100, e1_.experts AS experts_101, e1_.total_review AS total_review_102, e1_.average_review_rating AS average_review_rating_103, e1_.seo_description AS seo_description_104, e1_.opening_hours_text AS opening_hours_text_105, e1_.opening_hours_periods AS opening_hours_periods_106, e1_.raison_sociale AS raison_sociale_107, e1_.detail_stockage AS detail_stockage_108, e1_.street_number AS street_number_109, e1_.route AS route_110, e1_.bigquery AS bigquery_111, e1_.email_lead_vo AS email_lead_vo_112, e1_.disabled_google AS disabled_google_113, e1_.enable_json_lead AS enable_json_lead_114, e1_.show_if_no_stock AS show_if_no_stock_115, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_116, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_117, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_118, e1_.mecaplanning_site_code AS mecaplanning_site_code_119, e1_.mecaplanning_site_id AS mecaplanning_site_id_120, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_121, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_122, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_123, c0_.user_id AS user_id_124 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"5565" "5560" "5568" "4525" "5564" "5559" "5558" "5561" "5572" "7243"`] 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_.moteur_type AS moteur_type_56, c0_.created_at AS created_at_57, c0_.updated_at AS updated_at_58, e1_.id AS id_59, e1_.name AS name_60, e1_.alias AS alias_61, e1_.adresse AS adresse_62, e1_.postal_code AS postal_code_63, e1_.telephone AS telephone_64, e1_.contact_nom AS contact_nom_65, e1_.photos AS photos_66, e1_.fax AS fax_67, e1_.state AS state_68, e1_.count_car AS count_car_69, e1_.ville AS ville_70, e1_.latitude AS latitude_71, e1_.longtitude AS longtitude_72, e1_.description AS description_73, e1_.cgi_code AS cgi_code_74, e1_.time_week_morning_start AS time_week_morning_start_75, e1_.time_week_morning_end AS time_week_morning_end_76, e1_.time_week_afternoon_start AS time_week_afternoon_start_77, e1_.time_week_afternoon_end AS time_week_afternoon_end_78, e1_.time_we_morning_start AS time_we_morning_start_79, e1_.time_we_morning_end AS time_we_morning_end_80, e1_.time_we_afternoon_start AS time_we_afternoon_start_81, e1_.time_we_afternoon_end AS time_we_afternoon_end_82, e1_.autolink_id AS autolink_id_83, e1_.email AS email_84, e1_.image AS image_85, e1_.siren AS siren_86, e1_.autodiscount_name AS autodiscount_name_87, e1_.autodiscount_email AS autodiscount_email_88, e1_.autodiscount_phone AS autodiscount_phone_89, e1_.concession_email AS concession_email_90, e1_.concession_telephone AS concession_telephone_91, e1_.virtuel AS virtuel_92, e1_.id_base_tressol AS id_base_tressol_93, e1_.id_google AS id_google_94, e1_.affaire AS affaire_95, e1_.siret AS siret_96, e1_.garage_auto AS garage_auto_97, e1_.garage_moto AS garage_moto_98, e1_.occasion_pro AS occasion_pro_99, e1_.publie AS publie_100, e1_.experts AS experts_101, e1_.total_review AS total_review_102, e1_.average_review_rating AS average_review_rating_103, e1_.seo_description AS seo_description_104, e1_.opening_hours_text AS opening_hours_text_105, e1_.opening_hours_periods AS opening_hours_periods_106, e1_.raison_sociale AS raison_sociale_107, e1_.detail_stockage AS detail_stockage_108, e1_.street_number AS street_number_109, e1_.route AS route_110, e1_.bigquery AS bigquery_111, e1_.email_lead_vo AS email_lead_vo_112, e1_.disabled_google AS disabled_google_113, e1_.enable_json_lead AS enable_json_lead_114, e1_.show_if_no_stock AS show_if_no_stock_115, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_116, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_117, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_118, e1_.mecaplanning_site_code AS mecaplanning_site_code_119, e1_.mecaplanning_site_id AS mecaplanning_site_id_120, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_121, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_122, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_123, c0_.user_id AS user_id_124 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_.moteur_type AS moteur_type_56, c0_.created_at AS created_at_57, c0_.updated_at AS updated_at_58, e1_.id AS id_59, e1_.name AS name_60, e1_.alias AS alias_61, e1_.adresse AS adresse_62, e1_.postal_code AS postal_code_63, e1_.telephone AS telephone_64, e1_.contact_nom AS contact_nom_65, e1_.photos AS photos_66, e1_.fax AS fax_67, e1_.state AS state_68, e1_.count_car AS count_car_69, e1_.ville AS ville_70, e1_.latitude AS latitude_71, e1_.longtitude AS longtitude_72, e1_.description AS description_73, e1_.cgi_code AS cgi_code_74, e1_.time_week_morning_start AS time_week_morning_start_75, e1_.time_week_morning_end AS time_week_morning_end_76, e1_.time_week_afternoon_start AS time_week_afternoon_start_77, e1_.time_week_afternoon_end AS time_week_afternoon_end_78, e1_.time_we_morning_start AS time_we_morning_start_79, e1_.time_we_morning_end AS time_we_morning_end_80, e1_.time_we_afternoon_start AS time_we_afternoon_start_81, e1_.time_we_afternoon_end AS time_we_afternoon_end_82, e1_.autolink_id AS autolink_id_83, e1_.email AS email_84, e1_.image AS image_85, e1_.siren AS siren_86, e1_.autodiscount_name AS autodiscount_name_87, e1_.autodiscount_email AS autodiscount_email_88, e1_.autodiscount_phone AS autodiscount_phone_89, e1_.concession_email AS concession_email_90, e1_.concession_telephone AS concession_telephone_91, e1_.virtuel AS virtuel_92, e1_.id_base_tressol AS id_base_tressol_93, e1_.id_google AS id_google_94, e1_.affaire AS affaire_95, e1_.siret AS siret_96, e1_.garage_auto AS garage_auto_97, e1_.garage_moto AS garage_moto_98, e1_.occasion_pro AS occasion_pro_99, e1_.publie AS publie_100, e1_.experts AS experts_101, e1_.total_review AS total_review_102, e1_.average_review_rating AS average_review_rating_103, e1_.seo_description AS seo_description_104, e1_.opening_hours_text AS opening_hours_text_105, e1_.opening_hours_periods AS opening_hours_periods_106, e1_.raison_sociale AS raison_sociale_107, e1_.detail_stockage AS detail_stockage_108, e1_.street_number AS street_number_109, e1_.route AS route_110, e1_.bigquery AS bigquery_111, e1_.email_lead_vo AS email_lead_vo_112, e1_.disabled_google AS disabled_google_113, e1_.enable_json_lead AS enable_json_lead_114, e1_.show_if_no_stock AS show_if_no_stock_115, e1_.mecaplanning_ent_id AS mecaplanning_ent_id_116, e1_.mecaplanning_ent_key AS mecaplanning_ent_key_117, e1_.mecaplanning_dms_id AS mecaplanning_dms_id_118, e1_.mecaplanning_site_code AS mecaplanning_site_code_119, e1_.mecaplanning_site_id AS mecaplanning_site_id_120, e1_.mecaplanning_workshop_code AS mecaplanning_workshop_code_121, e1_.mecaplanning_workshop_id AS mecaplanning_workshop_id_122, e1_.mecaplanning_porovider_name AS mecaplanning_porovider_name_123, c0_.user_id AS user_id_124 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 ('5565', '5560', '5568', '4525', '5564', '5559', '5558', '5561', '5572', '7243');
7	0.72 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: [`"carDetailNew"`] 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 = 'carDetailNew' LIMIT 1;
8	0.33 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"totalConcession"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = 'totalConcession' LIMIT 1;
9	0.35 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"USED_CAR"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = 'USED_CAR' LIMIT 1;
10	0.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: [`"carDetailNew"`] 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 = 'carDetailNew' LIMIT 1;
11	0.28 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"totalConcession"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = 'totalConcession' LIMIT 1;
12	0.26 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"USED_CAR"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = 'USED_CAR' LIMIT 1;
13	0.60 ms	SELECT e0_.code AS code_0, e0_.full_word AS full_word_1 FROM energie_reference e0_ Parameters: [] View formatted query View runnable query Explain query 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_;
14	0.49 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"USED_CAR"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = 'USED_CAR' LIMIT 1;
15	0.50 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"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;
16	0.63 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: [`"carDetailNew"`] 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 = 'carDetailNew' LIMIT 1;
17	0.45 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: [`6`] 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 = 6;
18	0.50 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
19	2.39 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;
20	0.46 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
21	0.75 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL;
22	0.38 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.popup_type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.popup_type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.popup_type IN (1);
23	0.38 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.popup_type IN (?, ?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 2 3`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.popup_type IN (?, ?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.popup_type IN (2, 3);
24	0.76 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
25	0.52 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
26	0.47 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
27	0.47 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
28	0.33 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
29	0.36 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
30	0.33 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
31	0.28 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
32	0.24 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
33	0.32 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
34	0.26 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
35	0.25 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
36	0.25 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
37	0.29 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
38	0.26 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
39	0.27 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
40	0.28 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
41	0.28 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
42	0.30 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
43	0.36 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
44	0.28 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;
45	0.53 ms	SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= ? AND ? <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) Parameters: [`"2025-06-15 23:10:29" "2025-06-15 23:10:29" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE ( p0_.start_date <= ? AND ? <= p0_.end_date ) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (?) SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.legales_text AS legales_text_4, p0_.url AS url_5, p0_.name AS name_6, p0_.type AS type_7, p0_.popup_type AS popup_type_8, p0_.text1 AS text1_9, p0_.text2 AS text2_10, p0_.background_color AS background_color_11, p0_.text_color1 AS text_color1_12, p0_.text_button AS text_button_13, p0_.text_button_color AS text_button_color_14, p0_.text_button_background_color AS text_button_background_color_15, p0_.image2 AS image2_16, p0_.label_image AS label_image_17, p0_.label_image2 AS label_image2_18, p0_.label_name AS label_name_19, p0_.image3 AS image3_20, p0_.seo_utm_campaign AS seo_utm_campaign_21, p0_.enable_financement AS enable_financement_22, p0_.financement_type AS financement_type_23, p0_.financement_amount AS financement_amount_24, p0_.label_image_search AS label_image_search_25 FROM promo p0_ WHERE (p0_.start_date <= '2025-06-15 23:10:29' AND '2025-06-15 23:10:29' <= p0_.end_date) AND p0_.type IS NOT NULL AND p0_.popup_type IS NOT NULL AND p0_.type IN (1);
46	2.21 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;
47	0.62 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.name_for_meeting AS name_for_meeting_3, t0.description AS description_4, t0.image_id AS image_id_5 FROM expert t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.name_for_meeting AS name_for_meeting_3, t0.description AS description_4, t0.image_id AS image_id_5 FROM expert t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.name_for_meeting AS name_for_meeting_3, t0.description AS description_4, t0.image_id AS image_id_5 FROM expert t0;
48	0.51 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;
49	0.32 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"BRAND"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = 'BRAND' LIMIT 1;
50	0.50 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"totalConcession"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = 'totalConcession' LIMIT 1;

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Car	No errors.
App\Entity\User	No errors.
App\Entity\CarMedia	No errors.
App\Entity\CarAddition	No errors.
App\Entity\Etablissement	No errors.
App\Entity\CarEntretien	No errors.
App\Entity\Favorite	No errors.
App\Entity\MyBuyProject	No errors.
App\Entity\Meeting	No errors.
App\Entity\Lead	No errors.
App\Entity\CarMarque	No errors.
App\Entity\EtablissementService	No errors.
App\Entity\ReviewDetail	No errors.
App\Entity\ExpertContact	No errors.
App\Entity\LeadEstimate	No errors.
App\Entity\PrendreRdv	No errors.
App\Entity\ClientRequest	No errors.
App\Entity\GroupEtablissement	No errors.
App\Entity\CmsPage	No errors.
App\Entity\CmsBloc	No errors.
App\Entity\DataCount	No errors.
App\Entity\EnergieReference	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\MyBuyProjectAction	No errors.
App\Entity\CarModele	No errors.
App\Entity\MarqueNews	No errors.
App\Entity\Upload	No errors.
App\Entity\Expert	No errors.
App\Entity\MyMaintainProjectAction	No errors.
App\Entity\Promo	No errors.
App\Entity\MySellProjectAction	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\PromoSlider	No errors.
App\Entity\BlogPost	No errors.

internal entity manager

No loaded entities.

Symfony Profiler

GET https://tressol.yeah.agency/voiture/occasion/JEEP/mod%C3%A8le-RENEGADE/Renegade%201.4%20I%20MultiAir%20S&S%20140%20ch%20Limited-5571

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