Query Metrics
193
Database Queries
26
Different statements
108.37 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.14 ms |
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:
[
"14"
]
|
| 2 | 0.12 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:
[
28
]
|
| 3 | 3.37 ms |
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:
[
"14"
]
|
| 4 | 0.06 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:
[
28
]
|
| 5 | 0.07 ms |
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:
[
14
]
|
| 6 | 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:
[
28
]
|
| 7 | 0.04 ms |
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:
[
14
]
|
| 8 | 0.05 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:
[
4
]
|
| 9 | 0.10 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:
[
4
]
|
| 10 | 0.04 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:
[
4
]
|
| 11 | 0.04 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:
[
4
]
|
| 12 | 0.05 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:
[
4
]
|
| 13 | 0.06 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:
[
4
]
|
| 14 | 2.60 ms |
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:
[
4
]
|
| 15 | 4.84 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:
[
4
]
|
| 16 | 3.68 ms |
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:
[
14
]
|
dynamic_conn connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 8.98 ms |
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:
[ "14" 2 ] |
| 2 | 0.07 ms |
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:
[ "1" "en_US" "App\Entity\WebPage" ] |
| 3 | 0.05 ms |
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:
[
1
]
|
| 4 | 0.04 ms |
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:
[ "14" 3 ] |
| 5 | 0.04 ms |
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:
[ "5" "en_US" "App\Entity\WebPage" ] |
| 6 | 0.04 ms |
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:
[
5
]
|
| 7 | 0.04 ms |
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:
[ "14" 1 ] |
| 8 | 0.03 ms |
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:
[ "7" "en_US" "App\Entity\WebPage" ] |
| 9 | 0.04 ms |
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:
[
7
]
|
| 10 | 0.05 ms |
SELECT p0_.product_group_id AS product_group_id_0, p0_.product_group_name AS product_group_name_1, p0_.product_group_description AS product_group_description_2, p0_.product_group_css1 AS product_group_css1_3, p0_.product_group_css2 AS product_group_css2_4, p0_.is_visible AS is_visible_5 FROM product_group p0_ WHERE p0_.product_group_id = ?
Parameters:
[
"1"
]
|
| 11 | 0.05 ms |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_group_translation p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "1" "en_US" "App\Entity\ProductGroup" ] |
| 12 | 0.07 ms |
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_groups p2_ ON p0_.product_id = p2_.product_id INNER JOIN product_group p1_ ON p1_.product_group_id = p2_.product_group_id WHERE p1_.product_group_id = ?
Parameters:
[
1
]
|
| 13 | 2.38 ms |
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:
[ "8898" "en_US" "App\Entity\Product" ] |
| 14 | 0.05 ms |
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:
[ "8949" "en_US" "App\Entity\Product" ] |
| 15 | 0.04 ms |
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:
[ "9001" "en_US" "App\Entity\Product" ] |
| 16 | 0.04 ms |
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:
[ "9053" "en_US" "App\Entity\Product" ] |
| 17 | 0.04 ms |
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:
[ "9082" "en_US" "App\Entity\Product" ] |
| 18 | 0.04 ms |
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:
[ "9345" "en_US" "App\Entity\Product" ] |
| 19 | 2.46 ms |
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, c1_.category_id AS category_id_31, c1_.category_key AS category_key_32, c1_.category_name AS category_name_33, c1_.category_description AS category_description_34, c1_.image1 AS image1_35, c1_.lft AS lft_36, c1_.lvl AS lvl_37, c1_.rgt AS rgt_38, c1_.eshop_id AS eshop_id_39, c1_.erpkey AS erpkey_40, c1_.is_active AS is_active_41, c1_.is_hidden AS is_hidden_42, c1_.image_thumb_width AS image_thumb_width_43, c1_.image_thumb_height AS image_thumb_height_44, c1_.auction_hall_id AS auction_hall_id_45, c1_.marketplace_department_id AS marketplace_department_id_46, c1_.priority AS priority_47, c1_.root_id AS root_id_48, c1_.parent_id AS parent_id_49 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_.product_id = ?
Parameters:
[
8898
]
|
| 20 | 0.07 ms |
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:
[ "5" "en_US" "App\Entity\Category" ] |
| 21 | 0.05 ms |
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:
[
8898
]
|
| 22 | 0.04 ms |
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:
[ "8898" "de" "App\Entity\Product" ] |
| 23 | 0.04 ms |
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:
[
8898
]
|
| 24 | 0.04 ms |
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:
[ "8898" "sk" "App\Entity\Product" ] |
| 25 | 0.04 ms |
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:
[
8898
]
|
| 26 | 0.05 ms |
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:
[
8898
]
|
| 27 | 0.05 ms |
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:
[] |
| 28 | 0.05 ms |
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" ] |
| 29 | 1.97 ms |
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:
[ "2" "en_US" "App\Entity\PriceLevel" ] |
| 30 | 0.05 ms |
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:
[ "3" "en_US" "App\Entity\PriceLevel" ] |
| 31 | 0.06 ms |
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:
[ "4" "en_US" "App\Entity\PriceLevel" ] |
| 32 | 0.04 ms |
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:
[ "6" "en_US" "App\Entity\PriceLevel" ] |
| 33 | 0.04 ms |
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:
[ "8" "en_US" "App\Entity\PriceLevel" ] |
| 34 | 0.04 ms |
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:
[ "10" "en_US" "App\Entity\PriceLevel" ] |
| 35 | 0.05 ms |
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:
[ "11" "en_US" "App\Entity\PriceLevel" ] |
| 36 | 1.93 ms |
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:
[
8949
]
|
| 37 | 0.05 ms |
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:
[ "8949" "de" "App\Entity\Product" ] |
| 38 | 7.65 ms |
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:
[
8949
]
|
| 39 | 0.05 ms |
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:
[ "8949" "sk" "App\Entity\Product" ] |
| 40 | 0.04 ms |
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:
[
8949
]
|
| 41 | 0.07 ms |
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:
[
8949
]
|
| 42 | 0.05 ms |
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:
[] |
| 43 | 0.07 ms |
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:
[
9001
]
|
| 44 | 0.05 ms |
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:
[ "9001" "de" "App\Entity\Product" ] |
| 45 | 0.06 ms |
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:
[
9001
]
|
| 46 | 1.39 ms |
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:
[ "9001" "sk" "App\Entity\Product" ] |
| 47 | 0.06 ms |
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:
[
9001
]
|
| 48 | 2.10 ms |
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:
[
9001
]
|
| 49 | 0.04 ms |
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:
[] |
| 50 | 0.06 ms |
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:
[
9053
]
|
| 51 | 0.05 ms |
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:
[ "9053" "de" "App\Entity\Product" ] |
| 52 | 0.04 ms |
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:
[
9053
]
|
| 53 | 0.04 ms |
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:
[ "9053" "sk" "App\Entity\Product" ] |
| 54 | 0.04 ms |
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:
[
9053
]
|
| 55 | 0.04 ms |
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:
[
9053
]
|
| 56 | 0.05 ms |
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:
[] |
| 57 | 5.07 ms |
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:
[
9082
]
|
| 58 | 0.06 ms |
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:
[ "9082" "de" "App\Entity\Product" ] |
| 59 | 0.08 ms |
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:
[
9082
]
|
| 60 | 0.05 ms |
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:
[ "9082" "sk" "App\Entity\Product" ] |
| 61 | 0.24 ms |
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:
[
9082
]
|
| 62 | 0.85 ms |
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:
[
9082
]
|
| 63 | 0.05 ms |
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:
[] |
| 64 | 1.09 ms |
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:
[
9345
]
|
| 65 | 0.06 ms |
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:
[ "9345" "de" "App\Entity\Product" ] |
| 66 | 0.05 ms |
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:
[
9345
]
|
| 67 | 0.05 ms |
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:
[ "9345" "sk" "App\Entity\Product" ] |
| 68 | 0.05 ms |
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:
[
9345
]
|
| 69 | 0.04 ms |
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:
[
9345
]
|
| 70 | 2.89 ms |
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:
[] |
| 71 | 0.07 ms |
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_.priority AS priority_16, c0_.root_id AS root_id_17, c0_.parent_id AS parent_id_18 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.lft ASC
Parameters:
[] |
| 72 | 0.05 ms |
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" ] |
| 73 | 0.04 ms |
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" ] |
| 74 | 0.04 ms |
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:
[ "4" "en_US" "App\Entity\Category" ] |
| 75 | 0.04 ms |
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:
[ "46" "en_US" "App\Entity\Category" ] |
| 76 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
| 77 | 2.49 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
| 78 | 0.05 ms |
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:
[ "7" "en_US" "App\Entity\Category" ] |
| 79 | 3.15 ms |
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:
[ "8" "en_US" "App\Entity\Category" ] |
| 80 | 0.04 ms |
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:
[ "9" "en_US" "App\Entity\Category" ] |
| 81 | 0.03 ms |
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:
[ "10" "en_US" "App\Entity\Category" ] |
| 82 | 0.03 ms |
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:
[ "11" "en_US" "App\Entity\Category" ] |
| 83 | 0.03 ms |
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:
[ "12" "en_US" "App\Entity\Category" ] |
| 84 | 0.06 ms |
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:
[ "13" "en_US" "App\Entity\Category" ] |
| 85 | 0.03 ms |
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:
[ "14" "en_US" "App\Entity\Category" ] |
| 86 | 0.03 ms |
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:
[ "15" "en_US" "App\Entity\Category" ] |
| 87 | 0.03 ms |
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:
[ "16" "en_US" "App\Entity\Category" ] |
| 88 | 0.03 ms |
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:
[ "17" "en_US" "App\Entity\Category" ] |
| 89 | 4.96 ms |
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:
[ "18" "en_US" "App\Entity\Category" ] |
| 90 | 0.07 ms |
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:
[ "19" "en_US" "App\Entity\Category" ] |
| 91 | 0.04 ms |
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:
[ "20" "en_US" "App\Entity\Category" ] |
| 92 | 0.04 ms |
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:
[ "38" "en_US" "App\Entity\Category" ] |
| 93 | 0.03 ms |
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:
[ "39" "en_US" "App\Entity\Category" ] |
| 94 | 0.26 ms |
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:
[ "40" "en_US" "App\Entity\Category" ] |
| 95 | 0.04 ms |
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:
[ "32" "en_US" "App\Entity\Category" ] |
| 96 | 0.96 ms |
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:
[ "33" "en_US" "App\Entity\Category" ] |
| 97 | 0.04 ms |
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:
[ "6" "en_US" "App\Entity\Category" ] |
| 98 | 0.03 ms |
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:
[ "43" "en_US" "App\Entity\Category" ] |
| 99 | 0.03 ms |
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:
[ "53" "en_US" "App\Entity\Category" ] |
| 100 | 0.03 ms |
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:
[ "54" "en_US" "App\Entity\Category" ] |
| 101 | 0.04 ms |
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:
[ "55" "en_US" "App\Entity\Category" ] |
| 102 | 1.83 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
7
]
|
| 103 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
8
]
|
| 104 | 1.19 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
9
]
|
| 105 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
10
]
|
| 106 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
11
]
|
| 107 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
12
]
|
| 108 | 1.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
14
]
|
| 109 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
15
]
|
| 110 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
16
]
|
| 111 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
17
]
|
| 112 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
18
]
|
| 113 | 1.77 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
19
]
|
| 114 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
20
]
|
| 115 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
32
]
|
| 116 | 3.58 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
33
]
|
| 117 | 0.06 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
5
]
|
| 118 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
6
]
|
| 119 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
43
]
|
| 120 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
53
]
|
| 121 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
54
]
|
| 122 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
55
]
|
| 123 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
2
]
|
| 124 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
2
]
|
| 125 | 2.45 ms |
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:
[ "25" "en_US" "App\Entity\Category" ] |
| 126 | 0.05 ms |
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:
[ "27" "en_US" "App\Entity\Category" ] |
| 127 | 0.57 ms |
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:
[ "28" "en_US" "App\Entity\Category" ] |
| 128 | 0.05 ms |
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:
[ "29" "en_US" "App\Entity\Category" ] |
| 129 | 0.04 ms |
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:
[ "26" "en_US" "App\Entity\Category" ] |
| 130 | 0.04 ms |
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:
[ "30" "en_US" "App\Entity\Category" ] |
| 131 | 2.82 ms |
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:
[ "37" "en_US" "App\Entity\Category" ] |
| 132 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
25
]
|
| 133 | 2.10 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
27
]
|
| 134 | 0.06 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
28
]
|
| 135 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
29
]
|
| 136 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
26
]
|
| 137 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
4
]
|
| 138 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
4
]
|
| 139 | 0.57 ms |
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:
[ "22" "en_US" "App\Entity\Category" ] |
| 140 | 0.04 ms |
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:
[ "23" "en_US" "App\Entity\Category" ] |
| 141 | 0.03 ms |
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:
[ "24" "en_US" "App\Entity\Category" ] |
| 142 | 0.03 ms |
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:
[ "41" "en_US" "App\Entity\Category" ] |
| 143 | 0.04 ms |
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:
[ "42" "en_US" "App\Entity\Category" ] |
| 144 | 3.47 ms |
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:
[ "44" "en_US" "App\Entity\Category" ] |
| 145 | 0.05 ms |
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:
[ "48" "en_US" "App\Entity\Category" ] |
| 146 | 0.03 ms |
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:
[ "50" "en_US" "App\Entity\Category" ] |
| 147 | 0.03 ms |
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:
[ "56" "en_US" "App\Entity\Category" ] |
| 148 | 1.30 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
22
]
|
| 149 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
23
]
|
| 150 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
24
]
|
| 151 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
41
]
|
| 152 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
42
]
|
| 153 | 0.25 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
44
]
|
| 154 | 1.22 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
48
]
|
| 155 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
50
]
|
| 156 | 0.04 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
56
]
|
| 157 | 1.63 ms |
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_.priority AS priority_16 FROM category c0_ ORDER BY c0_.root_id ASC, c0_.lft ASC
Parameters:
[] |
| 158 | 0.46 ms |
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_.priority AS priority_16, c0_.root_id AS root_id_17, c0_.parent_id AS parent_id_18 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.lft ASC
Parameters:
[] |
| 159 | 0.48 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
| 160 | 0.05 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
2
]
|
| 161 | 1.73 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.category_id = ?
Parameters:
[
4
]
|
| 162 | 0.12 ms |
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:
[ "" ] |
| 163 | 0.98 ms |
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:
[
8949
]
|
| 164 | 0.05 ms |
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:
[
8998
]
|
| 165 | 0.04 ms |
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:
[ "8998" "en_US" "App\Entity\Product" ] |
| 166 | 0.04 ms |
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:
[
2
]
|
| 167 | 0.04 ms |
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:
[
9345
]
|
| 168 | 0.04 ms |
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:
[
9134
]
|
| 169 | 0.36 ms |
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:
[ "9134" "en_US" "App\Entity\Product" ] |
| 170 | 0.06 ms |
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:
[
8963
]
|
| 171 | 0.05 ms |
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:
[ "8963" "en_US" "App\Entity\Product" ] |
| 172 | 0.04 ms |
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:
[
8999
]
|
| 173 | 0.04 ms |
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:
[ "8999" "en_US" "App\Entity\Product" ] |
| 174 | 0.04 ms |
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:
[ 8949 8998 9345 9134 8963 8999 ] |
| 175 | 2.97 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
| 176 | 0.98 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
2
]
|
| 177 | 2.30 ms |
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.priority AS priority_17, t0.root_id AS root_id_18, t0.parent_id AS parent_id_19 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
4
]
|
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\WireFrame | No errors. |
dynamic_em entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Eshop | No errors. |
| App\Entity\WebPage | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| App\Entity\WebPageTranslation | No errors. |
| App\Entity\ProductGroup | No errors. |
| App\Entity\ProductGroupTranslation | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Price | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\ProductTranslation | No errors. |
| App\Entity\CategoryTranslation | No errors. |
| App\Entity\PriceLevel | No errors. |
| App\Entity\PriceLevelTranslation | No errors. |
| App\Entity\OrderItem | No errors. |
eshop_em entity manager
No loaded entities.
eshop_demo_em entity manager
No loaded entities.