Symfony Profiler

SELECT
  t0.name AS name_1,
  t0.second_name AS second_name_2,
  t0.reference AS reference_3,
  t0.icon AS icon_4,
  t0.score AS score_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.slug AS slug_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10,
  t0.popular_category_id AS popular_category_id_11,
  t0.quotation_id AS quotation_id_12
FROM
  category t0
  INNER JOIN establishment_category ON t0.id = establishment_category.category_id
WHERE
  establishment_category.establishment_id = ?

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = 571;

SELECT
  t0.name AS name_1,
  t0.size AS size_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.establishment_id AS establishment_id_5,
  t0.comment_id AS comment_id_6,
  t0.logos_id AS logos_id_7,
  t0.campagne_id AS campagne_id_8,
  t0.job_offert_id AS job_offert_id_9,
  t0.landing_page_id AS landing_page_id_10
FROM
  image t0
WHERE
  t0.establishment_id = ?

SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = 571;

SELECT
  e0_.name AS name_0,
  e0_.note AS note_1,
  e0_.manager AS manager_2,
  e0_.reference AS reference_3,
  e0_.phone AS phone_4,
  e0_.description AS description_5,
  e0_.website AS website_6,
  e0_.email AS email_7,
  e0_.phone2 AS phone2_8,
  e0_.view_number AS view_number_9,
  e0_.verified AS verified_10,
  e0_.score AS score_11,
  e0_.keywords AS keywords_12,
  e0_.place_id AS place_id_13,
  e0_.platform AS platform_14,
  e0_.version AS version_15,
  e0_.google_type AS google_type_16,
  e0_.google_photos AS google_photos_17,
  e0_.map_url AS map_url_18,
  e0_.weekday_text AS weekday_text_19,
  e0_.enabled AS enabled_20,
  e0_.ranks AS ranks_21,
  e0_.full_address AS full_address_22,
  e0_.latitude AS latitude_23,
  e0_.longitude AS longitude_24,
  e0_.created_at AS created_at_25,
  e0_.updated_at AS updated_at_26,
  e0_.slug AS slug_27,
  e0_.id AS id_28,
  e0_.facebook AS facebook_29,
  e0_.youtube AS youtube_30,
  e0_.instagram AS instagram_31,
  e0_.twitter AS twitter_32,
  e0_.google_plus AS google_plus_33,
  e0_.region_id AS region_id_34,
  e0_.commune_id AS commune_id_35,
  e0_.city_id AS city_id_36,
  e0_.quartier_id AS quartier_id_37,
  e0_.sub_prefecture_id AS sub_prefecture_id_38,
  e0_.prefecture_id AS prefecture_id_39,
  e0_.campagne_id AS campagne_id_40,
  e0_.operator_id AS operator_id_41,
  e0_.quotation_id AS quotation_id_42
FROM
  establishment e0_

SELECT e0_.name AS name_0, e0_.note AS note_1, e0_.manager AS manager_2, e0_.reference AS reference_3, e0_.phone AS phone_4, e0_.description AS description_5, e0_.website AS website_6, e0_.email AS email_7, e0_.phone2 AS phone2_8, e0_.view_number AS view_number_9, e0_.verified AS verified_10, e0_.score AS score_11, e0_.keywords AS keywords_12, e0_.place_id AS place_id_13, e0_.platform AS platform_14, e0_.version AS version_15, e0_.google_type AS google_type_16, e0_.google_photos AS google_photos_17, e0_.map_url AS map_url_18, e0_.weekday_text AS weekday_text_19, e0_.enabled AS enabled_20, e0_.ranks AS ranks_21, e0_.full_address AS full_address_22, e0_.latitude AS latitude_23, e0_.longitude AS longitude_24, e0_.created_at AS created_at_25, e0_.updated_at AS updated_at_26, e0_.slug AS slug_27, e0_.id AS id_28, e0_.facebook AS facebook_29, e0_.youtube AS youtube_30, e0_.instagram AS instagram_31, e0_.twitter AS twitter_32, e0_.google_plus AS google_plus_33, e0_.region_id AS region_id_34, e0_.commune_id AS commune_id_35, e0_.city_id AS city_id_36, e0_.quartier_id AS quartier_id_37, e0_.sub_prefecture_id AS sub_prefecture_id_38, e0_.prefecture_id AS prefecture_id_39, e0_.campagne_id AS campagne_id_40, e0_.operator_id AS operator_id_41, e0_.quotation_id AS quotation_id_42 FROM establishment e0_;

