Query Metrics
13
Database Queries
8
Different statements
65.51 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 56.98 ms |
SELECT s0_.service_id AS service_id_0, s0_.service_name AS service_name_1, s0_.action AS action_2, s0_.service_type AS service_type_3, s0_.is_live AS is_live_4, s0_.image AS image_5, s0_.importance AS importance_6, s0_.trial_months AS trial_months_7, s0_.landing_url AS landing_url_8, s0_.register_url AS register_url_9, s0_.price AS price_10, s0_.background_image AS background_image_11 FROM service s0_ WHERE s0_.service_id = ?
Parameters:
[
5
]
|
| 2 | 0.13 ms |
SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_name = ?
Parameters:
[
"demo"
]
|
| 3 | 0.05 ms |
SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = ?
Parameters:
[
95
]
|
| 4 | 0.12 ms |
SELECT s0_.service_example_id AS service_example_id_0, s0_.service_example_name AS service_example_name_1, s0_.service_reference AS service_reference_2, s0_.landing_url AS landing_url_3, s0_.service_id AS service_id_4, s0_.image_url AS image_url_5, s0_.landing_url2 AS landing_url2_6, s0_.video_url AS video_url_7 FROM service_example s0_ WHERE s0_.service_id = ? LIMIT 3
Parameters:
[
5
]
|
| 5 | 0.29 ms |
SELECT t0.module_id AS module_id_1, t0.module_name AS module_name_2, t0.action AS action_3, t0.service_type AS service_type_4, t0.is_live AS is_live_5, t0.image AS image_6, t0.importance AS importance_7, t0.trial_months AS trial_months_8, t0.landing_url AS landing_url_9, t0.register_url AS register_url_10, t0.price AS price_11, t0.background_image AS background_image_12, t0.module_description AS module_description_13 FROM module t0 INNER JOIN service_module ON t0.module_id = service_module.module_id WHERE service_module.service_id = ?
Parameters:
[
5
]
|
| 6 | 6.47 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "15" "en_US" "App\Entity\Module" ] |
| 7 | 0.09 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "21" "en_US" "App\Entity\Module" ] |
| 8 | 0.04 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "25" "en_US" "App\Entity\Module" ] |
| 9 | 0.03 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "26" "en_US" "App\Entity\Module" ] |
| 10 | 1.04 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "29" "en_US" "App\Entity\Module" ] |
| 11 | 0.04 ms |
SELECT m0_.content AS content_0, m0_.field AS field_1 FROM module_translation m0_ WHERE m0_.foreign_key = ? AND m0_.locale = ? AND m0_.object_class = ?
Parameters:
[ "43" "en_US" "App\Entity\Module" ] |
dynamic_conn connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.11 ms |
SELECT g0_.gallery3_did AS gallery3_did_0, g0_.gallery3_dname AS gallery3_dname_1, g0_.user_id AS user_id_2, g0_.gallery3_ddescription AS gallery3_ddescription_3, g0_.date_created AS date_created_4, g0_.xml_source_path AS xml_source_path_5, g0_.gallery_logo_url AS gallery_logo_url_6, g0_.template3_dpath AS template3_dpath_7, g0_.is_start_guide AS is_start_guide_8, g0_.is_medium_resize AS is_medium_resize_9, g0_.guide_cycle AS guide_cycle_10, g0_.preferred_viewpoint_position AS preferred_viewpoint_position_11, g0_.preferred_viewpoint_rotation AS preferred_viewpoint_rotation_12, g0_.preferred_background_sky_color AS preferred_background_sky_color_13, g0_.preferred_background_ground_color AS preferred_background_ground_color_14, g0_.gallery_id AS gallery_id_15, g0_.texture_gallery_id AS texture_gallery_id_16, g0_.free_world3did AS free_world3did_17 FROM gallery_3d g0_ WHERE g0_.gallery3_did = ?
Parameters:
[
2
]
|
| 2 | 0.10 ms |
SELECT g0_.gallery_item_id AS gallery_item_id_0, g0_.gallery_id AS gallery_id_1, g0_.gallery_item_name AS gallery_item_name_2, g0_.gallery_item_description AS gallery_item_description_3, g0_.gallery_item_file AS gallery_item_file_4, g0_.priority AS priority_5, g0_.click_url AS click_url_6, g0_.slide_click_url AS slide_click_url_7 FROM gallery_item g0_ WHERE g0_.gallery_id = ?
Parameters:
[
2
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| dynamic_conn | doctrine.dbal.dynamic_conn_connection |
| eshop_conn | doctrine.dbal.eshop_conn_connection |
| eshop_demo_conn | doctrine.dbal.eshop_demo_conn_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| dynamic_em | doctrine.orm.dynamic_em_entity_manager |
| eshop_em | doctrine.orm.eshop_em_entity_manager |
| eshop_demo_em | doctrine.orm.eshop_demo_em_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Service | No errors. |
| App\Entity\Module | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ServiceExample | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| App\Entity\ModuleTranslation | No errors. |
dynamic_em entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Gallery3D | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\FreeWorld3D | No errors. |
| App\Entity\GalleryItem | No errors. |
eshop_em entity manager
No loaded entities.
eshop_demo_em entity manager
No loaded entities.