Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.coat_of_arms AS coat_of_arms_4,
  c0_.latitude AS latitude_5,
  c0_.longitude AS longitude_6,
  c0_.borough_id AS borough_id_7,
  c0_.department_id AS department_id_8
FROM
  city c0_
WHERE
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(c0_.latitude)
      ) * COS(
        RADIANS(c0_.longitude) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(c0_.latitude)
      )
    )
  ) < ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.coat_of_arms AS coat_of_arms_4, c0_.latitude AS latitude_5, c0_.longitude AS longitude_6, c0_.borough_id AS borough_id_7, c0_.department_id AS department_id_8 FROM city c0_ WHERE (6371 * ACOS(COS(RADIANS('48.6616923')) * COS(RADIANS(c0_.latitude)) * COS(RADIANS(c0_.longitude) - RADIANS('6.1287873')) + SIN(RADIANS('48.6616923')) * SIN(RADIANS(c0_.latitude)))) < 5;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.slogan AS slogan_3,
  s0_.color AS color_4,
  s0_.resident AS resident_5,
  s0_.network AS network_6,
  s0_.is_created AS is_created_7,
  s0_.is_activated AS is_activated_8,
  s0_.created_at AS created_at_9,
  s0_.data AS data_10,
  s0_.legal AS legal_11,
  s0_.wallpaper AS wallpaper_12,
  s0_.statistical AS statistical_13,
  s0_.manager_id AS manager_id_14,
  s0_.main_borough_id AS main_borough_id_15
FROM
  subdomain s0_
  INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id
  INNER JOIN borough b1_ ON b1_.id = s2_.borough_id
  INNER JOIN city c3_ ON b1_.id = c3_.borough_id
  INNER JOIN event e4_ ON c3_.id = e4_.city_id
WHERE
  e4_.date_end >= ?
GROUP BY
  s0_.id
HAVING
  COUNT(e4_.id) > 0
ORDER BY
  COUNT(e4_.id) DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.slogan AS slogan_3, s0_.color AS color_4, s0_.resident AS resident_5, s0_.network AS network_6, s0_.is_created AS is_created_7, s0_.is_activated AS is_activated_8, s0_.created_at AS created_at_9, s0_.data AS data_10, s0_.legal AS legal_11, s0_.wallpaper AS wallpaper_12, s0_.statistical AS statistical_13, s0_.manager_id AS manager_id_14, s0_.main_borough_id AS main_borough_id_15 FROM subdomain s0_ INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id INNER JOIN borough b1_ ON b1_.id = s2_.borough_id INNER JOIN city c3_ ON b1_.id = c3_.borough_id INNER JOIN event e4_ ON c3_.id = e4_.city_id WHERE e4_.date_end >= '2026-08-14' GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.coat_of_arms AS coat_of_arms_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.borough_id AS borough_id_8,
  t0.department_id AS department_id_9
FROM
  city t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.coat_of_arms AS coat_of_arms_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.borough_id AS borough_id_8, t0.department_id AS department_id_9 FROM city t0 WHERE t0.slug = 'villers-les-nancy' LIMIT 1;

SELECT
  p0_.slug AS slug_0,
  p0_.title AS title_1
FROM
  place p0_
  LEFT JOIN city c1_ ON p0_.city_id = c1_.id
  LEFT JOIN borough b2_ ON c1_.borough_id = b2_.id
  LEFT JOIN subdomain_borough s4_ ON b2_.id = s4_.borough_id
  LEFT JOIN subdomain s3_ ON s3_.id = s4_.subdomain_id
WHERE
  (
    EXISTS (
      SELECT
        e5_.id
      FROM
        event e5_
      WHERE
        e5_.place_id = p0_.id
        AND e5_.is_published = 1
        AND e5_.is_validated = 1
        AND e5_.date_end >= ?
    )
  )
  AND s3_.slug = ?
ORDER BY
  p0_.title ASC
LIMIT
  300