SELECT
  t0.content AS content_1,
  t0.rating AS rating_2,
  t0.value_money AS value_money_3,
  t0.location AS location_4,
  t0.cleanliness AS cleanliness_5,
  t0.author_url AS author_url_6,
  t0.google_comment_created_at AS google_comment_created_at_7,
  t0.enabled AS enabled_8,
  t0.id AS id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.parent_id AS parent_id_12,
  t0.establishement_id AS establishement_id_13,
  t0.author_id AS author_id_14
FROM
  COMMENT t0
WHERE
  t0.establishement_id = ?

SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = 571;

SELECT
  c0_.name AS name_0,
  c0_.second_name AS second_name_1,
  c0_.reference AS reference_2,
  c0_.icon AS icon_3,
  c0_.score AS score_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.slug AS slug_7,
  c0_.id AS id_8,
  c0_.parent_id AS parent_id_9,
  c0_.popular_category_id AS popular_category_id_10,
  c0_.quotation_id AS quotation_id_11
FROM
  category c0_
ORDER BY
  c0_.name ASC

SELECT c0_.name AS name_0, c0_.second_name AS second_name_1, c0_.reference AS reference_2, c0_.icon AS icon_3, c0_.score AS score_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.slug AS slug_7, c0_.id AS id_8, c0_.parent_id AS parent_id_9, c0_.popular_category_id AS popular_category_id_10, c0_.quotation_id AS quotation_id_11 FROM category c0_ ORDER BY c0_.name ASC;

SELECT
  c0_.name AS name_0,
  c0_.second_name AS second_name_1,
  c0_.reference AS reference_2,
  c0_.icon AS icon_3,
  c0_.score AS score_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.slug AS slug_7,
  c0_.id AS id_8,
  c0_.parent_id AS parent_id_9,
  c0_.popular_category_id AS popular_category_id_10,
  c0_.quotation_id AS quotation_id_11
FROM
  category c0_

SELECT c0_.name AS name_0, c0_.second_name AS second_name_1, c0_.reference AS reference_2, c0_.icon AS icon_3, c0_.score AS score_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.slug AS slug_7, c0_.id AS id_8, c0_.parent_id AS parent_id_9, c0_.popular_category_id AS popular_category_id_10, c0_.quotation_id AS quotation_id_11 FROM category c0_;

SELECT
  s0_.name AS name_0,
  s0_.latitude AS latitude_1,
  s0_.longitude AS longitude_2,
  s0_.id AS id_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.slug AS slug_6,
  s0_.prefecture_id AS prefecture_id_7
FROM
  sub_prefecture s0_
ORDER BY
  s0_.name ASC

SELECT s0_.name AS name_0, s0_.latitude AS latitude_1, s0_.longitude AS longitude_2, s0_.id AS id_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.slug AS slug_6, s0_.prefecture_id AS prefecture_id_7 FROM sub_prefecture s0_ ORDER BY s0_.name ASC;

SELECT
  e0_.name AS name_0,
  e0_.note AS note_1,
  e0_.manager AS manager_2,
  e0_.reference AS reference_3,
  e0_.phone AS phone_4,
  e0_.description AS description_5,
  e0_.website AS website_6,
  e0_.email AS email_7,
  e0_.phone2 AS phone2_8,
  e0_.view_number AS view_number_9,
  e0_.verified AS verified_10,
  e0_.score AS score_11,
  e0_.keywords AS keywords_12,
  e0_.place_id AS place_id_13,
  e0_.platform AS platform_14,
  e0_.version AS version_15,
  e0_.google_type AS google_type_16,
  e0_.google_photos AS google_photos_17,
  e0_.map_url AS map_url_18,
  e0_.weekday_text AS weekday_text_19,
  e0_.enabled AS enabled_20,
  e0_.ranks AS ranks_21,
  e0_.full_address AS full_address_22,
  e0_.latitude AS latitude_23,
  e0_.longitude AS longitude_24,
  e0_.created_at AS created_at_25,
  e0_.updated_at AS updated_at_26,
  e0_.slug AS slug_27,
  e0_.id AS id_28,
  e0_.facebook AS facebook_29,
  e0_.youtube AS youtube_30,
  e0_.instagram AS instagram_31,
  e0_.twitter AS twitter_32,
  e0_.google_plus AS google_plus_33,
  e0_.region_id AS region_id_34,
  e0_.commune_id AS commune_id_35,
  e0_.city_id AS city_id_36,
  e0_.quartier_id AS quartier_id_37,
  e0_.sub_prefecture_id AS sub_prefecture_id_38,
  e0_.prefecture_id AS prefecture_id_39,
  e0_.campagne_id AS campagne_id_40,
  e0_.operator_id AS operator_id_41,
  e0_.quotation_id AS quotation_id_42
