https://www.virtualrealitycommerce.org/eshop/4/product/37

Query Metrics

141 Database Queries
39 Different statements
127.66 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
26.67 ms
(20.89%)
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"
]
18.72 ms
(14.67%)
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
]
12.73 ms
(9.97%)
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"
]
6.28 ms
(4.92%)
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
]
4.26 ms
(3.33%)
1
SELECT t0.currency_id AS currency_id_1, t0.currency_name AS currency_name_2, t0.currency_key AS currency_key_3, t0.is_live AS is_live_4, t0.rate_eur AS rate_eur_5 FROM currency t0 INNER JOIN eshop_currency ON t0.currency_id = eshop_currency.currency_id WHERE eshop_currency.eshop_id = ?
Parameters:
[
  4
]
2.43 ms
(1.90%)
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:
[
  1
]
1.37 ms
(1.08%)
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.org"
]
0.66 ms
(0.52%)
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:
[]
0.41 ms
(0.32%)
4
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
]
0.12 ms
(0.09%)
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:
[
  "www.virtualrealitycommerce.org"
  "www.www.virtualrealitycommerce.org"
]
0.06 ms
(0.05%)
1
SELECT t0.lang_id AS lang_id_1, t0.lang_name AS lang_name_2, t0.lang_key AS lang_key_3, t0.is_live AS is_live_4 FROM language t0 INNER JOIN eshop_language ON t0.lang_id = eshop_language.lang_id WHERE eshop_language.eshop_id = ?
Parameters:
[
  4
]
0.06 ms
(0.05%)
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.05 ms
(0.04%)
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.05 ms
(0.04%)
1
SELECT w0_.wire_frame_id AS wire_frame_id_0, w0_.wire_frame_name AS wire_frame_name_1, w0_.wire_frame_file AS wire_frame_file_2, w0_.wire_frame_image AS wire_frame_image_3, w0_.service_id AS service_id_4 FROM wire_frame w0_ WHERE w0_.wire_frame_id = ?
Parameters:
[
  5
]
0.04 ms
(0.03%)
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:
[
  15
]

dynamic_conn connection

