Query Metrics
8
Database Queries
8
Different statements
3.62 ms
Query time
0
Invalid entities
24
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.04 ms (28.66%) |
1 |
SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e1_.name AS name_43, e1_.slug AS slug_44, e1_.color AS color_45, e1_.position AS position_46, e1_.id AS id_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e0_.category_id AS category_id_50, e0_.organizer_id AS organizer_id_51 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND e0_.private = ? ORDER BY e0_.position ASC, e0_.starts_at ASC
Parameters:
[ "2026-11-06 18:11:42" 0 ]
|
||||||||||||||||||||||||||||||
|
0.88 ms (24.22%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.image_path AS image_path_4, t0.location AS location_5, t0.members_count AS members_count_6, t0.badge AS badge_7, t0.position AS position_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.owner_id AS owner_id_13 FROM "group" t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"club-de-lecture"
]
|
||||||||||||||||||||||||||||||
|
0.37 ms (10.25%) |
1 |
SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e1_.name AS name_43, e1_.slug AS slug_44, e1_.color AS color_45, e1_.position AS position_46, e1_.id AS id_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e0_.category_id AS category_id_50, e0_.organizer_id AS organizer_id_51 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND e0_.private = ? ORDER BY e0_.position ASC, e0_.starts_at ASC LIMIT 4
Parameters:
[ "2026-11-06 18:11:42" 0 ]
|
||||||||||||||||||||||||||||||
|
0.36 ms (9.80%) |
1 |
SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e1_.name AS name_43, e1_.slug AS slug_44, e1_.color AS color_45, e1_.position AS position_46, e1_.id AS id_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e0_.category_id AS category_id_50, e0_.organizer_id AS organizer_id_51 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND e0_.show_in_calendar = true AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= ?))) AND e0_.starts_at >= ? AND e0_.starts_at < ? ORDER BY e0_.starts_at ASC
Parameters:
[ "2026-11-06 18:11:42" "2026-11-01 00:00:00" "2026-12-01 00:00:00" ]
|
||||||||||||||||||||||||||||||
|
0.28 ms (7.87%) |
1 |
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.status AS status_7, t0.reset_code_hash AS reset_code_hash_8, t0.reset_code_expires_at AS reset_code_expires_at_9, t0.reset_code_attempts AS reset_code_attempts_10, t0.email_verification_code_hash AS email_verification_code_hash_11, t0.email_verification_expires_at AS email_verification_expires_at_12, t0.email_verification_attempts AS email_verification_attempts_13, t0.avatar_path AS avatar_path_14, t0.birth_date AS birth_date_15, t0.gender AS gender_16, t0.preferred_locale AS preferred_locale_17, t0.country AS country_18, t0.bio AS bio_19, t0.city AS city_20, t0.interests AS interests_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
"01a1a778-ceb6-e2e1-889a-503922adfd8b"
]
|
||||||||||||||||||||||||||||||
|
0.25 ms (6.88%) |
1 |
SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e0_.category_id AS category_id_43, e0_.organizer_id AS organizer_id_44 FROM event e0_ WHERE e0_.deleted_at IS NULL AND e0_.starts_at >= ? ORDER BY e0_.starts_at ASC LIMIT 1
Parameters:
[
"2026-11-06 18:11:42"
]
|
||||||||||||||||||||||||||||||
|
0.23 ms (6.27%) |
1 |
SET TIME ZONE 'Europe/Paris'
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.22 ms (6.05%) |
1 |
SELECT g0_.title AS title_0, g0_.location AS location_1, g0_.image_path AS image_path_2, g0_.photos_count AS photos_count_3, g0_.last_photo_at AS last_photo_at_4, g0_.position AS position_5, g0_.id AS id_6, g0_.created_at AS created_at_7, g0_.updated_at AS updated_at_8, g0_.group_id AS group_id_9 FROM group_album g0_ WHERE g0_.group_id = ? ORDER BY g0_.position ASC
Parameters:
[
"01a1679a-9a9e-cf86-628b-65265d6766f6"
]
|
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\Event\Entity\Event | 13 |
| App\Event\Entity\EventCategory | 9 |
| App\Event\Entity\Group | 1 |
| App\User\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Event\Entity\Group | No errors. |
| App\User\Entity\User | No errors. |
| App\Event\Entity\GroupAlbum | No errors. |
| App\Event\Entity\Event | No errors. |
| App\Event\Entity\EventCategory | No errors. |
| App\User\Entity\Address | No errors. |