Query Metrics
6
Database Queries
6
Different statements
8.75 ms
Query time
1
Invalid entities
28
Managed entities
Queries
| #▲ | 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 |
|
| 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. |