GET https://edec.espacedjago.com/

Response
200 OK
IP
149.57.180.50
Profiled on
Token
6a0199

Query Metrics

4 Database Queries
4 Different statements
3.34 ms Query time
0 Invalid entities
13 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.02 ms 
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.kind AS kind_4, p0_.external_url AS external_url_5, p0_.duration_seconds AS duration_seconds_6, p0_.episode_number AS episode_number_7, p0_.status AS status_8, p0_.published_at AS published_at_9, p0_.play_count AS play_count_10, p0_.allow_download AS allow_download_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.deleted_at AS deleted_at_14, p1_.id AS id_15, p1_.name AS name_16, p1_.slug AS slug_17, p1_.description AS description_18, p1_.author AS author_19, p1_.is_active AS is_active_20, m2_.id AS id_21, m2_.original_name AS original_name_22, m2_.file_name AS file_name_23, m2_.mime_type AS mime_type_24, m2_.size AS size_25, m2_.width AS width_26, m2_.height AS height_27, m2_.duration_seconds AS duration_seconds_28, m2_.alt AS alt_29, m2_.created_at AS created_at_30, m2_.deleted_at AS deleted_at_31, p0_.series_id AS series_id_32, p0_.media_file_id AS media_file_id_33, p0_.cover_image_id AS cover_image_id_34, p1_.cover_image_id AS cover_image_id_35, m2_.uploaded_by_id AS uploaded_by_id_36 FROM podcast p0_ LEFT JOIN podcast_series p1_ ON p0_.series_id = p1_.id LEFT JOIN media m2_ ON p0_.cover_image_id = m2_.id AND (m2_.deleted_at IS NULL) WHERE (p0_.status IN (?, ?) AND p0_.published_at IS NOT NULL AND p0_.published_at <= ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.published_at DESC LIMIT 4
Parameters: 
[
  "PUBLISHED"
  "SCHEDULED"
  "2026-08-07 04:24:58"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.85 ms 
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.excerpt AS excerpt_3, a0_.content AS content_4, a0_.status AS status_5, a0_.published_at AS published_at_6, a0_.view_count AS view_count_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.color AS color_16, c1_.position AS position_17, m2_.id AS id_18, m2_.original_name AS original_name_19, m2_.file_name AS file_name_20, m2_.mime_type AS mime_type_21, m2_.size AS size_22, m2_.width AS width_23, m2_.height AS height_24, m2_.duration_seconds AS duration_seconds_25, m2_.alt AS alt_26, m2_.created_at AS created_at_27, m2_.deleted_at AS deleted_at_28, a0_.cover_image_id AS cover_image_id_29, a0_.category_id AS category_id_30, a0_.author_id AS author_id_31, m2_.uploaded_by_id AS uploaded_by_id_32 FROM article a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id LEFT JOIN media m2_ ON a0_.cover_image_id = m2_.id AND (m2_.deleted_at IS NULL) WHERE (a0_.status IN (?, ?) AND a0_.published_at IS NOT NULL AND a0_.published_at <= ?) AND (a0_.deleted_at IS NULL) ORDER BY a0_.published_at DESC LIMIT 3
Parameters: 
[
  "PUBLISHED"
  "SCHEDULED"
  "2026-08-07 04:24:58"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.84 ms 
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.starts_at AS starts_at_4, e0_.ends_at AS ends_at_5, e0_.venue AS venue_6, e0_.address AS address_7, e0_.price AS price_8, e0_.external_link AS external_link_9, e0_.status AS status_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.deleted_at AS deleted_at_13, m1_.id AS id_14, m1_.original_name AS original_name_15, m1_.file_name AS file_name_16, m1_.mime_type AS mime_type_17, m1_.size AS size_18, m1_.width AS width_19, m1_.height AS height_20, m1_.duration_seconds AS duration_seconds_21, m1_.alt AS alt_22, m1_.created_at AS created_at_23, m1_.deleted_at AS deleted_at_24, e0_.poster_id AS poster_id_25, m1_.uploaded_by_id AS uploaded_by_id_26 FROM event e0_ LEFT JOIN media m1_ ON e0_.poster_id = m1_.id AND (m1_.deleted_at IS NULL) WHERE (e0_.status = ? AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?) AND (e0_.deleted_at IS NULL) ORDER BY e0_.starts_at ASC LIMIT 3
Parameters: 
[
  "PUBLISHED"
  "2026-08-07 04:24:58"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.63 ms 
SELECT p0_.id AS id_0, p0_.day_of_week AS day_of_week_1, p0_.start_time AS start_time_2, p0_.end_time AS end_time_3, p0_.title AS title_4, p0_.host AS host_5, p0_.description AS description_6, p0_.has_rerun AS has_rerun_7, p0_.is_active AS is_active_8, p1_.id AS id_9, p1_.name AS name_10, p1_.slug AS slug_11, p1_.description AS description_12, p1_.author AS author_13, p1_.is_active AS is_active_14, p0_.series_id AS series_id_15, p1_.cover_image_id AS cover_image_id_16 FROM program p0_ LEFT JOIN podcast_series p1_ ON p0_.series_id = p1_.id WHERE p0_.is_active = 1 ORDER BY p0_.day_of_week ASC, p0_.start_time ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\Program 4
App\Entity\Article 3
App\Entity\Category 3
App\Entity\User 1
App\Entity\Event 1
App\Entity\PodcastSeries 1

Entities Mapping

Class Mapping errors
App\Entity\Podcast No errors.
App\Entity\PodcastSeries No errors.
App\Entity\Media No errors.
App\Entity\User No errors.
App\Entity\Article No errors.
App\Entity\Category No errors.
App\Entity\Event No errors.
App\Entity\Program No errors.