Symfony Profiler

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  analytics a0_
WHERE
  a0_.page = ?
  AND a0_.ip_address = ?
  AND a0_.visited_at >= ?

SELECT COUNT(a0_.id) AS sclr_0 FROM analytics a0_ WHERE a0_.page = 'activity_detail' AND a0_.ip_address = '216.73.216.111' AND a0_.visited_at >= '2025-12-23 00:00:00';

SELECT
  t0.id AS id_1,
  t0.activity_name AS activity_name_2,
  t0.activity_price AS activity_price_3,
  t0.activity_description AS activity_description_4,
  t0.activity_program AS activity_program_5,
  t0.video_link AS video_link_6,
  t0.image AS image_7,
  t0.updated_at AS updated_at_8,
  t0.seo_title AS seo_title_9,
  t0.meta_description AS meta_description_10,
  t0.keywords AS keywords_11,
  t0.important_notes AS important_notes_12,
  t0.banner_image AS banner_image_13,
  t0.min_adults AS min_adults_14,
  t0.max_adults AS max_adults_15,
  t0.min_kids AS min_kids_16,
  t0.max_kids AS max_kids_17,
  t0.max_total_participants AS max_total_participants_18,
  t0.max_reservations AS max_reservations_19
FROM
  activities t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.activity_name AS activity_name_2, t0.activity_price AS activity_price_3, t0.activity_description AS activity_description_4, t0.activity_program AS activity_program_5, t0.video_link AS video_link_6, t0.image AS image_7, t0.updated_at AS updated_at_8, t0.seo_title AS seo_title_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.important_notes AS important_notes_12, t0.banner_image AS banner_image_13, t0.min_adults AS min_adults_14, t0.max_adults AS max_adults_15, t0.min_kids AS min_kids_16, t0.max_kids AS max_kids_17, t0.max_total_participants AS max_total_participants_18, t0.max_reservations AS max_reservations_19 FROM activities t0 WHERE t0.id = 3;

SELECT
  a0_.id AS id_0,
  a0_.activity_name AS activity_name_1,
  a0_.date AS date_2,
  a0_.max_participants AS max_participants_3,
  a0_.max_reservations AS max_reservations_4,
  a0_.min_adults AS min_adults_5,
  a0_.min_kids AS min_kids_6,
  a0_.is_blocked AS is_blocked_7,
  a0_.notes AS notes_8,
  a0_.created_at AS created_at_9,
  a0_.updated_at AS updated_at_10,
  a0_.created_by AS created_by_11
FROM
  activity_capacity a0_
WHERE
  a0_.activity_name = ?
  AND a0_.date = ?

SELECT a0_.id AS id_0, a0_.activity_name AS activity_name_1, a0_.date AS date_2, a0_.max_participants AS max_participants_3, a0_.max_reservations AS max_reservations_4, a0_.min_adults AS min_adults_5, a0_.min_kids AS min_kids_6, a0_.is_blocked AS is_blocked_7, a0_.notes AS notes_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.created_by AS created_by_11 FROM activity_capacity a0_ WHERE a0_.activity_name = 'Sortie bateau à Haouaria (journée crique)' AND a0_.date = '2025-12-23';

SELECT
  a0_.id AS id_0,
  a0_.activity_name AS activity_name_1,
  a0_.blocked_date AS blocked_date_2,
  a0_.reason AS reason_3,
  a0_.created_at AS created_at_4,
  a0_.created_by AS created_by_5,
  a0_.is_active AS is_active_6
FROM
  activity_blocked_date a0_
WHERE
  a0_.activity_name = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.blocked_date ASC

SELECT a0_.id AS id_0, a0_.activity_name AS activity_name_1, a0_.blocked_date AS blocked_date_2, a0_.reason AS reason_3, a0_.created_at AS created_at_4, a0_.created_by AS created_by_5, a0_.is_active AS is_active_6 FROM activity_blocked_date a0_ WHERE a0_.activity_name = 'Sortie bateau à Haouaria (journée crique)' AND a0_.is_active = 1 ORDER BY a0_.blocked_date ASC;

