Query Metrics
51
Database Queries
13
Different statements
16.82 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.29 ms (0.00%) |
20 |
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" ] |
2.87 ms (0.00%) |
18 |
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
]
|
2.20 ms (0.00%) |
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.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.01 ms (0.00%) |
1 |
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:
[] |
0.98 ms (0.00%) |
1 |
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 ] |
0.87 ms (0.00%) |
3 |
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 = ? AND t0.stage = ? LIMIT 1
Parameters:
[ "admin_page_about_us" 1 ] |
0.78 ms (0.00%) |
1 |
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.story_date AS story_date_6, t0.description AS description_7, t0.image AS image_8, t0.position AS position_9 FROM story t0 WHERE t0.isActive = ? AND t0.stage = ? ORDER BY t0.position ASC
Parameters:
[ 1 1 ] |
0.76 ms (0.00%) |
1 |
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 ] |
0.67 ms (0.00%) |
1 |
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.phone AS phone_7, t0.email AS email_8, t0.image AS image_9, t0.rank AS rank_10, t0.position_id AS position_id_11, t0.department_id AS department_id_12 FROM team t0 WHERE t0.isActive = ? AND t0.stage = ? ORDER BY t0.rank ASC
Parameters:
[ 1 1 ] |
0.44 ms (0.00%) |
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.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
]
|
0.42 ms (0.00%) |
1 |
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 ] |
0.35 ms (0.00%) |
1 |
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
]
|
0.18 ms (0.00%) |
1 |
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
]
|
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\Story | No errors. |
App\Entity\Team | No errors. |