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

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 ('810', '807', '811', '785', '781', '677', '814', '819', '786', '824', '731', '803', '802', '812', '780', '816', '744', '734', '750', '751', '783', '772', '764', '754', '761', '688', '792', '756', '729', '89', '629', '738', '709', '741', '818', '813', '535', '806', '815', '745', '755', '733', '805', '641', '310', '800', '103', '791', '711', '767', '771', '801', '763', '809', '749', '702', '748', '794', '779', '808', '768', '569', '799', '759', '742', '770', '564', '730', '753', '740', '776', '793', '757', '774', '784', '665', '992', '993', '995', '996', '999', '1001', '1002', '1003', '1004', '831', '38', '164', '259', '323', '367', '1033', '739', '769', '804', '735', '778', '760', '777', '775', '916', '962', '893', '882', '935', '948', '909', '880', '913', '964', '860', '1043', '1041', '1034', '1016', '854', '960', '1026', '943', '1005', '787', '1036', '972', '1007', '1039', '902', '737', '1014', '884', '940', '788', '820', '954', '555', '645', '752', '953', '642', '892', '955', '593', '939', '360', '1012', '1038', '973', '961', '1011', '1022', '894', '710', '895', '674', '941', '911', '1044', '886', '1040', '952', '1024', '907', '646', '1021', '765', '1017', '1010', '356', '1006', '914', '901', '990', '1000', '1020', '394', '885', '736', '49', '579', '896', '912', '967', '183', '888', '898', '969', '998', '991', '827', '876', '988', '987', '989', '970', '849', '856', '848', '844', '968', '858', '850', '841', '833', '980', '686', '971', '878', '847', '846', '879', '845', '306', '944', '994', '864', '842', '1008', '891', '997', '917', '945', '509', '965', '1015', '70', '797', '1009', '966', '732', '1019', '938', '887', '568', '903', '150', '946', '1035', '918', '897', '951', '900', '1042', '823', '958', '956', '899', '957', '362', '915', '959', '158', '1027', '384', '796', '817', '890', '766', '822', '881', '758', '1032', '1037', '728', '908', '936', '782', '942', '821', '1013', '762', '798', '889', '949', '773');

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
  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
  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
  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
  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-19 00:28:09' AND c0_.end_at >= '2026-02-19 00:28:09' ORDER BY c0_.id ASC LIMIT 4;

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

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

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

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