INSERT INTO analytics (
  page, activity_name, ip_address, user_agent,
  referer, visited_at, session_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO analytics (page, activity_name, ip_address, user_agent, referer, visited_at, session_id) VALUES ('activity_detail', 'Sortie bateau à Haouaria (journée crique)', '216.73.216.111', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', NULL, '2025-12-23 08:58:50', '694a59cacf');

SELECT
  a0_.date AS date_0
FROM
  activity_capacity a0_
WHERE
  a0_.activity_name = ?
  AND a0_.is_blocked = ?
  AND a0_.date >= ?

SELECT a0_.date AS date_0 FROM activity_capacity a0_ WHERE a0_.activity_name = 'Sortie bateau à Haouaria (journée crique)' AND a0_.is_blocked = 1 AND a0_.date >= '2025-12-23 00:00:00';

SELECT
  t0.id AS id_1,
  t0.activity_name AS activity_name_2,
  t0.activity_price AS activity_price_3,
  t0.activity_description AS activity_description_4,
  t0.activity_program AS activity_program_5,
  t0.video_link AS video_link_6,
  t0.image AS image_7,
  t0.updated_at AS updated_at_8,
  t0.seo_title AS seo_title_9,
  t0.meta_description AS meta_description_10,
  t0.keywords AS keywords_11,
  t0.important_notes AS important_notes_12,
  t0.banner_image AS banner_image_13,
  t0.min_adults AS min_adults_14,
  t0.max_adults AS max_adults_15,
  t0.min_kids AS min_kids_16,
  t0.max_kids AS max_kids_17,
  t0.max_total_participants AS max_total_participants_18,
  t0.max_reservations AS max_reservations_19
FROM
  activities t0
WHERE
  t0.activity_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.activity_name AS activity_name_2, t0.activity_price AS activity_price_3, t0.activity_description AS activity_description_4, t0.activity_program AS activity_program_5, t0.video_link AS video_link_6, t0.image AS image_7, t0.updated_at AS updated_at_8, t0.seo_title AS seo_title_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.important_notes AS important_notes_12, t0.banner_image AS banner_image_13, t0.min_adults AS min_adults_14, t0.max_adults AS max_adults_15, t0.min_kids AS min_kids_16, t0.max_kids AS max_kids_17, t0.max_total_participants AS max_total_participants_18, t0.max_reservations AS max_reservations_19 FROM activities t0 WHERE t0.activity_name = 'Sortie bateau à Haouaria (journée crique)' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  settings t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM settings t0 WHERE t0.setting_key = 'main_partner_logo' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.activity_name AS activity_name_1,
  a0_.date AS date_2,
  a0_.max_participants AS max_participants_3,
  a0_.max_reservations AS max_reservations_4,
  a0_.min_adults AS min_adults_5,
  a0_.min_kids AS min_kids_6,
  a0_.is_blocked AS is_blocked_7,
  a0_.notes AS notes_8,
  a0_.created_at AS created_at_9,
  a0_.updated_at AS updated_at_10,
  a0_.created_by AS created_by_11
FROM
  activity_capacity a0_
WHERE
  a0_.activity_name = ?
  AND a0_.is_blocked = ?
  AND a0_.date >= ?
ORDER BY
  a0_.date ASC

SELECT a0_.id AS id_0, a0_.activity_name AS activity_name_1, a0_.date AS date_2, a0_.max_participants AS max_participants_3, a0_.max_reservations AS max_reservations_4, a0_.min_adults AS min_adults_5, a0_.min_kids AS min_kids_6, a0_.is_blocked AS is_blocked_7, a0_.notes AS notes_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.created_by AS created_by_11 FROM activity_capacity a0_ WHERE a0_.activity_name = 'Sortie bateau à Haouaria (journée crique)' AND a0_.is_blocked = 1 AND a0_.date >= '2025-12-23 00:00:00' ORDER BY a0_.date ASC;

SELECT
  t0.id AS id_1,
  t0.activity_name AS activity_name_2,
  t0.activity_price AS activity_price_3,
  t0.activity_description AS activity_description_4,
  t0.activity_program AS activity_program_5,
  t0.video_link AS video_link_6,
  t0.image AS image_7,
  t0.updated_at AS updated_at_8,
  t0.seo_title AS seo_title_9,
  t0.meta_description AS meta_description_10,
  t0.keywords AS keywords_11,
  t0.important_notes AS important_notes_12,
  t0.banner_image AS banner_image_13,
  t0.min_adults AS min_adults_14,
  t0.max_adults AS max_adults_15,
  t0.min_kids AS min_kids_16,
  t0.max_kids AS max_kids_17,
  t0.max_total_participants AS max_total_participants_18,
  t0.max_reservations AS max_reservations_19
FROM
  activities t0

SELECT t0.id AS id_1, t0.activity_name AS activity_name_2, t0.activity_price AS activity_price_3, t0.activity_description AS activity_description_4, t0.activity_program AS activity_program_5, t0.video_link AS video_link_6, t0.image AS image_7, t0.updated_at AS updated_at_8, t0.seo_title AS seo_title_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.important_notes AS important_notes_12, t0.banner_image AS banner_image_13, t0.min_adults AS min_adults_14, t0.max_adults AS max_adults_15, t0.min_kids AS min_kids_16, t0.max_kids AS max_kids_17, t0.max_total_participants AS max_total_participants_18, t0.max_reservations AS max_reservations_19 FROM activities t0;

"COMMIT"

"COMMIT";

SELECT
  a0_.id AS id_0,
  a0_.activity_name AS activity_name_1,
  a0_.blocked_date AS blocked_date_2,
  a0_.reason AS reason_3,
  a0_.created_at AS created_at_4,
  a0_.created_by AS created_by_5,
  a0_.is_active AS is_active_6
FROM
  activity_blocked_date a0_
WHERE
  a0_.blocked_date >= ?
  AND a0_.is_active = ?
  AND a0_.activity_name = ?
ORDER BY
  a0_.blocked_date ASC

SELECT a0_.id AS id_0, a0_.activity_name AS activity_name_1, a0_.blocked_date AS blocked_date_2, a0_.reason AS reason_3, a0_.created_at AS created_at_4, a0_.created_by AS created_by_5, a0_.is_active AS is_active_6 FROM activity_blocked_date a0_ WHERE a0_.blocked_date >= '2025-12-23 00:00:00' AND a0_.is_active = 1 AND a0_.activity_name = 'Sortie bateau à Haouaria (journée crique)' ORDER BY a0_.blocked_date ASC;

"START TRANSACTION"

"START TRANSACTION";