Query Metrics
66
Database Queries
20
Different statements
79.34 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.75 ms |
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.first_color AS first_color_11, t0.second_color AS second_color_12, t0.seo_keyword AS seo_keyword_13, t0.message_email AS message_email_14, t0.message_password AS message_password_15, t0.message_smtp AS message_smtp_16, t0.message_port AS message_port_17 FROM site_admin t0 LIMIT 1
Parameters:
[] |
2 | 1.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.country_code AS country_code_6, t0.slug AS slug_7, t0.short_name AS short_name_8, t0.has_boarding_school_boy AS has_boarding_school_boy_9, t0.has_boarding_school_girl AS has_boarding_school_girl_10, t0.has_shool_cafetaria AS has_shool_cafetaria_11, t0.has_transport_service AS has_transport_service_12, t0.creation_year AS creation_year_13, t0.nb_student AS nb_student_14, t0.nb_staff AS nb_staff_15, t0.slogan AS slogan_16, t0.general_information AS general_information_17, t0.neighbordhood AS neighbordhood_18, t0.coor_long AS coor_long_19, t0.coord_lat AS coord_lat_20, t0.email AS email_21, t0.facebook_link AS facebook_link_22, t0.twitter_link AS twitter_link_23, t0.instagram_link AS instagram_link_24, t0.google_map_link AS google_map_link_25, t0.youtube_link AS youtube_link_26, t0.location_plan AS location_plan_27, t0.location_description AS location_description_28, t0.display_educati_news AS display_educati_news_29, t0.image_banner AS image_banner_30, t0.school_type_id AS school_type_id_31, t0.school_religion_id AS school_religion_id_32, t0.town_id AS town_id_33, t0.school_language_id AS school_language_id_34, t0.school_fee_id AS school_fee_id_35 FROM school t0 LIMIT 1
Parameters:
[] |
3 | 4.22 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.number AS number_6, t0.is_whatsapp AS is_whatsapp_7, t0.is_telegram AS is_telegram_8 FROM phone t0 WHERE t0.isActive = ? AND t0.stage = ?
Parameters:
[ 1 1 ] |
4 | 0.54 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.day AS day_6, t0.start AS start_7, t0.end AS end_8, t0.position AS position_9 FROM open_day t0 WHERE t0.isActive = ? AND t0.stage = ?
Parameters:
[ 1 1 ] |
5 | 0.32 ms |
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.first_color AS first_color_11, t0.second_color AS second_color_12, t0.seo_keyword AS seo_keyword_13, t0.message_email AS message_email_14, t0.message_password AS message_password_15, t0.message_smtp AS message_smtp_16, t0.message_port AS message_port_17 FROM site_admin t0 WHERE t0.id = ?
Parameters:
[
1
]
|
6 | 0.38 ms |
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 = ?
Parameters:
[ "1" "second" "App\Entity\SiteAdmin" ] |
7 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.country_code AS country_code_6, t0.slug AS slug_7, t0.short_name AS short_name_8, t0.has_boarding_school_boy AS has_boarding_school_boy_9, t0.has_boarding_school_girl AS has_boarding_school_girl_10, t0.has_shool_cafetaria AS has_shool_cafetaria_11, t0.has_transport_service AS has_transport_service_12, t0.creation_year AS creation_year_13, t0.nb_student AS nb_student_14, t0.nb_staff AS nb_staff_15, t0.slogan AS slogan_16, t0.general_information AS general_information_17, t0.neighbordhood AS neighbordhood_18, t0.coor_long AS coor_long_19, t0.coord_lat AS coord_lat_20, t0.email AS email_21, t0.facebook_link AS facebook_link_22, t0.twitter_link AS twitter_link_23, t0.instagram_link AS instagram_link_24, t0.google_map_link AS google_map_link_25, t0.youtube_link AS youtube_link_26, t0.location_plan AS location_plan_27, t0.location_description AS location_description_28, t0.display_educati_news AS display_educati_news_29, t0.image_banner AS image_banner_30, t0.school_type_id AS school_type_id_31, t0.school_religion_id AS school_religion_id_32, t0.town_id AS town_id_33, t0.school_language_id AS school_language_id_34, t0.school_fee_id AS school_fee_id_35 FROM school t0 WHERE t0.id = ?
Parameters:
[
1
]
|
8 | 1.53 ms |
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 = ?
Parameters:
[ "1" "second" "App\Entity\School" ] |
9 | 3.34 ms |
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 = ?
Parameters:
[
1
]
|
10 | 4.32 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.isActive = ? AND t0.is_frontend = ? AND t0.stage = ? ORDER BY t0.isActive DESC, t0.position ASC
Parameters:
[ 1 1 1 ] |
11 | 3.63 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
2
]
|
12 | 3.11 ms |
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 = ?
Parameters:
[ "2" "second" "App\Entity\Page" ] |
13 | 1.87 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
3
]
|
14 | 1.82 ms |
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 = ?
Parameters:
[ "3" "second" "App\Entity\Page" ] |
15 | 3.52 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
4
]
|
16 | 0.87 ms |
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 = ?
Parameters:
[ "4" "second" "App\Entity\Page" ] |
17 | 0.16 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
5
]
|
18 | 0.15 ms |
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 = ?
Parameters:
[ "5" "second" "App\Entity\Page" ] |
19 | 2.91 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
8
]
|
20 | 2.11 ms |
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 = ?
Parameters:
[ "8" "second" "App\Entity\Page" ] |
21 | 2.06 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
7
]
|
22 | 0.78 ms |
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 = ?
Parameters:
[ "7" "second" "App\Entity\Page" ] |
23 | 2.91 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
6
]
|
24 | 0.30 ms |
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 = ?
Parameters:
[ "6" "second" "App\Entity\Page" ] |
25 | 3.47 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
13
]
|
26 | 7.41 ms |
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 = ?
Parameters:
[ "13" "second" "App\Entity\Page" ] |
27 | 1.02 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
10
]
|
28 | 1.42 ms |
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 = ?
Parameters:
[ "10" "second" "App\Entity\Page" ] |
29 | 1.44 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
11
]
|
30 | 0.23 ms |
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 = ?
Parameters:
[ "11" "second" "App\Entity\Page" ] |
31 | 0.86 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
12
]
|
32 | 0.21 ms |
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 = ?
Parameters:
[ "12" "second" "App\Entity\Page" ] |
33 | 3.14 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
14
]
|
34 | 1.30 ms |
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 = ?
Parameters:
[ "14" "second" "App\Entity\Page" ] |
35 | 2.11 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
9
]
|
36 | 0.54 ms |
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 = ?
Parameters:
[ "9" "second" "App\Entity\Page" ] |
37 | 1.45 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
15
]
|
38 | 0.59 ms |
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 = ?
Parameters:
[ "15" "second" "App\Entity\Page" ] |
39 | 0.26 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
16
]
|
40 | 0.16 ms |
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 = ?
Parameters:
[ "16" "second" "App\Entity\Page" ] |
41 | 0.44 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.admin_link = ? LIMIT 1
Parameters:
[
"admin_page_home"
]
|
42 | 0.19 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
3
]
|
43 | 0.18 ms |
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 = ?
Parameters:
[ "3" "second" "App\Entity\Page" ] |
44 | 0.43 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.image AS image_6, t0.description AS description_7, t0.description_position AS description_position_8, t0.position AS position_9, t0.image_mini AS image_mini_10, t0.page_id AS page_id_11 FROM gallery_item t0 WHERE t0.isActive = ? AND t0.stage = ? ORDER BY t0.position ASC
Parameters:
[ 1 1 ] |
45 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.country_code AS country_code_6, t0.slug AS slug_7, t0.short_name AS short_name_8, t0.has_boarding_school_boy AS has_boarding_school_boy_9, t0.has_boarding_school_girl AS has_boarding_school_girl_10, t0.has_shool_cafetaria AS has_shool_cafetaria_11, t0.has_transport_service AS has_transport_service_12, t0.creation_year AS creation_year_13, t0.nb_student AS nb_student_14, t0.nb_staff AS nb_staff_15, t0.slogan AS slogan_16, t0.general_information AS general_information_17, t0.neighbordhood AS neighbordhood_18, t0.coor_long AS coor_long_19, t0.coord_lat AS coord_lat_20, t0.email AS email_21, t0.facebook_link AS facebook_link_22, t0.twitter_link AS twitter_link_23, t0.instagram_link AS instagram_link_24, t0.google_map_link AS google_map_link_25, t0.youtube_link AS youtube_link_26, t0.location_plan AS location_plan_27, t0.location_description AS location_description_28, t0.display_educati_news AS display_educati_news_29, t0.image_banner AS image_banner_30, t0.school_type_id AS school_type_id_31, t0.school_religion_id AS school_religion_id_32, t0.town_id AS town_id_33, t0.school_language_id AS school_language_id_34, t0.school_fee_id AS school_fee_id_35 FROM school t0 LIMIT 1
Parameters:
[] |
46 | 0.20 ms |
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 = ?
Parameters:
[
3
]
|
47 | 0.16 ms |
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 = ?
Parameters:
[
3
]
|
48 | 0.16 ms |
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 = ?
Parameters:
[ "3" "second" "App\Entity\SchoolType" ] |
49 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_religion t0 WHERE t0.id = ?
Parameters:
[
1
]
|
50 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_religion t0 WHERE t0.id = ?
Parameters:
[
1
]
|
51 | 0.18 ms |
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 = ?
Parameters:
[ "1" "second" "App\Entity\SchoolReligion" ] |
52 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_language t0 WHERE t0.id = ?
Parameters:
[
2
]
|
53 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM school_language t0 WHERE t0.id = ?
Parameters:
[
2
]
|
54 | 0.16 ms |
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 = ?
Parameters:
[ "2" "second" "App\Entity\SchoolLanguage" ] |
55 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.country_code AS country_code_6, t0.slug AS slug_7, t0.short_name AS short_name_8, t0.has_boarding_school_boy AS has_boarding_school_boy_9, t0.has_boarding_school_girl AS has_boarding_school_girl_10, t0.has_shool_cafetaria AS has_shool_cafetaria_11, t0.has_transport_service AS has_transport_service_12, t0.creation_year AS creation_year_13, t0.nb_student AS nb_student_14, t0.nb_staff AS nb_staff_15, t0.slogan AS slogan_16, t0.general_information AS general_information_17, t0.neighbordhood AS neighbordhood_18, t0.coor_long AS coor_long_19, t0.coord_lat AS coord_lat_20, t0.email AS email_21, t0.facebook_link AS facebook_link_22, t0.twitter_link AS twitter_link_23, t0.instagram_link AS instagram_link_24, t0.google_map_link AS google_map_link_25, t0.youtube_link AS youtube_link_26, t0.location_plan AS location_plan_27, t0.location_description AS location_description_28, t0.display_educati_news AS display_educati_news_29, t0.image_banner AS image_banner_30, t0.school_type_id AS school_type_id_31, t0.school_religion_id AS school_religion_id_32, t0.town_id AS town_id_33, t0.school_language_id AS school_language_id_34, t0.school_fee_id AS school_fee_id_35 FROM school t0 WHERE t0.id = ?
Parameters:
[
1
]
|
56 | 0.19 ms |
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 = ?
Parameters:
[ "1" "second" "App\Entity\School" ] |
57 | 0.41 ms |
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 = ?
Parameters:
[
1
]
|
58 | 1.47 ms |
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 = ?
Parameters:
[
4
]
|
59 | 0.47 ms |
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 = ?
Parameters:
[ "4" "second" "App\Entity\SchoolCycle" ] |
60 | 0.15 ms |
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 = ?
Parameters:
[
1
]
|
61 | 0.43 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.admin_link = ? LIMIT 1
Parameters:
[
"admin_page_blog"
]
|
62 | 0.39 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.title AS title_6, t0.content AS content_7, t0.nb_view AS nb_view_8, t0.slug AS slug_9, t0.image_cover AS image_cover_10, t0.nb_comment AS nb_comment_11, t0.position AS position_12, t0.image_cover_mini AS image_cover_mini_13, t0.category_id AS category_id_14, t0.user_id AS user_id_15 FROM article t0 WHERE t0.isActive = ? AND t0.stage = ? ORDER BY t0.position ASC LIMIT 10
Parameters:
[ 1 1 ] |
63 | 0.41 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.name AS name_6, t0.type AS type_7, t0.model AS model_8, t0.rich_text AS rich_text_9, t0.background_image AS background_image_10, t0.item_name AS item_name_11, t0.slug AS slug_12, t0.position AS position_13, t0.admin_link AS admin_link_14, t0.is_frontend AS is_frontend_15, t0.rich_text_old AS rich_text_old_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
11
]
|
64 | 0.18 ms |
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 = ?
Parameters:
[ "11" "second" "App\Entity\Page" ] |
65 | 0.30 ms |
SELECT t0.isActive AS isActive_1, t0.stage AS stage_2, t0.date AS date_3, t0.update_at AS update_at_4, t0.id AS id_5, t0.content AS content_6, t0.expired_at AS expired_at_7, t0.start_at AS start_at_8 FROM notification t0 WHERE t0.isActive = ? AND t0.stage = ? ORDER BY t0.date DESC
Parameters:
[ 1 1 ] |
66 | 0.47 ms |
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 = ?
Parameters:
[
4
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\SiteAdmin | No errors. |
App\Entity\School | No errors. |
App\Entity\SchoolType | No errors. |
App\Entity\SchoolReligion | No errors. |
App\Entity\Town | No errors. |
App\Entity\SchoolLanguage | No errors. |
App\Entity\SchoolFee | No errors. |
App\Entity\SchoolCycle | No errors. |
App\Entity\SchoolClub | No errors. |
App\Entity\SchoolPosition | No errors. |
App\Entity\SchoolDepartment | No errors. |
App\Entity\SchoolInfrastructure | No errors. |
App\Entity\SchoolAdmissionCondition | No errors. |
App\Entity\BaseEntity | No errors. |
App\Entity\Phone | No errors. |
App\Entity\OpenDay | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
Gedmo\Translatable\Entity\Translation | No errors. |
App\Entity\CountryState | No errors. |
App\Entity\Page | No errors. |
App\Entity\GalleryItem | No errors. |
App\Entity\Article | No errors. |
App\Entity\ArticleCategory | No errors. |
App\Entity\User | No errors. |
App\Entity\Notification | No errors. |