Symfony Profiler

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_
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)

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_ 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);

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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 47, 58);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM region t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM region t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM region t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM region t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM region t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.region_id AS region_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.region_id AS region_id_4 FROM department t0 WHERE t0.id = 4;