FROM
  establishment e0_
WHERE
  e0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT e0_.name AS name_0, e0_.note AS note_1, e0_.manager AS manager_2, e0_.reference AS reference_3, e0_.phone AS phone_4, e0_.description AS description_5, e0_.website AS website_6, e0_.email AS email_7, e0_.phone2 AS phone2_8, e0_.view_number AS view_number_9, e0_.verified AS verified_10, e0_.score AS score_11, e0_.keywords AS keywords_12, e0_.place_id AS place_id_13, e0_.platform AS platform_14, e0_.version AS version_15, e0_.google_type AS google_type_16, e0_.google_photos AS google_photos_17, e0_.map_url AS map_url_18, e0_.weekday_text AS weekday_text_19, e0_.enabled AS enabled_20, e0_.ranks AS ranks_21, e0_.full_address AS full_address_22, e0_.latitude AS latitude_23, e0_.longitude AS longitude_24, e0_.created_at AS created_at_25, e0_.updated_at AS updated_at_26, e0_.slug AS slug_27, e0_.id AS id_28, e0_.facebook AS facebook_29, e0_.youtube AS youtube_30, e0_.instagram AS instagram_31, e0_.twitter AS twitter_32, e0_.google_plus AS google_plus_33, e0_.region_id AS region_id_34, e0_.commune_id AS commune_id_35, e0_.city_id AS city_id_36, e0_.quartier_id AS quartier_id_37, e0_.sub_prefecture_id AS sub_prefecture_id_38, e0_.prefecture_id AS prefecture_id_39, e0_.campagne_id AS campagne_id_40, e0_.operator_id AS operator_id_41, e0_.quotation_id AS quotation_id_42 FROM establishment e0_ WHERE e0_.id IN ('571', '572', '478', '469', '481', '468', '84', '490', '211', '486', '472', '467', '489', '465', '474', '62', '495', '483', '484', '466', '487', '462', '479', '473', '493', '461', '391', '460', '459', '430', '622', '623', '458', '496', '476', '563', '716', '156', '463', '498', '485', '18', '492', '491', '477', '488', '480', '475', '499', '494', '560', '561', '714', '717', '69', '202', '399');

SELECT
  t0.name AS name_1,
  t0.note AS note_2,
  t0.manager AS manager_3,
  t0.reference AS reference_4,
  t0.phone AS phone_5,
  t0.description AS description_6,
  t0.website AS website_7,
  t0.email AS email_8,
  t0.phone2 AS phone2_9,
  t0.view_number AS view_number_10,
  t0.verified AS verified_11,
  t0.score AS score_12,
  t0.keywords AS keywords_13,
  t0.place_id AS place_id_14,
  t0.platform AS platform_15,
  t0.version AS version_16,
  t0.google_type AS google_type_17,
  t0.google_photos AS google_photos_18,
  t0.map_url AS map_url_19,
  t0.weekday_text AS weekday_text_20,
  t0.enabled AS enabled_21,
  t0.ranks AS ranks_22,
  t0.full_address AS full_address_23,
  t0.latitude AS latitude_24,
  t0.longitude AS longitude_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.slug AS slug_28,
  t0.id AS id_29,
  t0.facebook AS facebook_30,
  t0.youtube AS youtube_31,
  t0.instagram AS instagram_32,
  t0.twitter AS twitter_33,
  t0.google_plus AS google_plus_34,
  t0.region_id AS region_id_35,
  t0.commune_id AS commune_id_36,
  t0.city_id AS city_id_37,
  t0.quartier_id AS quartier_id_38,
  t0.sub_prefecture_id AS sub_prefecture_id_39,
  t0.prefecture_id AS prefecture_id_40,
  t0.campagne_id AS campagne_id_41,
  t0.operator_id AS operator_id_42,
  t0.quotation_id AS quotation_id_43
