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

Query Metrics

10 Database Queries
7 Different statements
11.85 ms Query time
0 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 3.18 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 1.92 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.73 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 5
Parameters:
[
  "visioconference-en-direct"
]
4 0.49 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"
  73
  74
  63
  62
  54
]
5 1.84 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:
[
  46
]
6 0.39 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
]
7 0.28 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:
[
  57
]
8 1.29 ms
SELECT t0.id AS id_1, t0.link AS link_2, t0.network_id AS network_id_3 FROM social_node t0
Parameters:
[]
9 1.41 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
]
10 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\Event 5
App\Entity\Format 4
App\Entity\Workshop 3
App\Entity\SocialNode 2
App\Entity\SocialNetwork 2

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.