GET https://dev.theremotetribe.co/event/afterwork-developpeurs-a-auray-13-32

Query Metrics

14 Database Queries
12 Different statements
11.52 ms Query time
1 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 0.84 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:
[
  "32"
]
2 1.04 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:
[
  32
  "afterwork-developpeurs-a-auray-13"
]
3 0.89 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:
[
  2
  "2025-05-21 18:30:00"
]
4 0.95 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:
[
  "2025-05-21 18:30:00"
]
5 0.98 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:
[
  2
  32
  "2026-05-27 07:29:22"
]
6 0.87 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:
[
  32
]
7 0.95 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:
[
  2
]
8 0.65 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:
[
  32
]
9 0.99 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:
[
  32
]
10 0.46 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:
[
  32
]
11 1.20 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:
[
  2
]
12 0.51 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:
[
  32
]
13 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:
[
  6
]
14 0.50 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 7
App\Entity\User 4
App\Entity\Profile 3
App\Entity\Tribe 2
App\Entity\EventAttendee 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
  • The field App\Entity\Skill#profile is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Profile#skills does not contain the required 'mappedBy: "profile"' attribute.
  • If association App\Entity\Skill#profile is many-to-one, then the inversed side App\Entity\Profile#skills has to be one-to-many.