Time Count Info
12.72 ms
(9.97%)
11
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:
[
  "37"
  "en_US"
  "App\Entity\Product"
]
6.91 ms
(5.41%)
5
SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = ? AND w0_.locale = ? AND w0_.object_class = ?
Parameters:
[
  "4"
  "en_US"
  "App\Entity\WebPage"
]
6.37 ms
(4.99%)
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:
[
  "2"
  "en_US"
  "App\Entity\Category"
]
5.01 ms
(3.92%)
3
SELECT w0_.web_page_id AS web_page_id_0, w0_.web_page_name AS web_page_name_1, w0_.web_page_content AS web_page_content_2, w0_.web_page_description AS web_page_description_3, w0_.website_id AS website_id_4, w0_.eshop_id AS eshop_id_5, w0_.date_inserted AS date_inserted_6, w0_.date_last_control AS date_last_control_7, w0_.date_published AS date_published_8, w0_.web_page_type AS web_page_type_9, w0_.seo_title AS seo_title_10, w0_.seo_description AS seo_description_11, w0_.priority AS priority_12, w0_.image_file AS image_file_13, w0_.score AS score_14, w0_.auction_hall_id AS auction_hall_id_15 FROM web_page w0_ WHERE w0_.eshop_id = ? AND w0_.web_page_type = ?
Parameters:
[
  "4"
  2
]
4.02 ms
(3.15%)
1
SELECT p0_.price_level_id AS price_level_id_0, p0_.price_level_name AS price_level_name_1, p0_.price_level_description AS price_level_description_2 FROM price_level p0_
Parameters:
[]
4.01 ms
(3.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
]
3.88 ms
(3.04%)
1
SELECT t0.gallery_id AS gallery_id_1, t0.gallery_name AS gallery_name_2, t0.user_id AS user_id_3, t0.gallery_description AS gallery_description_4, t0.is_public AS is_public_5, t0.is_web_based AS is_web_based_6, t0.date_created AS date_created_7, t0.slide_gallery_width AS slide_gallery_width_8, t0.slide_gallery_height AS slide_gallery_height_9, t0.slideshow_width AS slideshow_width_10, t0.slideshow_height AS slideshow_height_11, t0.folder_name AS folder_name_12, t0.slideshow_effect AS slideshow_effect_13, t0.thumb_size AS thumb_size_14, t0.is_file_lock AS is_file_lock_15, t0.slide_gallery_is_vertical AS slide_gallery_is_vertical_16, t0.slideshow_time AS slideshow_time_17, t0.gallery_logo_url AS gallery_logo_url_18, t0.gallery_css AS gallery_css_19 FROM gallery t0 INNER JOIN product_gallery ON t0.gallery_id = product_gallery.gallery_id WHERE product_gallery.product_id = ?
Parameters:
[
  37
]
2.56 ms
(2.00%)
5
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_parameter_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[
  "1"
  "en_US"
  "App\Entity\ProductParameter"
]
2.54 ms
(1.99%)
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:
[]
2.05 ms
(1.61%)
2
SELECT p0_.product_parameter_id AS product_parameter_id_0, p0_.product_parameter_name AS product_parameter_name_1, p0_.product_parameter_description AS product_parameter_description_2, p0_.product_parameter_choices AS product_parameter_choices_3, p0_.unit_name AS unit_name_4, p0_.product_parameter_key AS product_parameter_key_5, p0_.priority AS priority_6, p0_.parameter_type AS parameter_type_7, p0_.is_visible AS is_visible_8, p0_.is_filterable AS is_filterable_9 FROM product_parameter p0_
Parameters:
[]
0.75 ms
(0.59%)
2
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM price_level_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[
  "1"
  "en_US"
  "App\Entity\PriceLevel"
]
0.70 ms
(0.55%)
1
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_ WHERE p0_.parent_product_id = ? ORDER BY p0_.product_id ASC
Parameters:
[
  "37"
]
0.69 ms
(0.54%)
8
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_ WHERE p0_.product_id = ?
Parameters:
[
  "37"
]
0.36 ms
(0.28%)
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:
[
  "37"
]
0.30 ms
(0.24%)
1
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 INNER JOIN product_category ON t0.category_id = product_category.category_id WHERE product_category.product_id = ?
Parameters:
[
  37
]
0.26 ms
(0.21%)
6
SELECT t0.product_id AS product_id_1, t0.product_key AS product_key_2, t0.ean AS ean_3, t0.erpkey AS erpkey_4, t0.parent_product_id AS parent_product_id_5, t0.product_name AS product_name_6, t0.product_description AS product_description_7, t0.product_short_description AS product_short_description_8, t0.image1 AS image1_9, t0.image2 AS image2_10, t0.image3 AS image3_11, t0.is_active AS is_active_12, t0.active_from AS active_from_13, t0.active_to AS active_to_14, t0.unit_name AS unit_name_15, t0.marketplace_department_id AS marketplace_department_id_16, t0.product_link AS product_link_17, t0.viewed_count AS viewed_count_18, t0.clicked_count AS clicked_count_19, t0.product_vat AS product_vat_20, t0.stock AS stock_21, t0.title_seo AS title_seo_22, t0.keywords_seo AS keywords_seo_23, t0.priority AS priority_24, t0.pieces_in_pack AS pieces_in_pack_25, t0.pack_price AS pack_price_26, t0.is_strict_pack_sale AS is_strict_pack_sale_27, t0.product_model_link AS product_model_link_28, t0.manufacturer AS manufacturer_29, t0.gallery3d_id AS gallery3d_id_30, t0.minimal_amount AS minimal_amount_31 FROM product t0 WHERE t0.product_id = ?
Parameters:
[
  37
]
0.16 ms
(0.12%)
1
SELECT p0_.product_parameter_value_id AS product_parameter_value_id_0, p0_.product_parameter_id AS product_parameter_id_1, p0_.product_id AS product_id_2, p0_.product_parameter_value AS product_parameter_value_3, p0_.unit_name AS unit_name_4, p0_.erp_key AS erp_key_5, p0_.priority AS priority_6 FROM product_parameter_value p0_ WHERE p0_.product_id = ?
Parameters:
[
  "37"
]
0.12 ms
(0.10%)
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 package_price p0_ WHERE p0_.product_id IN (?)
Parameters:
[
  "37"
]
0.09 ms
(0.07%)
2
SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = ?
Parameters:
[
  4
]
0.06 ms
(0.05%)
1
SELECT e0_.order_item_title AS order_item_title_0, e0_.product_id AS product_id_1, COUNT(e0_.product_id) AS sclr_2 FROM eshop_order_item e0_ WHERE e0_.product_id > 0 AND e0_.order_item_title <> ? GROUP BY e0_.product_id ORDER BY sclr_2 DESC LIMIT 7
Parameters:
[
  ""
]
0.05 ms
(0.04%)
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, c0_.root_id AS root_id_16, c0_.parent_id AS parent_id_17 FROM category c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 8 AND c0_.root_id = ? ORDER BY c0_.lft ASC
Parameters:
[
  2
]
0.05 ms
(0.04%)
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, 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:
[]
0.04 ms
(0.03%)
1
SELECT p0_.product_parameter_group_id AS product_parameter_group_id_0, p0_.product_parameter_group_name AS product_parameter_group_name_1, p0_.product_parameter_group_description AS product_parameter_group_description_2, p0_.product_parameter_key AS product_parameter_key_3, p0_.priority AS priority_4, p0_.is_visible AS is_visible_5 FROM product_parameter_group p0_
Parameters:
[]
0.04 ms
(0.03%)
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:
[
  1
  5
  4
  6
  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\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.
App\Entity\WireFrame No errors.

dynamic_em entity manager

Class Mapping errors
App\Entity\PriceLevel No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
App\Entity\PriceLevelTranslation No errors.
App\Entity\Product No errors.
App\Entity\Price No errors.
App\Entity\Gallery No errors.
App\Entity\Category No errors.
App\Entity\ProductGroup No errors.
App\Entity\Department No errors.
App\Entity\ProductTranslation No errors.
App\Entity\ProductParameter No errors.
App\Entity\ProductParameterGroup No errors.
App\Entity\ProductParameterTranslation No errors.
App\Entity\PackagePrice No errors.
App\Entity\Eshop No errors.
App\Entity\WebPage No errors.
App\Entity\WebPageTranslation No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\ProductParameterValue No errors.
App\Entity\OrderItem No errors.

eshop_em entity manager

No loaded entities.

eshop_demo_em entity manager

No loaded entities.