Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.valid AS valid_1,
  c0_.name AS name_2,
  c0_.iso_code AS iso_code_3,
  c0_.phone_code AS phone_code_4,
  c0_.phone_digit AS phone_digit_5,
  c0_.id_currency AS id_currency_6
FROM
  country c0_
WHERE
  c0_.valid = 1
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.valid AS valid_1, c0_.name AS name_2, c0_.iso_code AS iso_code_3, c0_.phone_code AS phone_code_4, c0_.phone_digit AS phone_digit_5, c0_.id_currency AS id_currency_6 FROM country c0_ WHERE c0_.valid = 1 ORDER BY c0_.name ASC;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.valid AS valid_2,
  r0_.iso_code AS iso_code_3,
  r0_.phone_code AS phone_code_4,
  r0_.phone_digit AS phone_digit_5,
  r0_.id_country AS id_country_6,
  r0_.id_currency AS id_currency_7
FROM
  region r0_
WHERE
  r0_.valid = 1
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.valid AS valid_2, r0_.iso_code AS iso_code_3, r0_.phone_code AS phone_code_4, r0_.phone_digit AS phone_digit_5, r0_.id_country AS id_country_6, r0_.id_currency AS id_currency_7 FROM region r0_ WHERE r0_.valid = 1 ORDER BY r0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.valid AS valid_1,
  c0_.name AS name_2,
  c0_.iso_code AS iso_code_3,
  c0_.phone_code AS phone_code_4,
  c0_.phone_digit AS phone_digit_5,
  c0_.id_currency AS id_currency_6
FROM
  country c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.valid AS valid_1, c0_.name AS name_2, c0_.iso_code AS iso_code_3, c0_.phone_code AS phone_code_4, c0_.phone_digit AS phone_digit_5, c0_.id_currency AS id_currency_6 FROM country c0_ ORDER BY c0_.name ASC;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.valid AS valid_2,
  r0_.iso_code AS iso_code_3,
  r0_.phone_code AS phone_code_4,
  r0_.phone_digit AS phone_digit_5,
  r0_.id_country AS id_country_6,
  r0_.id_currency AS id_currency_7
FROM
  region r0_
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.valid AS valid_2, r0_.iso_code AS iso_code_3, r0_.phone_code AS phone_code_4, r0_.phone_digit AS phone_digit_5, r0_.id_country AS id_country_6, r0_.id_currency AS id_currency_7 FROM region r0_ ORDER BY r0_.name ASC;

SELECT
  r0_.id AS id_0,
  r0_.role AS role_1,
  r0_.pseudo AS pseudo_2
FROM
  role r0_
ORDER BY
  r0_.pseudo ASC

SELECT r0_.id AS id_0, r0_.role AS role_1, r0_.pseudo AS pseudo_2 FROM role r0_ ORDER BY r0_.pseudo ASC;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.valid AS valid_2,
  r0_.iso_code AS iso_code_3,
  r0_.phone_code AS phone_code_4,
  r0_.phone_digit AS phone_digit_5,
  r0_.id_country AS id_country_6,
  r0_.id_currency AS id_currency_7
FROM
  region r0_
  LEFT JOIN country c1_ ON r0_.id_country = c1_.id
WHERE
  c1_.valid = 1

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.valid AS valid_2, r0_.iso_code AS iso_code_3, r0_.phone_code AS phone_code_4, r0_.phone_digit AS phone_digit_5, r0_.id_country AS id_country_6, r0_.id_currency AS id_currency_7 FROM region r0_ LEFT JOIN country c1_ ON r0_.id_country = c1_.id WHERE c1_.valid = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.post_code AS post_code_2,
  c0_.is_capital AS is_capital_3,
  c0_.is_prefecture_capital AS is_prefecture_capital_4,
  c0_.id_region AS id_region_5,
  c0_.prefecture_id AS prefecture_id_6
FROM
  city c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.post_code AS post_code_2, c0_.is_capital AS is_capital_3, c0_.is_prefecture_capital AS is_prefecture_capital_4, c0_.id_region AS id_region_5, c0_.prefecture_id AS prefecture_id_6 FROM city c0_;

SELECT
  s0_.id AS id_0,
  s0_.created_date AS created_date_1,
  s0_.updated_date AS updated_date_2,
  s0_.client_updated_date AS client_updated_date_3,
  s0_.name AS name_4,
  s0_.type AS type_5,
  s0_.agree_rgpd AS agree_rgpd_6,
  s0_.description AS description_7,
  s0_.address_number AS address_number_8,
  s0_.address_locality AS address_locality_9,
  s0_.address_road AS address_road_10,
  s0_.phone_standard AS phone_standard_11,
  s0_.phone_other AS phone_other_12,
  s0_.email AS email_13,
  s0_.latitude AS latitude_14,
  s0_.longitude AS longitude_15,
  s0_.maps_address AS maps_address_16,
  s0_.other_activity1 AS other_activity1_17,
  s0_.other_activity2 AS other_activity2_18,
  s0_.other_activity3 AS other_activity3_19,
  s0_.other_activity4 AS other_activity4_20,
  s0_.other_activity5 AS other_activity5_21,
  s0_.other_activity6 AS other_activity6_22,
  s0_.registration AS registration_23,
  s0_.other_degree AS other_degree_24,
  s0_.location_mode AS location_mode_25,
  s0_.id_city AS id_city_26,
  s0_.id_region AS id_region_27,
  s0_.id_country AS id_country_28,
  s0_.id_image AS id_image_29,
  s0_.user_id AS user_id_30,
  s0_.id_sector_area1 AS id_sector_area1_31,
  s0_.id_sector_area2 AS id_sector_area2_32,
  s0_.id_sector_area3 AS id_sector_area3_33,
  s0_.id_sector_area4 AS id_sector_area4_34,
  s0_.id_sector_area5 AS id_sector_area5_35,
  s0_.id_sector_area6 AS id_sector_area6_36
FROM
  school s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.created_date AS created_date_1, s0_.updated_date AS updated_date_2, s0_.client_updated_date AS client_updated_date_3, s0_.name AS name_4, s0_.type AS type_5, s0_.agree_rgpd AS agree_rgpd_6, s0_.description AS description_7, s0_.address_number AS address_number_8, s0_.address_locality AS address_locality_9, s0_.address_road AS address_road_10, s0_.phone_standard AS phone_standard_11, s0_.phone_other AS phone_other_12, s0_.email AS email_13, s0_.latitude AS latitude_14, s0_.longitude AS longitude_15, s0_.maps_address AS maps_address_16, s0_.other_activity1 AS other_activity1_17, s0_.other_activity2 AS other_activity2_18, s0_.other_activity3 AS other_activity3_19, s0_.other_activity4 AS other_activity4_20, s0_.other_activity5 AS other_activity5_21, s0_.other_activity6 AS other_activity6_22, s0_.registration AS registration_23, s0_.other_degree AS other_degree_24, s0_.location_mode AS location_mode_25, s0_.id_city AS id_city_26, s0_.id_region AS id_region_27, s0_.id_country AS id_country_28, s0_.id_image AS id_image_29, s0_.user_id AS user_id_30, s0_.id_sector_area1 AS id_sector_area1_31, s0_.id_sector_area2 AS id_sector_area2_32, s0_.id_sector_area3 AS id_sector_area3_33, s0_.id_sector_area4 AS id_sector_area4_34, s0_.id_sector_area5 AS id_sector_area5_35, s0_.id_sector_area6 AS id_sector_area6_36 FROM school s0_ ORDER BY s0_.name ASC;