Symfony Profiler

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'second' AND e0_.object_class = 'App\\Entity\\SiteAdmin';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.link AS link_5,
  t0.is_educati AS is_educati_6,
  t0.is_active AS is_active_7,
  t0.country_code AS country_code_8,
  t0.is_hosted_by_educati AS is_hosted_by_educati_9,
  t0.slug AS slug_10,
  t0.short_name AS short_name_11,
  t0.has_boarding_school_boy AS has_boarding_school_boy_12,
  t0.has_boarding_school_girl AS has_boarding_school_girl_13,
  t0.has_shool_cafetaria AS has_shool_cafetaria_14,
  t0.has_transport_service AS has_transport_service_15,
  t0.creation_year AS creation_year_16,
  t0.nb_student AS nb_student_17,
  t0.nb_staff AS nb_staff_18,
  t0.slogan AS slogan_19,
  t0.color_one AS color_one_20,
  t0.color_two AS color_two_21,
  t0.general_information AS general_information_22,
  t0.neighbordhood AS neighbordhood_23,
  t0.coor_long AS coor_long_24,
  t0.coord_lat AS coord_lat_25,
  t0.image_cover AS image_cover_26,
  t0.ranking AS ranking_27,
  t0.is_generated AS is_generated_28,
  t0.phone1 AS phone1_29,
  t0.phone2 AS phone2_30,
  t0.date AS date_31,
  t0.is_displayed AS is_displayed_32,
  t0.school_type_id AS school_type_id_33,
  t34.id AS id_35,
  t34.name AS name_36,
  t34.is_active AS is_active_37,
  t34.school_id AS school_id_38,
  t0.school_religion_id AS school_religion_id_39,
  t40.id AS id_41,
  t40.name AS name_42,
  t40.is_active AS is_active_43,
  t40.school_id AS school_id_44,
  t0.educati_data_id AS educati_data_id_45,
  t0.town_id AS town_id_46,
  t0.created_by_id AS created_by_id_47,
  t0.school_language_id AS school_language_id_48,
  t0.school_fee_id AS school_fee_id_49
FROM
  school t0
  LEFT JOIN school_language t34 ON t34.school_id = t0.id
  LEFT JOIN school_religion t40 ON t40.school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.link AS link_5, t0.is_educati AS is_educati_6, t0.is_active AS is_active_7, t0.country_code AS country_code_8, t0.is_hosted_by_educati AS is_hosted_by_educati_9, t0.slug AS slug_10, t0.short_name AS short_name_11, t0.has_boarding_school_boy AS has_boarding_school_boy_12, t0.has_boarding_school_girl AS has_boarding_school_girl_13, t0.has_shool_cafetaria AS has_shool_cafetaria_14, t0.has_transport_service AS has_transport_service_15, t0.creation_year AS creation_year_16, t0.nb_student AS nb_student_17, t0.nb_staff AS nb_staff_18, t0.slogan AS slogan_19, t0.color_one AS color_one_20, t0.color_two AS color_two_21, t0.general_information AS general_information_22, t0.neighbordhood AS neighbordhood_23, t0.coor_long AS coor_long_24, t0.coord_lat AS coord_lat_25, t0.image_cover AS image_cover_26, t0.ranking AS ranking_27, t0.is_generated AS is_generated_28, t0.phone1 AS phone1_29, t0.phone2 AS phone2_30, t0.date AS date_31, t0.is_displayed AS is_displayed_32, t0.school_type_id AS school_type_id_33, t34.id AS id_35, t34.name AS name_36, t34.is_active AS is_active_37, t34.school_id AS school_id_38, t0.school_religion_id AS school_religion_id_39, t40.id AS id_41, t40.name AS name_42, t40.is_active AS is_active_43, t40.school_id AS school_id_44, t0.educati_data_id AS educati_data_id_45, t0.town_id AS town_id_46, t0.created_by_id AS created_by_id_47, t0.school_language_id AS school_language_id_48, t0.school_fee_id AS school_fee_id_49 FROM school t0 LEFT JOIN school_language t34 ON t34.school_id = t0.id LEFT JOIN school_religion t40 ON t40.school_id = t0.id WHERE t0.id = 33;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  school_cycle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_cycle t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.school_id AS school_id_4
FROM
  school_religion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.school_id AS school_id_4 FROM school_religion t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  school_cycle t0
  INNER JOIN school_school_cycle ON t0.id = school_school_cycle.school_cycle_id
