http://virtualrealitycommerce.eu/services3d

Query Metrics

20 Database Queries
14 Different statements
79.40 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 5.76 ms
SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.http_host = ? OR s0_.http_host = ?
Parameters:
[
  "virtualrealitycommerce.eu"
  "www.virtualrealitycommerce.eu"
]
2 5.85 ms
SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.label = ?
Parameters:
[
  "virtualrealitycommerce.eu"
]
3 3.38 ms
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_
Parameters:
[]
4 0.92 ms
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_
Parameters:
[]
5 0.77 ms
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_ WHERE l0_.lang_id = ?
Parameters:
[
  1
]
6 1.18 ms
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_ WHERE c0_.currency_id = ?
Parameters:
[
  1
]
7 0.05 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
]
8 16.26 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
]
9 3.46 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
]
10 0.06 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
]
11 0.26 ms
SELECT t0.service_id AS service_id_1, t0.service_name AS service_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 FROM service t0 INNER JOIN server_service ON t0.service_id = server_service.service_id WHERE server_service.server_id = ?
Parameters:
[
  12
]
12 0.11 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
]
13 21.25 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"
]
14 0.05 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"
]
15 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:
[
  "25"
  "en_US"
  "App\Entity\Module"
]
16 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"
]
17 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:
[
  "29"
  "en_US"
  "App\Entity\Module"
]
18 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:
[
  "43"
  "en_US"
  "App\Entity\Module"
]

dynamic_conn connection

# Time Info
1 16.84 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 3.08 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\Server No errors.
App\Entity\Service No errors.
App\Entity\Language No errors.
App\Entity\Currency 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.