Symfony Profiler

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.slug = ?
LIMIT
  1

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.slug = 'park-moto-morys-pathes' 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
  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 = 99;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  establishment
SET
  score = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE establishment SET score = 1185, updated_at = '2026-02-18 14:44:38' WHERE id = 99;

"COMMIT"

"COMMIT";

SELECT
  t0.address AS address_1,
  t0.address_extra AS address_extra_2,
  t0.city AS city_3,
  t0.country AS country_4,
  t0.postal_code AS postal_code_5,
  t0.address_type AS address_type_6,
  t0.id AS id_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.establishment_id AS establishment_id_10,
  t0.job_offert_id AS job_offert_id_11
FROM
  address t0
WHERE
  t0.establishment_id = ?

SELECT t0.address AS address_1, t0.address_extra AS address_extra_2, t0.city AS city_3, t0.country AS country_4, t0.postal_code AS postal_code_5, t0.address_type AS address_type_6, t0.id AS id_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.establishment_id AS establishment_id_10, t0.job_offert_id AS job_offert_id_11 FROM address t0 WHERE t0.establishment_id = 99;

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

SELECT
  t0.id AS id_1,
  t0.open_at AS open_at_2,
  t0.close_at AS close_at_3,
  t0.break_at AS break_at_4,
  t0.weekday AS weekday_5,
  t0.part_of_day AS part_of_day_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.establishment_id AS establishment_id_9
FROM
  opening_hours t0
WHERE
  t0.establishment_id = ?

SELECT t0.id AS id_1, t0.open_at AS open_at_2, t0.close_at AS close_at_3, t0.break_at AS break_at_4, t0.weekday AS weekday_5, t0.part_of_day AS part_of_day_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.establishment_id AS establishment_id_9 FROM opening_hours t0 WHERE t0.establishment_id = 99;

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

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.establishment_id AS establishment_id_3
FROM
  pricing_list t0
WHERE
  t0.establishment_id = ?

SELECT t0.id AS id_1, t0.category AS category_2, t0.establishment_id AS establishment_id_3 FROM pricing_list t0 WHERE t0.establishment_id = 99;

SELECT
  t0.name AS name_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.slug AS slug_4,
  t0.id AS id_5
FROM
  amenity t0
  INNER JOIN establishment_amenity ON t0.id = establishment_amenity.amenity_id
WHERE
  establishment_amenity.establishment_id = ?

SELECT t0.name AS name_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.slug AS slug_4, t0.id AS id_5 FROM amenity t0 INNER JOIN establishment_amenity ON t0.id = establishment_amenity.amenity_id WHERE establishment_amenity.establishment_id = 99;

SELECT
  t0.name AS name_1,
  t0.email AS email_2,
  t0.profile_photo_url AS profile_photo_url_3,
  t0.id AS id_4
FROM
  author t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.email AS email_2, t0.profile_photo_url AS profile_photo_url_3, t0.id AS id_4 FROM author t0 WHERE t0.id = 1248;

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.logos_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.logos_id = 99;