Symfony Profiler

SELECT
  p0_.date AS date_0,
  p0_.email AS email_1,
  p0_.phone AS phone_2,
  p0_.site AS site_3,
  p0_.updated AS updated_4,
  p0_.center AS center_5,
  p0_.close AS close_6,
  p0_.created AS created_7,
  p0_.description AS description_8,
  p0_.id AS id_9,
  p0_.name AS name_10,
  p0_.slug AS slug_11,
  p0_.title AS title_12,
  p0_.visible AS visible_13,
  p0_.address_id AS address_id_14,
  p0_.pdf_id AS pdf_id_15,
  p0_.picture_id AS picture_id_16
FROM
  partner p0_
  LEFT JOIN address a1_ ON p0_.address_id = a1_.id
  LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id
  LEFT JOIN category c2_ ON c2_.id = p3_.category_id
  LEFT JOIN view v4_ ON p0_.id = v4_.partner_id
  LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id
WHERE
  p0_.visible = ?
  AND p0_.slug = ?

SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id WHERE p0_.visible = 1 AND p0_.slug = 'quiz-room-amiens';

SELECT
  p0_.date AS date_0,
  p0_.email AS email_1,
  p0_.phone AS phone_2,
  p0_.site AS site_3,
  p0_.updated AS updated_4,
  p0_.center AS center_5,
  p0_.close AS close_6,
  p0_.created AS created_7,
  p0_.description AS description_8,
  p0_.id AS id_9,
  p0_.name AS name_10,
  p0_.slug AS slug_11,
  p0_.title AS title_12,
  p0_.visible AS visible_13,
  p0_.address_id AS address_id_14,
  p0_.pdf_id AS pdf_id_15,
  p0_.picture_id AS picture_id_16
FROM
  partner p0_
  LEFT JOIN address a1_ ON p0_.address_id = a1_.id
  LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id
  LEFT JOIN category c2_ ON c2_.id = p3_.category_id
  LEFT JOIN view v4_ ON p0_.id = v4_.partner_id
  LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id
  INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id
WHERE
  p0_.visible = ?
  AND p0_.id <> ?
  AND s6_.day = ?
  AND s6_.open <= ?
  AND ? <= s6_.close
ORDER BY
  RAND() ASC
LIMIT
  10

SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id WHERE p0_.visible = 1 AND p0_.id <> 271 AND s6_.day = 'Friday' AND s6_.open <= '2026-04-17 13:04:49' AND '2026-04-17 13:04:49' <= s6_.close ORDER BY RAND() 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_.partner_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 13:04:51' AND v0_.ip = '216.73.216.62' AND v0_.preview = 0 AND v0_.partner_id = 271;

"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 13:04:51', 'site', 0, NULL, NULL, 271, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.break AS break_1,
  t0.resume AS resume_2,
  t0.updated AS updated_3,
  t0.close AS close_4,
  t0.created AS created_5,
  t0.day AS day_6,
  t0.id AS id_7,
  t0.open AS open_8,
  t0.partner_id AS partner_id_9
FROM
  schedule t0
WHERE
  t0.partner_id = ?

SELECT t0.break AS break_1, t0.resume AS resume_2, t0.updated AS updated_3, t0.close AS close_4, t0.created AS created_5, t0.day AS day_6, t0.id AS id_7, t0.open AS open_8, t0.partner_id AS partner_id_9 FROM schedule t0 WHERE t0.partner_id = 271;

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

SELECT
  t0.updated AS updated_1,
  t0.created AS created_2,
  t0.entities AS entities_3,
  t0.id AS id_4,
  t0.major AS major_5,
  t0.slug AS slug_6,
  t0.title AS title_7
FROM
  category t0
  INNER JOIN partner_category ON t0.id = partner_category.category_id
WHERE
  partner_category.partner_id = ?

SELECT t0.updated AS updated_1, t0.created AS created_2, t0.entities AS entities_3, t0.id AS id_4, t0.major AS major_5, t0.slug AS slug_6, t0.title AS title_7 FROM category t0 INNER JOIN partner_category ON t0.id = partner_category.category_id WHERE partner_category.partner_id = 271;

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

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.partner_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.partner_id = 271;

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.partner_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.partner_id = 271;

SELECT
  t0.updated AS updated_1,
  t0.created AS created_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.url AS url_5,
  t0.partner_id AS partner_id_6,
  t0.talent_id AS talent_id_7
FROM
  network t0
WHERE
  t0.partner_id = ?

SELECT t0.updated AS updated_1, t0.created AS created_2, t0.id AS id_3, t0.name AS name_4, t0.url AS url_5, t0.partner_id AS partner_id_6, t0.talent_id AS talent_id_7 FROM network t0 WHERE t0.partner_id = 271;

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.partner_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.partner_id = 271;

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_.partner_id = ?
ORDER BY
  d1_.start ASC

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_.partner_id = 271 ORDER BY d1_.start ASC;

SELECT
  e0_.updated AS updated_0,
  e0_.created AS created_1,
  e0_.id AS id_2,
  e0_.price AS price_3,
  e0_.rental AS rental_4,
  e0_.site AS site_5,
  e0_.title AS title_6,
  e0_.visible AS visible_7,
  e0_.picture_id AS picture_id_8,
  e0_.partner_id AS partner_id_9
FROM
  estate e0_
WHERE
  e0_.visible = ?
  AND e0_.partner_id = ?
ORDER BY
  e0_.id DESC

SELECT e0_.updated AS updated_0, e0_.created AS created_1, e0_.id AS id_2, e0_.price AS price_3, e0_.rental AS rental_4, e0_.site AS site_5, e0_.title AS title_6, e0_.visible AS visible_7, e0_.picture_id AS picture_id_8, e0_.partner_id AS partner_id_9 FROM estate e0_ WHERE e0_.visible = 1 AND e0_.partner_id = 271 ORDER BY e0_.id DESC;

SELECT
  r0_.end AS end_0,
  r0_.start AS start_1,
  r0_.updated AS updated_2,
  r0_.created AS created_3,
  r0_.id AS id_4,
  r0_.permanent AS permanent_5,
  r0_.title AS title_6,
  r0_.visible AS visible_7,
  r0_.partner_id AS partner_id_8
FROM
  reduction r0_
WHERE
  r0_.visible = ?
  AND r0_.partner_id = ?

SELECT r0_.end AS end_0, r0_.start AS start_1, r0_.updated AS updated_2, r0_.created AS created_3, r0_.id AS id_4, r0_.permanent AS permanent_5, r0_.title AS title_6, r0_.visible AS visible_7, r0_.partner_id AS partner_id_8 FROM reduction r0_ WHERE r0_.visible = 1 AND r0_.partner_id = 271;

SELECT
  j0_.site AS site_0,
  j0_.updated AS updated_1,
  j0_.contract AS contract_2,
  j0_.created AS created_3,
  j0_.description AS description_4,
  j0_.id AS id_5,
  j0_.title AS title_6,
  j0_.visible AS visible_7,
  j0_.partner_id AS partner_id_8
FROM
  job j0_
WHERE
  j0_.visible = ?
  AND j0_.partner_id = ?
ORDER BY
  j0_.id DESC

SELECT j0_.site AS site_0, j0_.updated AS updated_1, j0_.contract AS contract_2, j0_.created AS created_3, j0_.description AS description_4, j0_.id AS id_5, j0_.title AS title_6, j0_.visible AS visible_7, j0_.partner_id AS partner_id_8 FROM job j0_ WHERE j0_.visible = 1 AND j0_.partner_id = 271 ORDER BY j0_.id DESC;