SELECT p0_.slug AS slug_0, p0_.title AS title_1 FROM place p0_ LEFT JOIN city c1_ ON p0_.city_id = c1_.id LEFT JOIN borough b2_ ON c1_.borough_id = b2_.id LEFT JOIN subdomain_borough s4_ ON b2_.id = s4_.borough_id LEFT JOIN subdomain s3_ ON s3_.id = s4_.subdomain_id WHERE (EXISTS (SELECT e5_.id FROM event e5_ WHERE e5_.place_id = p0_.id AND e5_.is_published = 1 AND e5_.is_validated = 1 AND e5_.date_end >= '2026-08-14 00:00:00')) AND s3_.slug = 'nancy' ORDER BY p0_.title ASC LIMIT 300;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.is_created AS is_created_8,
  t0.is_activated AS is_activated_9,
  t0.created_at AS created_at_10,
  t0.data AS data_11,
  t0.legal AS legal_12,
  t0.wallpaper AS wallpaper_13,
  t0.statistical AS statistical_14,
  t0.manager_id AS manager_id_15,
  t0.main_borough_id AS main_borough_id_16
FROM
  subdomain t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.is_created AS is_created_8, t0.is_activated AS is_activated_9, t0.created_at AS created_at_10, t0.data AS data_11, t0.legal AS legal_12, t0.wallpaper AS wallpaper_13, t0.statistical AS statistical_14, t0.manager_id AS manager_id_15, t0.main_borough_id AS main_borough_id_16 FROM subdomain t0 WHERE t0.slug = 'nancy' LIMIT 1;

SELECT
  c0_.slug AS slug_0,
  c0_.name AS name_1
FROM
  city c0_
  INNER JOIN event e1_ ON c0_.id = e1_.city_id
  LEFT JOIN borough b2_ ON c0_.borough_id = b2_.id
  LEFT JOIN subdomain_borough s4_ ON b2_.id = s4_.borough_id
  LEFT JOIN subdomain s3_ ON s3_.id = s4_.subdomain_id
WHERE
  e1_.is_published = 1
  AND e1_.is_validated = 1
  AND e1_.date_end >= ?
  AND s3_.slug = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.name ASC
LIMIT
  300

SELECT c0_.slug AS slug_0, c0_.name AS name_1 FROM city c0_ INNER JOIN event e1_ ON c0_.id = e1_.city_id LEFT JOIN borough b2_ ON c0_.borough_id = b2_.id LEFT JOIN subdomain_borough s4_ ON b2_.id = s4_.borough_id LEFT JOIN subdomain s3_ ON s3_.id = s4_.subdomain_id WHERE e1_.is_published = 1 AND e1_.is_validated = 1 AND e1_.date_end >= '2026-08-14' AND s3_.slug = 'nancy' GROUP BY c0_.id ORDER BY c0_.name ASC LIMIT 300;

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  event e0_
  LEFT JOIN rubric r1_ ON e0_.rubric_id = r1_.id
  LEFT JOIN place p2_ ON e0_.place_id = p2_.id
  LEFT JOIN city c3_ ON e0_.city_id = c3_.id
  LEFT JOIN city c4_ ON p2_.city_id = c4_.id
  LEFT JOIN borough b5_ ON c3_.borough_id = b5_.id
  LEFT JOIN subdomain_borough s7_ ON b5_.id = s7_.borough_id
  LEFT JOIN subdomain s6_ ON s6_.id = s7_.subdomain_id
  LEFT JOIN borough b8_ ON c4_.borough_id = b8_.id
  LEFT JOIN subdomain_borough s10_ ON b8_.id = s10_.borough_id
  LEFT JOIN subdomain s9_ ON s9_.id = s10_.subdomain_id
