Symfony Profiler

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 = ?

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 = 'valid' AND e0_.visible = 1 AND e0_.slug = 'village-des-sports-saint-riquier';

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

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 = 'valid' AND e0_.visible = 1 AND e0_.id <> 2607 ORDER BY d1_.start ASC LIMIT 10;

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 = ?

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 >= '2026-04-16 12:38:27' AND v0_.ip = '216.73.216.62' AND v0_.preview = 0 AND v0_.event_id = 2607;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO view (
  ip, created, env, preview, article_id,
  event_id, partner_id, talent_id,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO view (ip, created, env, preview, article_id, event_id, partner_id, talent_id, user_id) VALUES ('216.73.216.62', '2026-04-17 12:38:27', 'site', 0, NULL, 2607, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

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

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 = 2607 ORDER BY t0.start ASC;

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 = ?

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 = 2705;

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 = ?

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 = 9373;

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 = ?

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 = 2607;

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 = ?

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 = 2607;

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

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 = 1 AND e1_.id = 2607 GROUP BY t0_.id ORDER BY COUNT(l4_.id) DESC, COUNT(v3_.id) DESC;

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_.talent_id = ?

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 >= '2026-04-16 12:38:27' AND v0_.ip = '216.73.216.62' AND v0_.preview = 1 AND v0_.talent_id = 7;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO view (
  ip, created, env, preview, article_id,
  event_id, partner_id, talent_id,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO view (ip, created, env, preview, article_id, event_id, partner_id, talent_id, user_id) VALUES ('216.73.216.62', '2026-04-17 12:38:27', 'site', 1, NULL, NULL, NULL, 7, NULL);

"COMMIT"

"COMMIT";

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 = ?

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 = 6182;

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 = ?

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 >= '2026-04-16 12:38:27' AND v0_.ip = '216.73.216.62' AND v0_.preview = 1 AND v0_.event_id = 2636;

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 = ?

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 >= '2026-04-16 12:38:27' AND v0_.ip = '216.73.216.62' AND v0_.preview = 1 AND v0_.event_id = 2565;