Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.welcome_message AS welcome_message_4,
  t0.default_locale AS default_locale_5,
  t0.primary_color AS primary_color_6,
  t0.secondary_color AS secondary_color_7,
  t0.logo_filename AS logo_filename_8,
  t0.cover_mode AS cover_mode_9,
  t0.cover_default AS cover_default_10,
  t0.cover_filename AS cover_filename_11,
  t0.theme AS theme_12,
  t0.color_mode AS color_mode_13,
  t0.custom_css AS custom_css_14,
  t0.contact_email AS contact_email_15,
  t0.contact_phone AS contact_phone_16,
  t0.contact_whatsapp AS contact_whatsapp_17,
  t0.qr_code_filename AS qr_code_filename_18,
  t0.is_published AS is_published_19,
  t0.view_count AS view_count_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.mode AS mode_23,
  t0.property_id AS property_id_24
FROM
  guidebook t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.welcome_message AS welcome_message_4, t0.default_locale AS default_locale_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.logo_filename AS logo_filename_8, t0.cover_mode AS cover_mode_9, t0.cover_default AS cover_default_10, t0.cover_filename AS cover_filename_11, t0.theme AS theme_12, t0.color_mode AS color_mode_13, t0.custom_css AS custom_css_14, t0.contact_email AS contact_email_15, t0.contact_phone AS contact_phone_16, t0.contact_whatsapp AS contact_whatsapp_17, t0.qr_code_filename AS qr_code_filename_18, t0.is_published AS is_published_19, t0.view_count AS view_count_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.mode AS mode_23, t0.property_id AS property_id_24 FROM guidebook t0 WHERE t0.slug = 'qr9t5w3y' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.postal_code AS postal_code_6,
  t0.country AS country_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.property_type AS property_type_10,
  t0.capacity AS capacity_11,
  t0.bedrooms AS bedrooms_12,
  t0.bathrooms AS bathrooms_13,
  t0.amenities AS amenities_14,
  t0.photos AS photos_15,
  t0.cover_photo AS cover_photo_16,
  t0.property_group AS property_group_17,
  t0.is_active AS is_active_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.owner_id AS owner_id_21
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.city AS city_5, t0.postal_code AS postal_code_6, t0.country AS country_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.property_type AS property_type_10, t0.capacity AS capacity_11, t0.bedrooms AS bedrooms_12, t0.bathrooms AS bathrooms_13, t0.amenities AS amenities_14, t0.photos AS photos_15, t0.cover_photo AS cover_photo_16, t0.property_group AS property_group_17, t0.is_active AS is_active_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.owner_id AS owner_id_21 FROM property t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.whatsapp AS whatsapp_8,
  t0.company AS company_9,
  t0.locale AS locale_10,
  t0.avatar_filename AS avatar_filename_11,
  t0.stripe_customer_id AS stripe_customer_id_12,
  t0.subscription_plan AS subscription_plan_13,
  t0.subscription_expires_at AS subscription_expires_at_14,
  t0.is_verified AS is_verified_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.whatsapp AS whatsapp_8, t0.company AS company_9, t0.locale AS locale_10, t0.avatar_filename AS avatar_filename_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.subscription_plan AS subscription_plan_13, t0.subscription_expires_at AS subscription_expires_at_14, t0.is_verified AS is_verified_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.price_monthly AS price_monthly_4,
  t0.stripe_price_id AS stripe_price_id_5,
  t0.max_guidebooks AS max_guidebooks_6,
  t0.max_modules AS max_modules_7,
  t0.max_pois AS max_pois_8,
  t0.features AS features_9,
  t0.max_checkin_photos AS max_checkin_photos_10,
  t0.max_checkout_photos AS max_checkout_photos_11,
  t0.is_popular AS is_popular_12,
  t0.is_quote AS is_quote_13,
  t0.is_active AS is_active_14,
  t0.position AS position_15,
  t0.description AS description_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  plan t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.price_monthly AS price_monthly_4, t0.stripe_price_id AS stripe_price_id_5, t0.max_guidebooks AS max_guidebooks_6, t0.max_modules AS max_modules_7, t0.max_pois AS max_pois_8, t0.features AS features_9, t0.max_checkin_photos AS max_checkin_photos_10, t0.max_checkout_photos AS max_checkout_photos_11, t0.is_popular AS is_popular_12, t0.is_quote AS is_quote_13, t0.is_active AS is_active_14, t0.position AS position_15, t0.description AS description_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM plan t0 WHERE t0.is_active = 1 ORDER BY t0.position ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO guidebook_visit (
  visited_at, ip_address, user_agent,
  referer, locale, modules_viewed,
  device_type, guidebook_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO guidebook_visit (visited_at, ip_address, user_agent, referer, locale, modules_viewed, device_type, guidebook_id) VALUES ('2026-03-16 18:12:12', '176.172.244.69', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'http://welcomium.com/reset-fixtures', 'fr_FR', NULL, 'desktop', 3);

UPDATE
  guidebook
SET
  view_count = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE guidebook SET view_count = 133, updated_at = '2026-03-16 18:12:12' WHERE id = 3;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.position AS position_4,
  t0.content AS content_5,
  t0.is_enabled AS is_enabled_6,
  t0.icon AS icon_7,
  t0.visibility AS visibility_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.guidebook_id AS guidebook_id_11
FROM
  guidebook_module t0
WHERE
  t0.guidebook_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.position AS position_4, t0.content AS content_5, t0.is_enabled AS is_enabled_6, t0.icon AS icon_7, t0.visibility AS visibility_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.guidebook_id AS guidebook_id_11 FROM guidebook_module t0 WHERE t0.guidebook_id = 3 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.guest_name AS guest_name_2,
  t0.guest_email AS guest_email_3,
  t0.message AS message_4,
  t0.rating AS rating_5,
  t0.rating_cleanliness AS rating_cleanliness_6,
  t0.rating_location AS rating_location_7,
  t0.rating_welcome AS rating_welcome_8,
  t0.rating_value AS rating_value_9,
  t0.photos AS photos_10,
  t0.is_approved AS is_approved_11,
  t0.locale AS locale_12,
  t0.created_at AS created_at_13,
  t0.guidebook_id AS guidebook_id_14
FROM
  guestbook_entry t0
WHERE
  t0.guidebook_id = ?
  AND t0.is_approved = ?
ORDER BY
  t0.created_at DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.guest_name AS guest_name_2, t0.guest_email AS guest_email_3, t0.message AS message_4, t0.rating AS rating_5, t0.rating_cleanliness AS rating_cleanliness_6, t0.rating_location AS rating_location_7, t0.rating_welcome AS rating_welcome_8, t0.rating_value AS rating_value_9, t0.photos AS photos_10, t0.is_approved AS is_approved_11, t0.locale AS locale_12, t0.created_at AS created_at_13, t0.guidebook_id AS guidebook_id_14 FROM guestbook_entry t0 WHERE t0.guidebook_id = 3 AND t0.is_approved = 1 ORDER BY t0.created_at DESC LIMIT 10;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.category AS category_3,
  p0_.latitude AS latitude_4,
  p0_.longitude AS longitude_5,
  p0_.address AS address_6,
  p0_.phone AS phone_7,
  p0_.website AS website_8,
  p0_.is_public AS is_public_9,
  p0_.share_mode AS share_mode_10,
  p0_.waypoints AS waypoints_11,
  p0_.upvote_count AS upvote_count_12,
  p0_.downvote_count AS downvote_count_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.owner_id AS owner_id_16
FROM
  point_of_interest p0_
  INNER JOIN poi_guidebook p1_ ON p0_.id = p1_.poi_id
WHERE
  p1_.guidebook_id = ?
  AND p0_.category IN (?)
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.category AS category_3, p0_.latitude AS latitude_4, p0_.longitude AS longitude_5, p0_.address AS address_6, p0_.phone AS phone_7, p0_.website AS website_8, p0_.is_public AS is_public_9, p0_.share_mode AS share_mode_10, p0_.waypoints AS waypoints_11, p0_.upvote_count AS upvote_count_12, p0_.downvote_count AS downvote_count_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.owner_id AS owner_id_16 FROM point_of_interest p0_ INNER JOIN poi_guidebook p1_ ON p0_.id = p1_.poi_id WHERE p1_.guidebook_id = 3 AND p0_.category IN ('health') ORDER BY p0_.name ASC;