FROM
  establishment t0
WHERE
  t0.campagne_id = ?

SELECT t0.name AS name_1, t0.note AS note_2, t0.manager AS manager_3, t0.reference AS reference_4, t0.phone AS phone_5, t0.description AS description_6, t0.website AS website_7, t0.email AS email_8, t0.phone2 AS phone2_9, t0.view_number AS view_number_10, t0.verified AS verified_11, t0.score AS score_12, t0.keywords AS keywords_13, t0.place_id AS place_id_14, t0.platform AS platform_15, t0.version AS version_16, t0.google_type AS google_type_17, t0.google_photos AS google_photos_18, t0.map_url AS map_url_19, t0.weekday_text AS weekday_text_20, t0.enabled AS enabled_21, t0.ranks AS ranks_22, t0.full_address AS full_address_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.slug AS slug_28, t0.id AS id_29, t0.facebook AS facebook_30, t0.youtube AS youtube_31, t0.instagram AS instagram_32, t0.twitter AS twitter_33, t0.google_plus AS google_plus_34, t0.region_id AS region_id_35, t0.commune_id AS commune_id_36, t0.city_id AS city_id_37, t0.quartier_id AS quartier_id_38, t0.sub_prefecture_id AS sub_prefecture_id_39, t0.prefecture_id AS prefecture_id_40, t0.campagne_id AS campagne_id_41, t0.operator_id AS operator_id_42, t0.quotation_id AS quotation_id_43 FROM establishment t0 WHERE t0.campagne_id = 9;

SELECT
  r0_.name AS name_0,
  r0_.latitude AS latitude_1,
  r0_.longitude AS longitude_2,
  r0_.id AS id_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5,
  r0_.slug AS slug_6
FROM
  region r0_

SELECT r0_.name AS name_0, r0_.latitude AS latitude_1, r0_.longitude AS longitude_2, r0_.id AS id_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.slug AS slug_6 FROM region r0_;

SELECT
  t0.name AS name_1,
  t0.second_name AS second_name_2,
  t0.reference AS reference_3,
  t0.icon AS icon_4,
  t0.score AS score_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.slug AS slug_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10,
  t0.popular_category_id AS popular_category_id_11,
  t0.quotation_id AS quotation_id_12
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 WHERE t0.slug = 'hotels' LIMIT 1;

SELECT
  c0_.name AS name_0,
  c0_.start_at AS start_at_1,
  c0_.end_at AS end_at_2,
  c0_.status AS status_3,
  c0_.space AS space_4,
  c0_.type AS type_5,
  c0_.title AS title_6,
  c0_.content AS content_7,
  c0_.ranks AS ranks_8,
  c0_.summary AS summary_9,
  c0_.link AS link_10,
  c0_.id AS id_11,
  c0_.created_at AS created_at_12,
  c0_.updated_at AS updated_at_13
FROM
  campagne c0_
WHERE
  c0_.status = ?
  AND c0_.start_at <= ?
  AND c0_.end_at >= ?
ORDER BY
  c0_.id ASC
LIMIT
  4

SELECT c0_.name AS name_0, c0_.start_at AS start_at_1, c0_.end_at AS end_at_2, c0_.status AS status_3, c0_.space AS space_4, c0_.type AS type_5, c0_.title AS title_6, c0_.content AS content_7, c0_.ranks AS ranks_8, c0_.summary AS summary_9, c0_.link AS link_10, c0_.id AS id_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13 FROM campagne c0_ WHERE c0_.status = 1 AND c0_.start_at <= '2026-02-18 19:51:57' AND c0_.end_at >= '2026-02-18 19:51:57' ORDER BY c0_.id ASC LIMIT 4;