Symfony Profiler

SELECT
  u0_.id AS id_0,
  c1_.name AS name_1,
  c1_.image AS image_2,
  c1_.starting_date AS starting_date_3,
  c1_.longtitude AS longtitude_4,
  c1_.latitude AS latitude_5,
  u2_.inscription_date AS inscription_date_6
FROM
  company c1_
  INNER JOIN userrv u0_ ON c1_.id = u0_.id
  INNER JOIN (
    userrv u2_
    LEFT JOIN person p3_ ON u2_.id = p3_.id
    LEFT JOIN company c4_ ON u2_.id = c4_.id
    LEFT JOIN town t5_ ON u2_.id = t5_.id
  ) ON (u2_.id = u0_.id)
WHERE
  u2_.inscription_date >= ?
  AND u2_.role = ?
GROUP BY
  u0_.id
ORDER BY
  u2_.inscription_date DESC

SELECT u0_.id AS id_0, c1_.name AS name_1, c1_.image AS image_2, c1_.starting_date AS starting_date_3, c1_.longtitude AS longtitude_4, c1_.latitude AS latitude_5, u2_.inscription_date AS inscription_date_6 FROM company c1_ INNER JOIN userrv u0_ ON c1_.id = u0_.id INNER JOIN (userrv u2_ LEFT JOIN person p3_ ON u2_.id = p3_.id LEFT JOIN company c4_ ON u2_.id = c4_.id LEFT JOIN town t5_ ON u2_.id = t5_.id) ON (u2_.id = u0_.id) WHERE u2_.inscription_date >= '2025-09-14 00:00:00' AND u2_.role = 'ROLE_COMPANY' GROUP BY u0_.id ORDER BY u2_.inscription_date DESC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price AS price_2,
  p0_.currency AS currency_3,
  p0_.creation_date AS creation_date_4,
  p0_.image AS image_5,
  u1_.id AS id_6,
  c2_.name AS name_7,
  c2_.latitude AS latitude_8,
  c2_.longtitude AS longtitude_9,
  CASE WHEN p0_.discr IN ('marchandise') THEN
    'marchandise'
  WHEN p0_.discr IN ('service') THEN
    'service'
  ELSE
    'product'
  END AS sclr_10
FROM
  product p0_
  LEFT JOIN service s3_ ON p0_.id = s3_.id
  LEFT JOIN marchandise m4_ ON p0_.id = m4_.id
  LEFT JOIN company c2_ ON p0_.company_id = c2_.id
  LEFT JOIN userrv u1_ ON c2_.id = u1_.id
WHERE
  p0_.creation_date >= ?
ORDER BY
  p0_.creation_date DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.currency AS currency_3, p0_.creation_date AS creation_date_4, p0_.image AS image_5, u1_.id AS id_6, c2_.name AS name_7, c2_.latitude AS latitude_8, c2_.longtitude AS longtitude_9, CASE WHEN p0_.discr IN ('marchandise') THEN 'marchandise' WHEN p0_.discr IN ('service') THEN 'service' ELSE 'product' END AS sclr_10 FROM product p0_ LEFT JOIN service s3_ ON p0_.id = s3_.id LEFT JOIN marchandise m4_ ON p0_.id = m4_.id LEFT JOIN company c2_ ON p0_.company_id = c2_.id LEFT JOIN userrv u1_ ON c2_.id = u1_.id WHERE p0_.creation_date >= '2025-09-14 00:00:00' ORDER BY p0_.creation_date DESC LIMIT 5;