Query Metrics
203
Database Queries
30
Different statements
361.10 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
35.79 ms (9.91%) |
37 |
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:
[ "42" "en_US" "App\Entity\Module" ] |
23.37 ms (6.47%) |
2 |
SELECT e0_.eshop_id AS eshop_id_0, e0_.eshop_name AS eshop_name_1, e0_.user_id AS user_id_2, e0_.eshop_type AS eshop_type_3, e0_.priority AS priority_4, e0_.status AS status_5, e0_.date_inserted AS date_inserted_6, e0_.date_last_control AS date_last_control_7, e0_.logo_url AS logo_url_8, e0_.notes AS notes_9, e0_.admin_user_id AS admin_user_id_10, e0_.eshop_email AS eshop_email_11, e0_.order_email AS order_email_12, e0_.eshop_price AS eshop_price_13, e0_.eshop_current AS eshop_current_14, e0_.eshop_css AS eshop_css_15, e0_.product_view AS product_view_16, e0_.image_thumb_width AS image_thumb_width_17, e0_.image_thumb_height AS image_thumb_height_18, e0_.wire_frame_id AS wire_frame_id_19, e0_.product_list_wire_frame_id AS product_list_wire_frame_id_20, e0_.product_detail_wire_frame_id AS product_detail_wire_frame_id_21, e0_.preferred_language_id AS preferred_language_id_22, e0_.preferred_currency_id AS preferred_currency_id_23, e0_.round_price AS round_price_24, e0_.cut_long_description AS cut_long_description_25, e0_.display_products_from_subfolders AS display_products_from_subfolders_26, e0_.count_per_page AS count_per_page_27, e0_.is_product_catalogue AS is_product_catalogue_28, e0_.is_price_display AS is_price_display_29, e0_.display_netto_prices AS display_netto_prices_30, e0_.preferred_vat AS preferred_vat_31, e0_.category_image_thumb_width AS category_image_thumb_width_32, e0_.is_stock AS is_stock_33, e0_.display_products_from_subfolders_level AS display_products_from_subfolders_level_34, e0_.is_asynchrounous_shopping AS is_asynchrounous_shopping_35, e0_.is_virtual_reality AS is_virtual_reality_36 FROM eshop e0_ WHERE e0_.eshop_id = ?
Parameters:
[
"4"
]
|
18.32 ms (5.07%) |
16 |
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:
[
4
]
|
11.80 ms (3.27%) |
1 |
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:
[] |
3.59 ms (1.00%) |
1 |
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.cz"
]
|
0.30 ms (0.08%) |
3 |
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:
[
7
]
|
0.16 ms (0.04%) |
1 |
SELECT m0_.module_id AS module_id_0, m0_.module_name AS module_name_1, m0_.action AS action_2, m0_.service_type AS service_type_3, m0_.is_live AS is_live_4, m0_.image AS image_5, m0_.importance AS importance_6, m0_.trial_months AS trial_months_7, m0_.landing_url AS landing_url_8, m0_.register_url AS register_url_9, m0_.price AS price_10, m0_.background_image AS background_image_11, m0_.module_description AS module_description_12 FROM module m0_ WHERE m0_.module_id = ?
Parameters:
[
42
]
|
0.10 ms (0.03%) |
1 |
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.cz" "www.virtualrealitycommerce.cz" ] |
0.08 ms (0.02%) |
1 |
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 user_module ON t0.module_id = user_module.module_id WHERE user_module.user_id = ?
Parameters:
[
7
]
|
0.06 ms (0.02%) |
1 |
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:
[] |
0.04 ms (0.01%) |
1 |
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:
[
13
]
|
0.04 ms (0.01%) |
1 |
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:
[
4
]
|
dynamic_conn connection
Time▼ | Count | Info |
---|---|---|
47.37 ms (13.12%) |
69 |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "11" "en_US" "App\Entity\Product" ] |
36.40 ms (10.08%) |
1 |
SELECT t0.free_world3_did AS free_world3_did_1, t0.free_world3_dname AS free_world3_dname_2, t0.user_id AS user_id_3, t0.free_world3_ddescription AS free_world3_ddescription_4, t0.free_world3_dcontent AS free_world3_dcontent_5, t0.date_created AS date_created_6, t0.xml_file AS xml_file_7, t0.preferred_position AS preferred_position_8, t0.preferred_rotation AS preferred_rotation_9, t0.preferred_scale AS preferred_scale_10, t0.gallery3_did AS gallery3_did_11 FROM free_world_3d t0 INNER JOIN eshop3D_freeWorld3D ON t0.free_world3_did = eshop3D_freeWorld3D.free_world3did WHERE eshop3D_freeWorld3D.eshop3did = ?
Parameters:
[
27
]
|
28.94 ms (8.01%) |
1 |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 77815 77816 77821 77822 77823 77824 77825 ] |
21.00 ms (5.81%) |
1 |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 28 77808 77809 77810 77811 77812 77817 77818 77819 77820 ] |
20.23 ms (5.60%) |
14 |
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ INNER JOIN product_category p2_ ON p0_.product_id = p2_.product_id INNER JOIN category c1_ ON c1_.category_id = p2_.category_id WHERE p0_.parent_product_id = ? AND c1_.category_id IN (?) LIMIT 12
Parameters:
[ 0 1 ] |
18.09 ms (5.01%) |
7 |
SELECT t0.category_id AS category_id_1, t0.category_key AS category_key_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.eshop_id AS eshop_id_9, t0.erpkey AS erpkey_10, t0.is_active AS is_active_11, t0.is_hidden AS is_hidden_12, t0.image_thumb_width AS image_thumb_width_13, t0.image_thumb_height AS image_thumb_height_14, t0.auction_hall_id AS auction_hall_id_15, t0.marketplace_department_id AS marketplace_department_id_16, t0.root_id AS root_id_17, t0.parent_id AS parent_id_18 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
17.47 ms (4.84%) |
2 |
SELECT c0_.category_id AS category_id_0, c0_.category_key AS category_key_1, c0_.category_name AS category_name_2, c0_.category_description AS category_description_3, c0_.image1 AS image1_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.eshop_id AS eshop_id_8, c0_.erpkey AS erpkey_9, c0_.is_active AS is_active_10, c0_.is_hidden AS is_hidden_11, c0_.image_thumb_width AS image_thumb_width_12, c0_.image_thumb_height AS image_thumb_height_13, c0_.auction_hall_id AS auction_hall_id_14, c0_.marketplace_department_id AS marketplace_department_id_15, c0_.root_id AS root_id_16, c0_.parent_id AS parent_id_17 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.lft ASC
Parameters:
[] |
17.01 ms (4.71%) |
1 |
SELECT e0_.eshop3_did AS eshop3_did_0, e0_.eshop3_dname AS eshop3_dname_1, e0_.user_id AS user_id_2, e0_.eshop3_ddescription AS eshop3_ddescription_3, e0_.date_created AS date_created_4, e0_.xml_source_path AS xml_source_path_5, e0_.eshop_logo_url AS eshop_logo_url_6, e0_.template3_dpath AS template3_dpath_7, e0_.eshop_id AS eshop_id_8, e0_.texture_gallery_id AS texture_gallery_id_9 FROM eshop_3d e0_ WHERE e0_.eshop_id = ?
Parameters:
[
"4"
]
|
12.36 ms (3.42%) |
2 |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 5 13 14 15 16 17 18 37 38 39 40 ] |
11.44 ms (3.17%) |
1 |
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:
[
32
]
|
10.87 ms (3.01%) |
1 |
SELECT c0_.category_id AS category_id_0, c0_.category_key AS category_key_1, c0_.category_name AS category_name_2, c0_.category_description AS category_description_3, c0_.image1 AS image1_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.eshop_id AS eshop_id_8, c0_.erpkey AS erpkey_9, c0_.is_active AS is_active_10, c0_.is_hidden AS is_hidden_11, c0_.image_thumb_width AS image_thumb_width_12, c0_.image_thumb_height AS image_thumb_height_13, c0_.auction_hall_id AS auction_hall_id_14, c0_.marketplace_department_id AS marketplace_department_id_15 FROM category c0_ ORDER BY c0_.root_id ASC, c0_.lft ASC
Parameters:
[] |
9.79 ms (2.71%) |
1 |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 24 25 26 77805 77806 77807 ] |
6.73 ms (1.87%) |
2 |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?)
Parameters:
[
77778
]
|
4.74 ms (1.31%) |
2 |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 11 113 77799 77800 77801 77802 77803 77804 ] |
4.10 ms (1.14%) |
7 |
SELECT t0.category_id AS category_id_1, t0.category_key AS category_key_2, t0.category_name AS category_name_3, t0.category_description AS category_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.eshop_id AS eshop_id_9, t0.erpkey AS erpkey_10, t0.is_active AS is_active_11, t0.is_hidden AS is_hidden_12, t0.image_thumb_width AS image_thumb_width_13, t0.image_thumb_height AS image_thumb_height_14, t0.auction_hall_id AS auction_hall_id_15, t0.marketplace_department_id AS marketplace_department_id_16, t0.root_id AS root_id_17, t0.parent_id AS parent_id_18 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
0.71 ms (0.20%) |
20 |
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM category_translation c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\Category" ] |
0.10 ms (0.03%) |
3 |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (NULL)
Parameters:
[] |
0.09 ms (0.02%) |
2 |
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (?, ?)
Parameters:
[ 77813 77814 ] |
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\Eshop | No errors. |
App\Entity\Language | No errors. |
App\Entity\Currency | No errors. |
App\Entity\User | No errors. |
App\Entity\Service | No errors. |
App\Entity\Module | No errors. |
App\Entity\Server | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
App\Entity\ModuleTranslation | No errors. |
dynamic_em entity manager
Class | Mapping errors |
---|---|
App\Entity\Eshop3D | No errors. |
App\Entity\Eshop | No errors. |
App\Entity\Gallery | No errors. |
App\Entity\FreeWorld3D | No errors. |
App\Entity\Category | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
App\Entity\CategoryTranslation | No errors. |
App\Entity\GalleryItem | No errors. |
App\Entity\Product | No errors. |
App\Entity\Price | No errors. |
App\Entity\ProductGroup | No errors. |
App\Entity\Department | No errors. |
App\Entity\ProductTranslation | No errors. |
eshop_em entity manager
No loaded entities.
eshop_demo_em entity manager
No loaded entities.