WHERE
  e0_.is_published = 1
  AND e0_.is_validated = 1
  AND e0_.date_start <= ?
  AND e0_.date_end >= ?
  AND (
    (
      s6_.slug = ?
      OR s9_.slug = ?
    )
  )
  AND e0_.date_end >= ?
  AND e0_.city_id IN (?, ?, ?, ?, ?, ?, ?)
  AND e0_.date_start >= ?

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN rubric r1_ ON e0_.rubric_id = r1_.id LEFT JOIN place p2_ ON e0_.place_id = p2_.id LEFT JOIN city c3_ ON e0_.city_id = c3_.id LEFT JOIN city c4_ ON p2_.city_id = c4_.id LEFT JOIN borough b5_ ON c3_.borough_id = b5_.id LEFT JOIN subdomain_borough s7_ ON b5_.id = s7_.borough_id LEFT JOIN subdomain s6_ ON s6_.id = s7_.subdomain_id LEFT JOIN borough b8_ ON c4_.borough_id = b8_.id LEFT JOIN subdomain_borough s10_ ON b8_.id = s10_.borough_id LEFT JOIN subdomain s9_ ON s9_.id = s10_.subdomain_id WHERE e0_.is_published = 1 AND e0_.is_validated = 1 AND e0_.date_start <= '2026-09-13' AND e0_.date_end >= '2026-08-14' AND ((s6_.slug = 'nancy' OR s9_.slug = 'nancy')) AND e0_.date_end >= '2026-08-14' AND e0_.city_id IN (1846, 1858, 2000, 2038, 2123, 2271, 2302) AND e0_.date_start >= '2026-08-14';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.resident AS resident_4,
  t0.chief_town AS chief_town_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.description AS description_8,
  t0.zoom AS zoom_9,
  t0.department_id AS department_id_10,
  t11.id AS id_12,
  t11.name AS name_13,
  t11.slug AS slug_14,
  t11.slogan AS slogan_15,
  t11.color AS color_16,
  t11.resident AS resident_17,
  t11.network AS network_18,
  t11.is_created AS is_created_19,
  t11.is_activated AS is_activated_20,
  t11.created_at AS created_at_21,
  t11.data AS data_22,
  t11.legal AS legal_23,
  t11.wallpaper AS wallpaper_24,
  t11.statistical AS statistical_25,
  t11.manager_id AS manager_id_26,
  t11.main_borough_id AS main_borough_id_27
FROM
  borough t0
  LEFT JOIN subdomain t11 ON t11.main_borough_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.resident AS resident_4, t0.chief_town AS chief_town_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.description AS description_8, t0.zoom AS zoom_9, t0.department_id AS department_id_10, t11.id AS id_12, t11.name AS name_13, t11.slug AS slug_14, t11.slogan AS slogan_15, t11.color AS color_16, t11.resident AS resident_17, t11.network AS network_18, t11.is_created AS is_created_19, t11.is_activated AS is_activated_20, t11.created_at AS created_at_21, t11.data AS data_22, t11.legal AS legal_23, t11.wallpaper AS wallpaper_24, t11.statistical AS statistical_25, t11.manager_id AS manager_id_26, t11.main_borough_id AS main_borough_id_27 FROM borough t0 LEFT JOIN subdomain t11 ON t11.main_borough_id = t0.id WHERE t0.id = 185;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.is_created AS is_created_8,
  t0.is_activated AS is_activated_9,
  t0.created_at AS created_at_10,
  t0.data AS data_11,
  t0.legal AS legal_12,
  t0.wallpaper AS wallpaper_13,
  t0.statistical AS statistical_14,
  t0.manager_id AS manager_id_15,
  t0.main_borough_id AS main_borough_id_16
FROM
  subdomain t0
  INNER JOIN subdomain_borough ON t0.id = subdomain_borough.subdomain_id
WHERE
  subdomain_borough.borough_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.is_created AS is_created_8, t0.is_activated AS is_activated_9, t0.created_at AS created_at_10, t0.data AS data_11, t0.legal AS legal_12, t0.wallpaper AS wallpaper_13, t0.statistical AS statistical_14, t0.manager_id AS manager_id_15, t0.main_borough_id AS main_borough_id_16 FROM subdomain t0 INNER JOIN subdomain_borough ON t0.id = subdomain_borough.subdomain_id WHERE subdomain_borough.borough_id = 185;