Query Metrics
8
Database Queries
4
Different statements
8.24 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.86 ms (34.64%) |
1 |
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.client_id AS client_id_29, c0_.container_category_id AS container_category_id_30 FROM container c0_ WHERE c0_.is_show_public = 1 AND (c0_.is_active = 1 AND c0_.client_id = ?) ORDER BY c0_.name ASC LIMIT 6
Parameters:
[
59
]
|
2.76 ms (33.49%) |
3 |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM common_category_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 28 ] |
1.68 ms (20.43%) |
3 |
SELECT t0.id AS id_1, t0.color AS color_2, t0.text_color AS text_color_3, t0.ord AS ord_4, t0.type AS type_5, t0.image_name AS image_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.client_id AS client_id_9, t0.parent_id AS parent_id_10 FROM common_category t0 WHERE t0.id = ?
Parameters:
[
28
]
|
0.94 ms (11.44%) |
1 |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.container_group AS container_group_4, t0.storage AS storage_5, t0.bucket_key AS bucket_key_6, t0.bucket_secret AS bucket_secret_7, t0.bucket_name AS bucket_name_8, t0.bucket_region AS bucket_region_9, t0.bucket_endpoint AS bucket_endpoint_10, t0.is_active AS is_active_11, t0.configuration AS configuration_12, t0.design_configuration AS design_configuration_13, t0.description AS description_14, t0.image_name AS image_name_15, t0.navigation AS navigation_16, t0.is_live_now AS is_live_now_17, t0.video_gallery_ids AS video_gallery_ids_18, t0.user_static_fields AS user_static_fields_19, t0.logo_image_name AS logo_image_name_20, t0.is_show_public AS is_show_public_21, t0.is_main_container AS is_main_container_22, t0.is_show_public_container AS is_show_public_container_23, t0.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_24, t0.old_id AS old_id_25, t0.is_login_container AS is_login_container_26, t0.course_commission AS course_commission_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.client_id AS client_id_30, t0.container_category_id AS container_category_id_31 FROM container t0 WHERE t0.client_id = ? AND t0.is_main_container = ? LIMIT 1
Parameters:
[ 59 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\Container | No errors. |
App\Entity\Client | No errors. |
App\Entity\UserGroup | No errors. |
App\Entity\AFrameRoom | No errors. |
App\Entity\Language | No errors. |
App\Entity\Background | No errors. |
App\Entity\CommonCategory | No errors. |
App\Entity\CommonCategoryTranslation | No errors. |
App\Entity\SpecialTitle | No errors. |
App\Entity\User | No errors. |