Symfony Profiler

SELECT
  r0_.id AS id_0,
  u1_.email AS email_1,
  p2_.ean AS ean_2,
  r0_.record_time AS record_time_3,
  s3_.name AS name_4,
  s3_.city AS city_5,
  s3_.postcode AS postcode_6,
  r0_.price AS price_7,
  p4_.publicurl AS publicurl_8,
  p2_.name AS name_9,
  b5_.name AS name_10
FROM
  record r0_
  INNER JOIN shop s3_ ON r0_.shop_id = s3_.id
  INNER JOIN product p2_ ON r0_.product_id = p2_.id
  INNER JOIN photo p4_ ON r0_.id = p4_.record_id
  INNER JOIN `user` u1_ ON r0_.user_id = u1_.id
  INNER JOIN brand b5_ ON p2_.brand_id = b5_.id
WHERE
  p2_.project_id = ?
  AND r0_.record_time >= ?
  AND r0_.record_time <= ?
  AND r0_.user_id = ?
  AND p4_.type = 1

SELECT r0_.id AS id_0, u1_.email AS email_1, p2_.ean AS ean_2, r0_.record_time AS record_time_3, s3_.name AS name_4, s3_.city AS city_5, s3_.postcode AS postcode_6, r0_.price AS price_7, p4_.publicurl AS publicurl_8, p2_.name AS name_9, b5_.name AS name_10 FROM record r0_ INNER JOIN shop s3_ ON r0_.shop_id = s3_.id INNER JOIN product p2_ ON r0_.product_id = p2_.id INNER JOIN photo p4_ ON r0_.id = p4_.record_id INNER JOIN `user` u1_ ON r0_.user_id = u1_.id INNER JOIN brand b5_ ON p2_.brand_id = b5_.id WHERE p2_.project_id = 5 AND r0_.record_time >= '2025-06-13 00:00:00' AND r0_.record_time <= '2025-06-13 23:59:59' AND r0_.user_id = 88 AND p4_.type = 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  record r1_
  INNER JOIN shop s0_ ON r1_.shop_id = s0_.id
  INNER JOIN product p2_ ON r1_.product_id = p2_.id
  INNER JOIN photo p3_ ON r1_.id = p3_.record_id
  INNER JOIN `user` u4_ ON r1_.user_id = u4_.id
  INNER JOIN brand b5_ ON p2_.brand_id = b5_.id
WHERE
  p2_.project_id = ?
  AND r1_.record_time >= ?
  AND r1_.record_time <= ?
  AND r1_.user_id = ?
  AND p3_.type = 1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM record r1_ INNER JOIN shop s0_ ON r1_.shop_id = s0_.id INNER JOIN product p2_ ON r1_.product_id = p2_.id INNER JOIN photo p3_ ON r1_.id = p3_.record_id INNER JOIN `user` u4_ ON r1_.user_id = u4_.id INNER JOIN brand b5_ ON p2_.brand_id = b5_.id WHERE p2_.project_id = 5 AND r1_.record_time >= '2025-06-13 00:00:00' AND r1_.record_time <= '2025-06-13 23:59:59' AND r1_.user_id = 88 AND p3_.type = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.lang AS lang_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lang AS lang_5, t0.nom AS nom_6, t0.prenom AS prenom_7 FROM `user` t0 WHERE t0.email = '[email protected]' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.catalog_allowed AS catalog_allowed_4,
  t0.last_updated AS last_updated_5,
  t0.last_update_alert AS last_update_alert_6,
  t0.competitors AS competitors_7,
  t0.is_active AS is_active_8
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.catalog_allowed AS catalog_allowed_4, t0.last_updated AS last_updated_5, t0.last_update_alert AS last_update_alert_6, t0.competitors AS competitors_7, t0.is_active AS is_active_8 FROM project t0 WHERE t0.id = 5;