WHERE
  school_school_cycle.school_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_cycle t0 INNER JOIN school_school_cycle ON t0.id = school_school_cycle.school_cycle_id WHERE school_school_cycle.school_id = 33;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.school_id AS school_id_4
FROM
  school_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.school_id AS school_id_4 FROM school_language t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  school_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_type t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.country_state_id AS country_state_id_4
FROM
  town t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.country_state_id AS country_state_id_4 FROM town t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start AS start_3,
  t0.end AS end_4,
  t0.is_active AS is_active_5
FROM
  school_fee t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.is_active AS is_active_5 FROM school_fee t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  country_state t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM country_state t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.link AS link_5,
  t0.is_educati AS is_educati_6,
  t0.is_active AS is_active_7,
  t0.country_code AS country_code_8,
  t0.is_hosted_by_educati AS is_hosted_by_educati_9,
  t0.slug AS slug_10,
  t0.short_name AS short_name_11,
  t0.has_boarding_school_boy AS has_boarding_school_boy_12,
  t0.has_boarding_school_girl AS has_boarding_school_girl_13,
  t0.has_shool_cafetaria AS has_shool_cafetaria_14,
  t0.has_transport_service AS has_transport_service_15,
  t0.creation_year AS creation_year_16,
  t0.nb_student AS nb_student_17,
  t0.nb_staff AS nb_staff_18,
  t0.slogan AS slogan_19,
  t0.color_one AS color_one_20,
  t0.color_two AS color_two_21,
  t0.general_information AS general_information_22,
  t0.neighbordhood AS neighbordhood_23,
  t0.coor_long AS coor_long_24,
  t0.coord_lat AS coord_lat_25,
  t0.image_cover AS image_cover_26,
  t0.ranking AS ranking_27,
  t0.is_generated AS is_generated_28,
  t0.phone1 AS phone1_29,
  t0.phone2 AS phone2_30,
  t0.date AS date_31,
  t0.is_displayed AS is_displayed_32,
  t0.school_type_id AS school_type_id_33,
  t34.id AS id_35,
  t34.name AS name_36,
  t34.is_active AS is_active_37,
  t34.school_id AS school_id_38,
  t0.school_religion_id AS school_religion_id_39,
  t40.id AS id_41,
  t40.name AS name_42,
  t40.is_active AS is_active_43,
  t40.school_id AS school_id_44,
  t0.educati_data_id AS educati_data_id_45,
  t0.town_id AS town_id_46,
  t0.created_by_id AS created_by_id_47,
  t0.school_language_id AS school_language_id_48,
  t0.school_fee_id AS school_fee_id_49
FROM
  school t0
  LEFT JOIN school_language t34 ON t34.school_id = t0.id
  LEFT JOIN school_religion t40 ON t40.school_id = t0.id
WHERE
  t0.is_active = ?
  AND t0.is_displayed = ?
ORDER BY
  t0.ranking ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.link AS link_5, t0.is_educati AS is_educati_6, t0.is_active AS is_active_7, t0.country_code AS country_code_8, t0.is_hosted_by_educati AS is_hosted_by_educati_9, t0.slug AS slug_10, t0.short_name AS short_name_11, t0.has_boarding_school_boy AS has_boarding_school_boy_12, t0.has_boarding_school_girl AS has_boarding_school_girl_13, t0.has_shool_cafetaria AS has_shool_cafetaria_14, t0.has_transport_service AS has_transport_service_15, t0.creation_year AS creation_year_16, t0.nb_student AS nb_student_17, t0.nb_staff AS nb_staff_18, t0.slogan AS slogan_19, t0.color_one AS color_one_20, t0.color_two AS color_two_21, t0.general_information AS general_information_22, t0.neighbordhood AS neighbordhood_23, t0.coor_long AS coor_long_24, t0.coord_lat AS coord_lat_25, t0.image_cover AS image_cover_26, t0.ranking AS ranking_27, t0.is_generated AS is_generated_28, t0.phone1 AS phone1_29, t0.phone2 AS phone2_30, t0.date AS date_31, t0.is_displayed AS is_displayed_32, t0.school_type_id AS school_type_id_33, t34.id AS id_35, t34.name AS name_36, t34.is_active AS is_active_37, t34.school_id AS school_id_38, t0.school_religion_id AS school_religion_id_39, t40.id AS id_41, t40.name AS name_42, t40.is_active AS is_active_43, t40.school_id AS school_id_44, t0.educati_data_id AS educati_data_id_45, t0.town_id AS town_id_46, t0.created_by_id AS created_by_id_47, t0.school_language_id AS school_language_id_48, t0.school_fee_id AS school_fee_id_49 FROM school t0 LEFT JOIN school_language t34 ON t34.school_id = t0.id LEFT JOIN school_religion t40 ON t40.school_id = t0.id WHERE t0.is_active = 1 AND t0.is_displayed = 1 ORDER BY t0.ranking ASC, t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.languages AS languages_3,
  t0.cgu AS cgu_4,
  t0.first_language AS first_language_5,
  t0.second_language AS second_language_6,
  t0.third_language AS third_language_7,
  t0.nb_language AS nb_language_8,
  t0.link_title AS link_title_9,
  t0.has_country_state AS has_country_state_10,
  t0.about AS about_11,
  t0.email AS email_12,
  t0.facebook_link AS facebook_link_13,
  t0.twitter_link AS twitter_link_14,
  t0.instagram_link AS instagram_link_15,
  t0.google_map_link AS google_map_link_16,
  t0.youtube_link AS youtube_link_17,
  t0.location_plan AS location_plan_18,
  t0.location_description AS location_description_19,
  t0.blog_name AS blog_name_20
