Query Metrics
3
Database Queries
3
Different statements
127.79 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
125.42 ms (98.14%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.notes AS notes_2, c0_.storage AS storage_3, c0_.bucket_key AS bucket_key_4, c0_.bucket_secret AS bucket_secret_5, c0_.bucket_name AS bucket_name_6, c0_.bucket_region AS bucket_region_7, c0_.bucket_endpoint AS bucket_endpoint_8, c0_.configuration AS configuration_9, c0_.domain AS domain_10, c0_.is_show_public AS is_show_public_11, c0_.is_community_sharing_enable AS is_community_sharing_enable_12, c0_.course_commission AS course_commission_13, c0_.sync_containers AS sync_containers_14, c0_.is_sync_container_changed AS is_sync_container_changed_15, c0_.created_at AS created_at_16, c0_.updated_at AS updated_at_17, c1_.id AS id_18, c1_.domain AS domain_19, c1_.name AS name_20, c1_.container_group AS container_group_21, c1_.storage AS storage_22, c1_.bucket_key AS bucket_key_23, c1_.bucket_secret AS bucket_secret_24, c1_.bucket_name AS bucket_name_25, c1_.bucket_region AS bucket_region_26, c1_.bucket_endpoint AS bucket_endpoint_27, c1_.is_active AS is_active_28, c1_.configuration AS configuration_29, c1_.design_configuration AS design_configuration_30, c1_.description AS description_31, c1_.image_name AS image_name_32, c1_.navigation AS navigation_33, c1_.is_live_now AS is_live_now_34, c1_.video_gallery_ids AS video_gallery_ids_35, c1_.user_static_fields AS user_static_fields_36, c1_.logo_image_name AS logo_image_name_37, c1_.is_show_public AS is_show_public_38, c1_.is_main_container AS is_main_container_39, c1_.is_show_public_container AS is_show_public_container_40, c1_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_41, c1_.old_id AS old_id_42, c1_.is_login_container AS is_login_container_43, c1_.course_commission AS course_commission_44, c1_.created_at AS created_at_45, c1_.updated_at AS updated_at_46, l2_.id AS id_47, l2_.name AS name_48, l2_.is_active AS is_active_49, l2_.is_default AS is_default_50, l2_.locale AS locale_51, l2_.created_at AS created_at_52, l2_.updated_at AS updated_at_53, c1_.client_id AS client_id_54, c1_.container_category_id AS container_category_id_55, l2_.container_id AS container_id_56 FROM client c0_ LEFT JOIN container c1_ ON c0_.id = c1_.client_id LEFT JOIN language l2_ ON c1_.id = l2_.container_id WHERE c0_.is_show_public = 1 AND c0_.id = ? AND c0_.id IN (?) ORDER BY c0_.id ASC
Parameters:
[ 59 59 ] |
1.34 ms (1.05%) |
1 |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM client c0_ LEFT JOIN container c1_ ON c0_.id = c1_.client_id LEFT JOIN language l2_ ON c1_.id = l2_.container_id WHERE c0_.is_show_public = 1 AND c0_.id = ?
Parameters:
[
59
]
|
1.03 ms (0.81%) |
1 |
SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM client c0_ LEFT JOIN container c1_ ON c0_.id = c1_.client_id LEFT JOIN language l2_ ON c1_.id = l2_.container_id WHERE c0_.is_show_public = 1 AND c0_.id = ? ORDER BY c0_.id ASC LIMIT 12
Parameters:
[
59
]
|
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\Client | No errors. |
App\Entity\Container | No errors. |
App\Entity\Language | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\UserGroup | No errors. |
App\Entity\AFrameRoom | No errors. |
App\Entity\Background | No errors. |
App\Entity\CommonCategory | No errors. |