GET https://staging.atelierdelaspirale.be/agenda/visioconference-en-direct?page=3

Query Metrics

8 Database Queries
7 Different statements
5.94 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 1.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.slug AS slug_4, t0.updated_at AS updated_at_5 FROM format t0
Parameters:
[]
2 0.93 ms
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = ?
Parameters:
[
  "visioconference-en-direct"
]
3 0.75 ms
SELECT DISTINCT e0_.id AS id_0, e0_.start_at AS start_at_1 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = ? ORDER BY e0_.start_at ASC LIMIT 5 OFFSET 10
Parameters:
[
  "visioconference-en-direct"
]
4 0.56 ms
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.cover_image AS cover_image_6, e0_.start_at AS start_at_7, e0_.schedule AS schedule_8, e0_.active AS active_9, e0_.soldout AS soldout_10, e0_.format_id AS format_id_11, e0_.workshop_id AS workshop_id_12 FROM event e0_ LEFT JOIN format f1_ ON e0_.format_id = f1_.id WHERE f1_.slug = ? AND e0_.id IN (?) ORDER BY e0_.start_at ASC
Parameters:
[
  "visioconference-en-direct"
  66
]
5 1.07 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.position AS position_8 FROM workshop t0 WHERE t0.id = ?
Parameters:
[
  56
]
6 0.42 ms
SELECT t0.id AS id_1, t0.link AS link_2, t0.network_id AS network_id_3 FROM social_node t0
Parameters:
[]
7 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icone_file AS icone_file_3 FROM social_network t0 WHERE t0.id = ?
Parameters:
[
  20
]
8 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icone_file AS icone_file_3 FROM social_network t0 WHERE t0.id = ?
Parameters:
[
  21
]

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\Format 4
App\Entity\SocialNode 2
App\Entity\SocialNetwork 2
App\Entity\Event 1
App\Entity\Workshop 1

Entities Mapping

Class Mapping errors
App\Entity\Format No errors.
App\Entity\Event No errors.
App\Entity\Workshop No errors.
App\Entity\Article No errors.
App\Entity\SocialNode No errors.
App\Entity\SocialNetwork No errors.