Query Metrics

10 Database Queries
10 Different statements
8.78 ms Query time
0 Invalid entities
8 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.06 ms
(23.48%)
1
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"
]
1.84 ms
(20.95%)
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.id = ?
Parameters:
[
  7
]
1.38 ms
(15.74%)
1
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:
[
  "Plongée sous marine"
  1
]
1.01 ms
(11.54%)
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_.date = ?
Parameters:
[
  "Plongée sous marine"
  "2025-12-23"
]
0.60 ms
(6.86%)
1
SELECT a0_.date AS date_0 FROM activity_capacity a0_ WHERE a0_.activity_name = ? AND a0_.is_blocked = ? AND a0_.date >= ?
Parameters:
[
  "Plongée sous marine"
  1
  "2025-12-23 00:00:00"
]
0.49 ms
(5.62%)
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
Parameters:
[]
0.42 ms
(4.82%)
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 = ? LIMIT 1
Parameters:
[
  "Plongée sous marine"
]
0.42 ms
(4.77%)
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
Parameters:
[
  "main_partner_logo"
]
0.28 ms
(3.21%)
1
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
  "Plongée sous marine"
]
0.26 ms
(3.01%)
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
Parameters:
[
  "Plongée sous marine"
  1
  "2025-12-23 00:00:00"
]

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\ActivityBlockedDate 2
App\Entity\Settings 1

Entities Mapping

Class Mapping errors
App\Entity\Analytics No errors.
App\Entity\Activities No errors.
App\Entity\ActivityCapacity No errors.
App\Entity\Reservation No errors.
App\Entity\ActivityBlockedDate No errors.
App\Entity\Settings No errors.