Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.department_id AS department_id_4
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.department_id AS department_id_4 FROM city t0 WHERE t0.id = 21;

SELECT
  count(DISTINCT r0_.id) AS sclr_0
FROM
  region r0_
  INNER JOIN department d1_ ON r0_.id = d1_.region_id
  INNER JOIN city c2_ ON d1_.id = c2_.department_id
  INNER JOIN centre c3_ ON c2_.id = c3_.city_id
  AND (c3_.deleted_at IS NULL)
  AND (
    c3_.physical = true
    AND c3_.open_date < ?
  )

SELECT count(DISTINCT r0_.id) AS sclr_0 FROM region r0_ INNER JOIN department d1_ ON r0_.id = d1_.region_id INNER JOIN city c2_ ON d1_.id = c2_.department_id INNER JOIN centre c3_ ON c2_.id = c3_.city_id AND (c3_.deleted_at IS NULL) AND (c3_.physical = true AND c3_.open_date < '2026-03-11 10:32:41');

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.street AS street_2,
  c0_.street2 AS street2_3,
  c0_.phone AS phone_4,
  c0_.fax AS fax_5,
  c0_.latitude AS latitude_6,
  c0_.longitude AS longitude_7,
  c0_.physical AS physical_8,
  c0_.enabled AS enabled_9,
  c0_.deleted_at AS deleted_at_10,
  c0_.slug AS slug_11,
  c0_.windev_id AS windev_id_12,
  c0_.google_url AS google_url_13,
  c0_.description AS description_14,
  c0_.open_date AS open_date_15,
  c0_.open_time AS open_time_16,
  c0_.close_time AS close_time_17,
  c0_.constructed AS constructed_18,
  c0_.created_by AS created_by_19,
  c0_.updated_by AS updated_by_20,
  c0_.created_at AS created_at_21,
  c0_.updated_at AS updated_at_22,
  c0_.alert_message AS alert_message_23,
  c0_.alert_start_date AS alert_start_date_24,
  c0_.alert_end_date AS alert_end_date_25,
  c0_.alert_enabled AS alert_enabled_26,
  c0_.alert_type AS alert_type_27,
  c0_.city_id AS city_id_28
FROM
  centre c0_
  INNER JOIN city c1_ ON c0_.city_id = c1_.id
