Query Metrics
16
Database Queries
12
Different statements
10.37 ms
Query time
1
Invalid entities
25
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.68 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.date AS date_3, t0.description AS description_4, t0.city AS city_5, t0.address AS address_6, t0.background_picture AS background_picture_7, t0.is_validated AS is_validated_8, t0.slug AS slug_9, t0.summary AS summary_10, t0.announcement AS announcement_11, t0.remind AS remind_12, t0.attendees_count AS attendees_count_13, t0.price AS price_14, t0.poster AS poster_15, t0.host_id AS host_id_16, t0.tribe_id AS tribe_id_17, t0.category_id AS category_id_18 FROM event t0 WHERE t0.id = ?
Parameters:
[
"12"
]
|
||||||||||||||||||||||||||||
| 2 | 0.68 ms |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.description AS description_3, e0_.city AS city_4, e0_.address AS address_5, e0_.background_picture AS background_picture_6, e0_.is_validated AS is_validated_7, e0_.slug AS slug_8, e0_.summary AS summary_9, e0_.announcement AS announcement_10, e0_.remind AS remind_11, e0_.attendees_count AS attendees_count_12, e0_.price AS price_13, e0_.poster AS poster_14, e0_.host_id AS host_id_15, e0_.tribe_id AS tribe_id_16, e0_.category_id AS category_id_17 FROM event e0_ WHERE e0_.id = ? AND e0_.slug = ?
Parameters:
[ 12 "afterwork-developpeurs-a-vannes-33" ]
|
||||||||||||||||||||||||||||
| 3 | 0.86 ms |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.description AS description_3, e0_.city AS city_4, e0_.address AS address_5, e0_.background_picture AS background_picture_6, e0_.is_validated AS is_validated_7, e0_.slug AS slug_8, e0_.summary AS summary_9, e0_.announcement AS announcement_10, e0_.remind AS remind_11, e0_.attendees_count AS attendees_count_12, e0_.price AS price_13, e0_.poster AS poster_14, e0_.host_id AS host_id_15, e0_.tribe_id AS tribe_id_16, e0_.category_id AS category_id_17 FROM event e0_ WHERE e0_.tribe_id = ? AND e0_.date < ? AND e0_.is_validated = 1 ORDER BY e0_.date DESC LIMIT 1
Parameters:
[ 1 "2024-12-17 18:30:00" ]
|
||||||||||||||||||||||||||||
| 4 | 0.61 ms |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.description AS description_3, e0_.city AS city_4, e0_.address AS address_5, e0_.background_picture AS background_picture_6, e0_.is_validated AS is_validated_7, e0_.slug AS slug_8, e0_.summary AS summary_9, e0_.announcement AS announcement_10, e0_.remind AS remind_11, e0_.attendees_count AS attendees_count_12, e0_.price AS price_13, e0_.poster AS poster_14, e0_.host_id AS host_id_15, e0_.tribe_id AS tribe_id_16, e0_.category_id AS category_id_17 FROM event e0_ WHERE e0_.date > ? AND e0_.is_validated = 1 ORDER BY e0_.date ASC LIMIT 1
Parameters:
[
"2024-12-17 18:30:00"
]
|
||||||||||||||||||||||||||||
| 5 | 0.86 ms |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.description AS description_3, e0_.city AS city_4, e0_.address AS address_5, e0_.background_picture AS background_picture_6, e0_.is_validated AS is_validated_7, e0_.slug AS slug_8, e0_.summary AS summary_9, e0_.announcement AS announcement_10, e0_.remind AS remind_11, e0_.attendees_count AS attendees_count_12, e0_.price AS price_13, e0_.poster AS poster_14, e0_.host_id AS host_id_15, e0_.tribe_id AS tribe_id_16, e0_.category_id AS category_id_17 FROM event e0_ WHERE e0_.tribe_id = ? AND e0_.id <> ? AND e0_.date < ? ORDER BY e0_.date DESC LIMIT 5
Parameters:
[ 1 12 "2026-05-27 07:30:02" ]
|
||||||||||||||||||||||||||||
| 6 | 0.78 ms |
SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.event_id AS event_id_3, e0_.attendee_id AS attendee_id_4 FROM event_attendee e0_ INNER JOIN user u1_ ON e0_.attendee_id = u1_.id INNER JOIN profile p2_ ON u1_.id = p2_.user_id WHERE e0_.event_id = ? ORDER BY e0_.id DESC LIMIT 4
Parameters:
[
12
]
|
||||||||||||||||||||||||||||
| 7 | 0.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.background_picture AS background_picture_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_validated AS is_validated_7, t0.city AS city_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.country AS country_11, t0.summary AS summary_12, t0.events_count AS events_count_13, t0.followers_count AS followers_count_14, t0.host_id AS host_id_15 FROM tribe t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 8 | 0.68 ms |
SELECT t0.id AS id_1, t0.time_slot AS time_slot_2, t0.speaker_name AS speaker_name_3, t0.speaker_city AS speaker_city_4, t0.speaker_title AS speaker_title_5, t0.topic AS topic_6, t0.speaker_photo AS speaker_photo_7, t0.position AS position_8, t0.event_id AS event_id_9 FROM event_track t0 WHERE t0.event_id = ? ORDER BY t0.position ASC
Parameters:
[
12
]
|
||||||||||||||||||||||||||||
| 9 | 0.37 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.event_id AS event_id_6 FROM event_video t0 WHERE t0.event_id = ? ORDER BY t0.created_at ASC
Parameters:
[
12
]
|
||||||||||||||||||||||||||||
| 10 | 0.36 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.created_at AS created_at_3, t0.event_id AS event_id_4 FROM event_photo t0 WHERE t0.event_id = ? ORDER BY t0.created_at ASC
Parameters:
[
12
]
|
||||||||||||||||||||||||||||
| 11 | 0.75 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.slug AS slug_6, t0.linkedin_id AS linkedin_id_7, t0.linkedin_picture AS linkedin_picture_8, t0.linkedin_firstname AS linkedin_firstname_9, t0.linkedin_lastname AS linkedin_lastname_10, t0.created_at AS created_at_11, t0.last_connection AS last_connection_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.city AS city_17, t13.country AS country_18, t13.profile_picture AS profile_picture_19, t13.search_status AS search_status_20, t13.linkedin AS linkedin_21, t13.website AS website_22, t13.created_at AS created_at_23, t13.updated_at AS updated_at_24, t13.deleted_at AS deleted_at_25, t13.firstname AS firstname_26, t13.lastname AS lastname_27, t13.part_time_freelancer AS part_time_freelancer_28, t13.full_time_freelancer AS full_time_freelancer_29, t13.full_time_employment AS full_time_employment_30, t13.level_junior AS level_junior_31, t13.level_mid_level AS level_mid_level_32, t13.level_senior AS level_senior_33, t13.level_staff AS level_staff_34, t13.level_clevel AS level_clevel_35, t13.tel AS tel_36, t13.is_validated AS is_validated_37, t13.featured AS featured_38, t13.user_id AS user_id_39 FROM user t0 LEFT JOIN profile t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 12 | 0.45 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.event_id AS event_id_3, t0.cohost_id AS cohost_id_4 FROM event_cohost t0 WHERE t0.event_id = ?
Parameters:
[
12
]
|
||||||||||||||||||||||||||||
| 13 | 0.62 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.slug AS slug_6, t0.linkedin_id AS linkedin_id_7, t0.linkedin_picture AS linkedin_picture_8, t0.linkedin_firstname AS linkedin_firstname_9, t0.linkedin_lastname AS linkedin_lastname_10, t0.created_at AS created_at_11, t0.last_connection AS last_connection_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.city AS city_17, t13.country AS country_18, t13.profile_picture AS profile_picture_19, t13.search_status AS search_status_20, t13.linkedin AS linkedin_21, t13.website AS website_22, t13.created_at AS created_at_23, t13.updated_at AS updated_at_24, t13.deleted_at AS deleted_at_25, t13.firstname AS firstname_26, t13.lastname AS lastname_27, t13.part_time_freelancer AS part_time_freelancer_28, t13.full_time_freelancer AS full_time_freelancer_29, t13.full_time_employment AS full_time_employment_30, t13.level_junior AS level_junior_31, t13.level_mid_level AS level_mid_level_32, t13.level_senior AS level_senior_33, t13.level_staff AS level_staff_34, t13.level_clevel AS level_clevel_35, t13.tel AS tel_36, t13.is_validated AS is_validated_37, t13.featured AS featured_38, t13.user_id AS user_id_39 FROM user t0 LEFT JOIN profile t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
63
]
|
||||||||||||||||||||||||||||
| 14 | 0.67 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.slug AS slug_6, t0.linkedin_id AS linkedin_id_7, t0.linkedin_picture AS linkedin_picture_8, t0.linkedin_firstname AS linkedin_firstname_9, t0.linkedin_lastname AS linkedin_lastname_10, t0.created_at AS created_at_11, t0.last_connection AS last_connection_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.city AS city_17, t13.country AS country_18, t13.profile_picture AS profile_picture_19, t13.search_status AS search_status_20, t13.linkedin AS linkedin_21, t13.website AS website_22, t13.created_at AS created_at_23, t13.updated_at AS updated_at_24, t13.deleted_at AS deleted_at_25, t13.firstname AS firstname_26, t13.lastname AS lastname_27, t13.part_time_freelancer AS part_time_freelancer_28, t13.full_time_freelancer AS full_time_freelancer_29, t13.full_time_employment AS full_time_employment_30, t13.level_junior AS level_junior_31, t13.level_mid_level AS level_mid_level_32, t13.level_senior AS level_senior_33, t13.level_staff AS level_staff_34, t13.level_clevel AS level_clevel_35, t13.tel AS tel_36, t13.is_validated AS is_validated_37, t13.featured AS featured_38, t13.user_id AS user_id_39 FROM user t0 LEFT JOIN profile t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
17
]
|
||||||||||||||||||||||||||||
| 15 | 0.63 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.slug AS slug_6, t0.linkedin_id AS linkedin_id_7, t0.linkedin_picture AS linkedin_picture_8, t0.linkedin_firstname AS linkedin_firstname_9, t0.linkedin_lastname AS linkedin_lastname_10, t0.created_at AS created_at_11, t0.last_connection AS last_connection_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.city AS city_17, t13.country AS country_18, t13.profile_picture AS profile_picture_19, t13.search_status AS search_status_20, t13.linkedin AS linkedin_21, t13.website AS website_22, t13.created_at AS created_at_23, t13.updated_at AS updated_at_24, t13.deleted_at AS deleted_at_25, t13.firstname AS firstname_26, t13.lastname AS lastname_27, t13.part_time_freelancer AS part_time_freelancer_28, t13.full_time_freelancer AS full_time_freelancer_29, t13.full_time_employment AS full_time_employment_30, t13.level_junior AS level_junior_31, t13.level_mid_level AS level_mid_level_32, t13.level_senior AS level_senior_33, t13.level_staff AS level_staff_34, t13.level_clevel AS level_clevel_35, t13.tel AS tel_36, t13.is_validated AS is_validated_37, t13.featured AS featured_38, t13.user_id AS user_id_39 FROM user t0 LEFT JOIN profile t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
58
]
|
||||||||||||||||||||||||||||
| 16 | 0.62 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.slug AS slug_6, t0.linkedin_id AS linkedin_id_7, t0.linkedin_picture AS linkedin_picture_8, t0.linkedin_firstname AS linkedin_firstname_9, t0.linkedin_lastname AS linkedin_lastname_10, t0.created_at AS created_at_11, t0.last_connection AS last_connection_12, t13.id AS id_14, t13.title AS title_15, t13.description AS description_16, t13.city AS city_17, t13.country AS country_18, t13.profile_picture AS profile_picture_19, t13.search_status AS search_status_20, t13.linkedin AS linkedin_21, t13.website AS website_22, t13.created_at AS created_at_23, t13.updated_at AS updated_at_24, t13.deleted_at AS deleted_at_25, t13.firstname AS firstname_26, t13.lastname AS lastname_27, t13.part_time_freelancer AS part_time_freelancer_28, t13.full_time_freelancer AS full_time_freelancer_29, t13.full_time_employment AS full_time_employment_30, t13.level_junior AS level_junior_31, t13.level_mid_level AS level_mid_level_32, t13.level_senior AS level_senior_33, t13.level_staff AS level_staff_34, t13.level_clevel AS level_clevel_35, t13.tel AS tel_36, t13.is_validated AS is_validated_37, t13.featured AS featured_38, t13.user_id AS user_id_39 FROM user t0 LEFT JOIN profile t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
9
]
|
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\Event | 8 |
| App\Entity\User | 6 |
| App\Entity\Profile | 5 |
| App\Entity\EventAttendee | 4 |
| App\Entity\Tribe | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Tribe | No errors. |
| App\Entity\EventCategory | No errors. |
| App\Entity\EventAttendee | No errors. |
| App\Entity\EventCohost | No errors. |
| App\Entity\EventTrack | No errors. |
| App\Entity\EventPhoto | No errors. |
| App\Entity\EventVideo | No errors. |
| App\Entity\Profile | No errors. |
| App\Entity\TribeFollower | No errors. |
| App\Entity\TribeCohost | No errors. |
| App\Entity\Job | No errors. |
| App\Entity\JobApplicant | No errors. |
| App\Entity\Skill |
|