FROM
  site_admin t0
LIMIT
  1

SELECT t0.id AS id_1, t0.country AS country_2, t0.languages AS languages_3, t0.cgu AS cgu_4, t0.first_language AS first_language_5, t0.second_language AS second_language_6, t0.third_language AS third_language_7, t0.nb_language AS nb_language_8, t0.link_title AS link_title_9, t0.has_country_state AS has_country_state_10, t0.about AS about_11, t0.email AS email_12, t0.facebook_link AS facebook_link_13, t0.twitter_link AS twitter_link_14, t0.instagram_link AS instagram_link_15, t0.google_map_link AS google_map_link_16, t0.youtube_link AS youtube_link_17, t0.location_plan AS location_plan_18, t0.location_description AS location_description_19, t0.blog_name AS blog_name_20 FROM site_admin t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.languages AS languages_3,
  t0.cgu AS cgu_4,
  t0.first_language AS first_language_5,
  t0.second_language AS second_language_6,
  t0.third_language AS third_language_7,
  t0.nb_language AS nb_language_8,
  t0.link_title AS link_title_9,
  t0.has_country_state AS has_country_state_10,
  t0.about AS about_11,
  t0.email AS email_12,
  t0.facebook_link AS facebook_link_13,
  t0.twitter_link AS twitter_link_14,
  t0.instagram_link AS instagram_link_15,
  t0.google_map_link AS google_map_link_16,
  t0.youtube_link AS youtube_link_17,
  t0.location_plan AS location_plan_18,
  t0.location_description AS location_description_19,
  t0.blog_name AS blog_name_20
FROM
  site_admin t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.languages AS languages_3, t0.cgu AS cgu_4, t0.first_language AS first_language_5, t0.second_language AS second_language_6, t0.third_language AS third_language_7, t0.nb_language AS nb_language_8, t0.link_title AS link_title_9, t0.has_country_state AS has_country_state_10, t0.about AS about_11, t0.email AS email_12, t0.facebook_link AS facebook_link_13, t0.twitter_link AS twitter_link_14, t0.instagram_link AS instagram_link_15, t0.google_map_link AS google_map_link_16, t0.youtube_link AS youtube_link_17, t0.location_plan AS location_plan_18, t0.location_description AS location_description_19, t0.blog_name AS blog_name_20 FROM site_admin t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  school_type t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_type t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.country_state_id AS country_state_id_4
FROM
  town t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.country_state_id AS country_state_id_4 FROM town t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  country_state t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM country_state t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  school_cycle t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_cycle t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.school_id AS school_id_4
FROM
  school_religion t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.school_id AS school_id_4 FROM school_religion t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.school_id AS school_id_4
FROM
  school_language t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.school_id AS school_id_4 FROM school_language t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start AS start_3,
  t0.end AS end_4,
  t0.is_active AS is_active_5
FROM
  school_fee t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.is_active AS is_active_5 FROM school_fee t0 WHERE t0.is_active = 1 ORDER BY t0.id ASC;