GET https://test.jerbievents.com/activite/11

Query Metrics

10 Database Queries
10 Different statements
7.86 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 1.27 ms
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 = ?
Parameters:
[
  11
]
2 0.99 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM analytics a0_ WHERE a0_.page = ? AND a0_.ip_address = ? AND a0_.visited_at >= ?
Parameters:
[
  "activity_detail"
  "216.73.216.111"
  "2025-12-23 00:00:00"
]
3 0.40 ms
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
Parameters:
[
  "CAMPING EXPÉRIENCE"
]
4 1.09 ms
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 = ?
Parameters:
[
  "CAMPING EXPÉRIENCE"
  "2025-12-23"
]
5 0.70 ms
SELECT a0_.date AS date_0 FROM activity_capacity a0_ WHERE a0_.activity_name = ? AND a0_.is_blocked = ? AND a0_.date >= ?
Parameters:
[
  "CAMPING EXPÉRIENCE"
  1
  "2025-12-23 00:00:00"
]
6 1.21 ms
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
Parameters:
[
  "CAMPING EXPÉRIENCE"
  1
]
7 0.66 ms
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
Parameters:
[
  "CAMPING EXPÉRIENCE"
  1
  "2025-12-23 00:00:00"
]
8 0.54 ms
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
Parameters:
[
  "2025-12-23 00:00:00"
  1
  "CAMPING EXPÉRIENCE"
]
9 0.59 ms
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
Parameters:
[
  "main_partner_logo"
]
10 0.40 ms
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Activities 5
App\Entity\Settings 1

Entities Mapping