GET https://www.dev.wakeupamiens.fr/evenements/oxymore-une-figure-de-style-faite-pour-le-dancefloor

Query Metrics

21 Database Queries
9 Different statements
15.01 ms Query time
1 Invalid entities
67 Managed entities

Queries

Group similar statements

# Time Info
1 0.77 ms
SELECT e0_.email AS email_0, e0_.phone AS phone_1, e0_.site AS site_2, e0_.updated AS updated_3, e0_.center AS center_4, e0_.created AS created_5, e0_.description AS description_6, e0_.id AS id_7, e0_.slug AS slug_8, e0_.status AS status_9, e0_.title AS title_10, e0_.visible AS visible_11, e0_.address_id AS address_id_12, e0_.partner_id AS partner_id_13, e0_.picture_id AS picture_id_14, e0_.user_id AS user_id_15 FROM event e0_ INNER JOIN date d1_ ON e0_.id = d1_.event_id LEFT JOIN address a2_ ON e0_.address_id = a2_.id LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id LEFT JOIN category c3_ ON c3_.id = e4_.category_id LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id WHERE e0_.status = ? AND e0_.visible = ? AND e0_.slug = ?
Parameters:
[
  "valid"
  1
  "oxymore-une-figure-de-style-faite-pour-le-dancefloor"
]
2 9.08 ms
SELECT e0_.email AS email_0, e0_.phone AS phone_1, e0_.site AS site_2, e0_.updated AS updated_3, e0_.center AS center_4, e0_.created AS created_5, e0_.description AS description_6, e0_.id AS id_7, e0_.slug AS slug_8, e0_.status AS status_9, e0_.title AS title_10, e0_.visible AS visible_11, e0_.address_id AS address_id_12, e0_.partner_id AS partner_id_13, e0_.picture_id AS picture_id_14, e0_.user_id AS user_id_15 FROM event e0_ INNER JOIN date d1_ ON e0_.id = d1_.event_id LEFT JOIN address a2_ ON e0_.address_id = a2_.id LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id LEFT JOIN category c3_ ON c3_.id = e4_.category_id LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id WHERE e0_.status = ? AND e0_.visible = ? AND e0_.id <> ? ORDER BY d1_.start ASC LIMIT 10
Parameters:
[
  "valid"
  1
  2649
]
3 0.56 ms
SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.event_id = ?
Parameters:
[
  "2026-04-16 16:18:16"
  "216.73.216.62"
  0
  2649
]
4 0.22 ms
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
Parameters:
[
  2649
]
5 0.20 ms
SELECT t0.place AS place_1, t0.updated AS updated_2, t0.city AS city_3, t0.created AS created_4, t0.id AS id_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.postal AS postal_8, t0.street AS street_9 FROM address t0 WHERE t0.id = ?
Parameters:
[
  2755
]
6 0.19 ms
SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  9647
]
7 0.17 ms
SELECT t0.ip AS ip_1, t0.created AS created_2, t0.env AS env_3, t0.id AS id_4, t0.preview AS preview_5, t0.article_id AS article_id_6, t0.event_id AS event_id_7, t0.partner_id AS partner_id_8, t0.talent_id AS talent_id_9, t0.user_id AS user_id_10 FROM view t0 WHERE t0.event_id = ?
Parameters:
[
  2649
]
8 0.18 ms
SELECT t0.created AS created_1, t0.env AS env_2, t0.id AS id_3, t0.article_id AS article_id_4, t0.event_id AS event_id_5, t0.partner_id AS partner_id_6, t0.publication_id AS publication_id_7, t0.talent_id AS talent_id_8, t0.user_id AS user_id_9 FROM `like` t0 WHERE t0.event_id = ?
Parameters:
[
  2649
]
9 0.37 ms
SELECT t0_.email AS email_0, t0_.phone AS phone_1, t0_.site AS site_2, t0_.updated AS updated_3, t0_.created AS created_4, t0_.description AS description_5, t0_.id AS id_6, t0_.name AS name_7, t0_.slug AS slug_8, t0_.visible AS visible_9, t0_.picture_id AS picture_id_10 FROM talent t0_ LEFT JOIN event_talent e2_ ON t0_.id = e2_.talent_id LEFT JOIN event e1_ ON e1_.id = e2_.event_id LEFT JOIN view v3_ ON t0_.id = v3_.talent_id LEFT JOIN `like` l4_ ON t0_.id = l4_.talent_id WHERE t0_.visible = ? AND e1_.id = ? GROUP BY t0_.id ORDER BY COUNT(l4_.id) DESC, COUNT(v3_.id) DESC
Parameters:
[
  1
  2649
]
10 0.46 ms
SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.event_id = ?
Parameters:
[
  "2026-04-16 16:18:16"
  "216.73.216.62"
  1
  2636
]
11 0.66 ms
SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.event_id = ?
Parameters:
[
  "2026-04-16 16:18:16"
  "216.73.216.62"
  1
  2565
]
12 0.22 ms
SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.event_id = ?
Parameters:
[
  "2026-04-16 16:18:16"
  "216.73.216.62"
  1
  2645
]
13 0.82 ms
SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.event_id = ?
Parameters:
[
  "2026-04-16 16:18:16"
  "216.73.216.62"
  1
  2423
]
14 0.18 ms
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
Parameters:
[
  2636
]
15 0.13 ms
SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  9586
]
16 0.15 ms
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
Parameters:
[
  2565
]
17 0.13 ms
SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  9167
]
18 0.14 ms
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
Parameters:
[
  2645
]
19 0.12 ms
SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  9631
]
20 0.14 ms
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
Parameters:
[
  2423
]
21 0.13 ms
SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?
Parameters:
[
  8657
]

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\Date 27
App\Entity\View 17
App\Entity\Event 5
App\Entity\Address 5
App\Entity\File 5
App\Entity\Partner 4
App\Entity\User 4

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\Date No errors.
App\Entity\Address No errors.
App\Entity\Category No errors.
App\Entity\Talent No errors.
App\Entity\Partner No errors.
App\Entity\File No errors.
App\Entity\User
  • The association App\Entity\User#partners refers to the owning side field App\Entity\Partner#user which does not exist.
App\Entity\Like No errors.
App\Entity\View No errors.
App\Entity\Article No errors.
App\Entity\Publication No errors.