Query Metrics
56
Database Queries
15
Different statements
13.10 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.92 ms (0.00%) |
23 |
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.56 ms (0.00%) |
16 |
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
]
|
1.18 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:
[] |
0.89 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.59 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.52 ms (0.00%) |
5 |
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.slug AS slug_7 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.51 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.50 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.43 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.slug AS slug_7 FROM article_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"sport"
]
|
0.41 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
]
|
0.38 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.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 = ? AND t0.category_id = ? ORDER BY t0.position ASC, t0.id DESC
Parameters:
[ 1 1 2 ] |
0.37 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.admin_link = ? LIMIT 1
Parameters:
[
"admin_page_blog"
]
|
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.33 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.slug AS slug_7 FROM article_category t0 WHERE t0.isActive = ? AND t0.stage = ?
Parameters:
[ 1 1 ] |
0.15 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
]
|
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\ArticleCategory | No errors. |
App\Entity\Article | No errors. |
App\Entity\User | No errors. |