GET https://dev.theremotetribe.co/

Query Metrics

6 Database Queries
6 Different statements
8.75 ms Query time
1 Invalid entities
28 Managed entities

Queries

Group similar statements

# Time Info
1 1.24 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.is_validated = ?
Parameters:
[
  1
]
2 1.70 ms
SELECT p0_.firstname AS firstname_0, p0_.title AS title_1, p0_.profile_picture AS profile_picture_2, p0_.city AS city_3 FROM profile p0_ WHERE p0_.is_validated = ? AND p0_.profile_picture <> ? AND p0_.search_status <> ? AND p0_.featured = ? ORDER BY p0_.created_at DESC LIMIT 4
Parameters:
[
  1
  "https://www.theremotetribe.co/uploads/profilePictures/default.png"
  3
  1
]
3 1.62 ms
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.description AS description_2, j0_.summary AS summary_3, j0_.created_at AS created_at_4, j0_.updated_at AS updated_at_5, j0_.is_validated AS is_validated_6, j0_.slug AS slug_7, j0_.publisher_id AS publisher_id_8 FROM job j0_ WHERE j0_.is_validated = ? ORDER BY j0_.created_at DESC LIMIT 7
Parameters:
[
  1
]
4 1.76 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:
[
  "2026-05-27 04:36:55"
]
5 1.12 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 5
Parameters:
[
  "2026-05-27 04:36:55"
]
6 1.31 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 DESC LIMIT 5
Parameters:
[
  "2026-05-27 04:36:55"
]

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\Tribe 8
App\Entity\User 8
App\Entity\Job 7
App\Entity\Event 5

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\Profile No errors.
App\Entity\Job 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.
App\Entity\JobApplicant 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.