GET https://staging.atelierdelaspirale.be/agenda/presentiel-a-walhain?page=2

Query Metrics

12 Database Queries
7 Different statements
10.23 ms Query time
0 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 1.63 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.56 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:
[
  "presentiel-a-walhain"
]
3 0.96 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:
[
  "presentiel-a-walhain"
]
4 0.79 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:
[
  "presentiel-a-walhain"
  69
  34
  64
  53
  57
]
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:
[
  53
]
6 0.53 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:
[
  48
]
7 0.42 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
]
8 0.38 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
]
9 0.41 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:
[
  45
]
10 1.01 ms
SELECT t0.id AS id_1, t0.link AS link_2, t0.network_id AS network_id_3 FROM social_node t0
Parameters:
[]
11 0.86 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
]
12 0.61 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\Workshop 5
App\Entity\Format 4
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.