WHERE
  (
    c0_.physical = true
    AND c0_.enabled = true
    AND c0_.windev_id IS NOT NULL
    AND c0_.open_date IS NOT NULL
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c1_.name ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.street AS street_2, c0_.street2 AS street2_3, c0_.phone AS phone_4, c0_.fax AS fax_5, c0_.latitude AS latitude_6, c0_.longitude AS longitude_7, c0_.physical AS physical_8, c0_.enabled AS enabled_9, c0_.deleted_at AS deleted_at_10, c0_.slug AS slug_11, c0_.windev_id AS windev_id_12, c0_.google_url AS google_url_13, c0_.description AS description_14, c0_.open_date AS open_date_15, c0_.open_time AS open_time_16, c0_.close_time AS close_time_17, c0_.constructed AS constructed_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.created_at AS created_at_21, c0_.updated_at AS updated_at_22, c0_.alert_message AS alert_message_23, c0_.alert_start_date AS alert_start_date_24, c0_.alert_end_date AS alert_end_date_25, c0_.alert_enabled AS alert_enabled_26, c0_.alert_type AS alert_type_27, c0_.city_id AS city_id_28 FROM centre c0_ INNER JOIN city c1_ ON c0_.city_id = c1_.id WHERE (c0_.physical = true AND c0_.enabled = true AND c0_.windev_id IS NOT NULL AND c0_.open_date IS NOT NULL) AND (c0_.deleted_at IS NULL) ORDER BY c1_.name ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.windev_id AS windev_id_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.reset_token AS reset_token_5,
  t0.deleted_at AS deleted_at_6,
  t0.last_name AS last_name_7,
  t0.first_name AS first_name_8,
  t0.gender AS gender_9,
  t0.phone_number AS phone_number_10,
  t0.enabled AS enabled_11,
  t0.slug AS slug_12,
  t0.special AS special_13,
  t0.student AS student_14,
  t0.rpps AS rpps_15,
  t0.birth_date AS birth_date_16,
  t0.address_street AS address_street_17,
  t0.address_postal_code AS address_postal_code_18,
  t0.address_city AS address_city_19,
  t0.created_by AS created_by_20,
  t0.updated_by AS updated_by_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.photo_id AS photo_id_24
FROM
  "user" t0
WHERE
  1 = 0
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.windev_id AS windev_id_2, t0.email AS email_3, t0.password AS password_4, t0.reset_token AS reset_token_5, t0.deleted_at AS deleted_at_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.gender AS gender_9, t0.phone_number AS phone_number_10, t0.enabled AS enabled_11, t0.slug AS slug_12, t0.special AS special_13, t0.student AS student_14, t0.rpps AS rpps_15, t0.birth_date AS birth_date_16, t0.address_street AS address_street_17, t0.address_postal_code AS address_postal_code_18, t0.address_city AS address_city_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.photo_id AS photo_id_24 FROM "user" t0 WHERE 1=0 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.contract_days AS contract_days_3,
  t0.contract_part_times AS contract_part_times_4,
  t0.contract_shares_days AS contract_shares_days_5,
  t0.contract_shares_part_times AS contract_shares_part_times_6,
  t0.contract_notes AS contract_notes_7,
  t0.user_id AS user_id_8,
  t0.centre_id AS centre_id_9
FROM
  user_centre_role t0
WHERE
  t0.centre_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.contract_days AS contract_days_3, t0.contract_part_times AS contract_part_times_4, t0.contract_shares_days AS contract_shares_days_5, t0.contract_shares_part_times AS contract_shares_part_times_6, t0.contract_notes AS contract_notes_7, t0.user_id AS user_id_8, t0.centre_id AS centre_id_9 FROM user_centre_role t0 WHERE t0.centre_id IN (23, 31, 35, 25, 28, 21, 33, 7, 26, 9, 11, 1, 27, 18, 20, 13, 3, 6, 10, 15, 4, 36, 29, 19, 22, 30, 58, 34, 32, 24, 47, 17, 16, 8, 5, 12, 2);

SELECT
  t0.id AS id_1,
  t0.maintenance AS maintenance_2,
  t0.alert_message AS alert_message_3,
  t0.alert_start_date AS alert_start_date_4,
  t0.alert_end_date AS alert_end_date_5,
  t0.alert_enabled AS alert_enabled_6,
  t0.alert_type AS alert_type_7
FROM
  config t0
LIMIT
  1

SELECT t0.id AS id_1, t0.maintenance AS maintenance_2, t0.alert_message AS alert_message_3, t0.alert_start_date AS alert_start_date_4, t0.alert_end_date AS alert_end_date_5, t0.alert_enabled AS alert_enabled_6, t0.alert_type AS alert_type_7 FROM config t0 LIMIT 1;

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  department d0_
  INNER JOIN city c1_ ON d0_.id = c1_.department_id
  INNER JOIN centre c2_ ON c1_.id = c2_.city_id
  AND (c2_.deleted_at IS NULL)
  AND (
    c2_.physical = true
    AND c2_.open_date < ?
  )

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM department d0_ INNER JOIN city c1_ ON d0_.id = c1_.department_id INNER JOIN centre c2_ ON c1_.id = c2_.city_id AND (c2_.deleted_at IS NULL) AND (c2_.physical = true AND c2_.open_date < '2026-03-11 10:32:41');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.street AS street_3,
  t0.street2 AS street2_4,
  t0.phone AS phone_5,
  t0.fax AS fax_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.physical AS physical_9,
  t0.enabled AS enabled_10,
  t0.deleted_at AS deleted_at_11,
  t0.slug AS slug_12,
  t0.windev_id AS windev_id_13,
  t0.google_url AS google_url_14,
  t0.description AS description_15,
  t0.open_date AS open_date_16,
  t0.open_time AS open_time_17,
  t0.close_time AS close_time_18,
  t0.constructed AS constructed_19,
  t0.created_by AS created_by_20,
  t0.updated_by AS updated_by_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.alert_message AS alert_message_24,
  t0.alert_start_date AS alert_start_date_25,
  t0.alert_end_date AS alert_end_date_26,
  t0.alert_enabled AS alert_enabled_27,
  t0.alert_type AS alert_type_28,
  t0.city_id AS city_id_29
FROM
  centre t0
WHERE
  1 = 0
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street2 AS street2_4, t0.phone AS phone_5, t0.fax AS fax_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.physical AS physical_9, t0.enabled AS enabled_10, t0.deleted_at AS deleted_at_11, t0.slug AS slug_12, t0.windev_id AS windev_id_13, t0.google_url AS google_url_14, t0.description AS description_15, t0.open_date AS open_date_16, t0.open_time AS open_time_17, t0.close_time AS close_time_18, t0.constructed AS constructed_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.alert_message AS alert_message_24, t0.alert_start_date AS alert_start_date_25, t0.alert_end_date AS alert_end_date_26, t0.alert_enabled AS alert_enabled_27, t0.alert_type AS alert_type_28, t0.city_id AS city_id_29 FROM centre t0 WHERE 1=0 AND ((t0.deleted_at IS NULL));

SELECT
  count(u0_.id) AS sclr_0
FROM
  "user" u0_
WHERE
  (u0_.deleted_at IS NULL)

SELECT count(u0_.id) AS sclr_0 FROM "user" u0_ WHERE (u0_.deleted_at IS NULL);

SELECT
  count(c0_.id) AS sclr_0
FROM
  centre c0_
WHERE
  (
    c0_.physical = true
    AND c0_.enabled = true
    AND c0_.windev_id IS NOT NULL
    AND c0_.open_date IS NOT NULL
    AND c0_.open_date <= CURRENT_DATE
  )
  AND (c0_.deleted_at IS NULL)

SELECT count(c0_.id) AS sclr_0 FROM centre c0_ WHERE (c0_.physical = true AND c0_.enabled = true AND c0_.windev_id IS NOT NULL AND c0_.open_date IS NOT NULL AND c0_.open_date <= CURRENT_DATE) AND (c0_.deleted_at IS NULL);