GET https://sushrutanursingcollege.wisne.host/_fragment?_path=_format%3Dhtml%26_locale%3Dsw%26_controller%3DApp%255CController%255CDynamicComponentController%253A%2…

Response
200 OK
IP
216.73.216.222
Profiled on
Token
ca9eaf

Query Metrics

18 Database Queries
8 Different statements
29.42 ms Query time
0 Invalid entities
47 Managed entities

Queries

Group similar statements

#▲ Time Info
1 4.60 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.content AS content_4, t0.language AS language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.group_name AS group_name_8, t0.primary_thumbnail AS primary_thumbnail_9, t0.primary_image AS primary_image_10, t0.tags AS tags_11, t0.keywords AS keywords_12, t0.meta_description AS meta_description_13, t0.robot_tags AS robot_tags_14, t0.title_format AS title_format_15, t0.page_type AS page_type_16, t0.page_type_data AS page_type_data_17, t0.other_seo_tags AS other_seo_tags_18, t0.open_graph_tags AS open_graph_tags_19, t0.pinned AS pinned_20, t0.ranking AS ranking_21, t0.subgroup_name AS subgroup_name_22, t0.primary_thumbnail_media_file_id AS primary_thumbnail_media_file_id_23, t0.primary_image_media_file_id AS primary_image_media_file_id_24 FROM page_content t0 WHERE t0.group_name = ? ORDER BY t0.ranking ASC
Parameters: 
[
  "products"
]
View formatted query    View runnable query    Explain query
2 1.09 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.testimonial AS testimonial_3, t0.image AS image_4, t0.about AS about_5, t0.position AS position_6, t0.rating AS rating_7, t0.list_ranking AS list_ranking_8 FROM testimonial t0 ORDER BY t0.list_ranking ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 1.19 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.content AS content_4, t0.language AS language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.group_name AS group_name_8, t0.primary_thumbnail AS primary_thumbnail_9, t0.primary_image AS primary_image_10, t0.tags AS tags_11, t0.keywords AS keywords_12, t0.meta_description AS meta_description_13, t0.robot_tags AS robot_tags_14, t0.title_format AS title_format_15, t0.page_type AS page_type_16, t0.page_type_data AS page_type_data_17, t0.other_seo_tags AS other_seo_tags_18, t0.open_graph_tags AS open_graph_tags_19, t0.pinned AS pinned_20, t0.ranking AS ranking_21, t0.subgroup_name AS subgroup_name_22, t0.primary_thumbnail_media_file_id AS primary_thumbnail_media_file_id_23, t0.primary_image_media_file_id AS primary_image_media_file_id_24 FROM page_content t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "homepage"
]
View formatted query    View runnable query    Explain query
4 1.09 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.language AS language_4 FROM custom_content_fields t0 WHERE t0.language = ?
Parameters: 
[
  "en"
]
View formatted query    View runnable query    Explain query
5 1.06 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.value AS value_4 FROM setting t0 WHERE t0.type = ?
Parameters: 
[
  "siteSettings"
]
View formatted query    View runnable query    Explain query
6 0.99 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  105
]
View formatted query    View runnable query    Explain query
7 1.05 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.value AS value_4 FROM setting t0 WHERE t0.type = ?
Parameters: 
[
  "logos_menus"
]
View formatted query    View runnable query    Explain query
8 1.61 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.content AS content_4, t0.language AS language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.group_name AS group_name_8, t0.primary_thumbnail AS primary_thumbnail_9, t0.primary_image AS primary_image_10, t0.tags AS tags_11, t0.keywords AS keywords_12, t0.meta_description AS meta_description_13, t0.robot_tags AS robot_tags_14, t0.title_format AS title_format_15, t0.page_type AS page_type_16, t0.page_type_data AS page_type_data_17, t0.other_seo_tags AS other_seo_tags_18, t0.open_graph_tags AS open_graph_tags_19, t0.pinned AS pinned_20, t0.ranking AS ranking_21, t0.subgroup_name AS subgroup_name_22, t0.primary_thumbnail_media_file_id AS primary_thumbnail_media_file_id_23, t0.primary_image_media_file_id AS primary_image_media_file_id_24 FROM page_content t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "homepage"
]
View formatted query    View runnable query    Explain query
9 2.16 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.content AS content_4, t0.language AS language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.group_name AS group_name_8, t0.primary_thumbnail AS primary_thumbnail_9, t0.primary_image AS primary_image_10, t0.tags AS tags_11, t0.keywords AS keywords_12, t0.meta_description AS meta_description_13, t0.robot_tags AS robot_tags_14, t0.title_format AS title_format_15, t0.page_type AS page_type_16, t0.page_type_data AS page_type_data_17, t0.other_seo_tags AS other_seo_tags_18, t0.open_graph_tags AS open_graph_tags_19, t0.pinned AS pinned_20, t0.ranking AS ranking_21, t0.subgroup_name AS subgroup_name_22, t0.primary_thumbnail_media_file_id AS primary_thumbnail_media_file_id_23, t0.primary_image_media_file_id AS primary_image_media_file_id_24 FROM page_content t0 WHERE t0.id = ?
Parameters: 
[
  "__current__"
]
View formatted query    View runnable query    Explain query
10 1.70 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  77
]
View formatted query    View runnable query    Explain query
11 2.41 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
12 1.01 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  80
]
View formatted query    View runnable query    Explain query
13 0.98 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  53
]
View formatted query    View runnable query    Explain query
14 1.84 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  54
]
View formatted query    View runnable query    Explain query
15 1.21 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  119
]
View formatted query    View runnable query    Explain query
16 0.95 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  124
]
View formatted query    View runnable query    Explain query
17 2.35 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query
18 2.13 ms 
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.title AS title_2, a0_.position AS position_3, a0_.description AS description_4, a0_.type AS type_5, a0_.subtype AS subtype_6, a0_.image_path AS image_path_7, a0_.link AS link_8, a0_.display_rank AS display_rank_9, a0_.storage AS storage_10, a0_.meta_data AS meta_data_11, a0_.video_code AS video_code_12 FROM ads a0_ WHERE a0_.position = ? ORDER BY a0_.display_rank ASC
Parameters: 
[
  "Market"
]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MediaFile 17
App\Entity\CustomContentFields 10
App\Entity\PageContent 9
App\Entity\Setting 7
App\Entity\Testimonial 3
App\Entity\Ads 1

Entities Mapping

Class Mapping errors
App\Entity\PageContent No errors.
App\Entity\MediaFile No errors.
App\Entity\PageDownload No errors.
App\Entity\PhotoAlbum No errors.
App\Entity\Testimonial No errors.
App\Entity\CustomContentFields No errors.
App\Entity\Setting No errors.
App\Entity\Photo No errors.
App\Entity\YoutubeVideo No errors.
App\Entity\Ads No errors.