GET https://dev.theremotetribe.co/tribe/tribu-rennes-8

Query Metrics

24 Database Queries
8 Different statements
19.11 ms Query time
1 Invalid entities
49 Managed entities

Grouped Statements

Show all queries

Time Count Info
10.33 ms
(54.08%)
13
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:
[
  71
]
2.21 ms
(11.55%)
3
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:
[
  26
]
1.99 ms
(10.41%)
3
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:
[
  26
]
1.26 ms
(6.58%)
1
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 < CURRENT_TIMESTAMP ORDER BY e0_.date DESC LIMIT 4
Parameters:
[
  8
]
1.19 ms
(6.23%)
1
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 >= CURRENT_TIMESTAMP ORDER BY e0_.date ASC LIMIT 4
Parameters:
[
  8
]
0.81 ms
(4.23%)
1
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:
[
  "8"
]
0.67 ms
(3.49%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tribe_id AS tribe_id_3, t0.cohost_id AS cohost_id_4 FROM tribe_cohost t0 WHERE t0.tribe_id = ?
Parameters:
[
  8
]
0.66 ms
(3.43%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.tribe_id AS tribe_id_4, t0.follower_id AS follower_id_5 FROM tribe_follower t0 WHERE t0.tribe_id = ?
Parameters:
[
  8
]

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\User 17
App\Entity\TribeFollower 16
App\Entity\Profile 12
App\Entity\Event 3
App\Entity\Tribe 1

Entities Mapping

Class Mapping errors
App\Entity\Tribe No errors.
App\Entity\User No errors.
App\Entity\Event No errors.
App\Entity\TribeFollower No errors.
App\Entity\TribeCohost 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\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.