| 1 |
0.20 ms |
SELECT t0.id AS id_1, t0.sign AS sign_2, t0.currency_separator AS currency_separator_3, t0.position_price AS position_price_4, t0.is_default AS is_default_5, t0.is_active AS is_active_6, t0.factorPln AS factorPln_7, t0.iso_code AS iso_code_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13 FROM currency t0 WHERE t0.is_default = ? AND t0.deleted_by IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.sign AS sign_2, t0.currency_separator AS currency_separator_3, t0.position_price AS position_price_4, t0.is_default AS is_default_5, t0.is_active AS is_active_6, t0.factorPln AS factorPln_7, t0.iso_code AS iso_code_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13 FROM currency t0 WHERE t0.is_default = 1 AND t0.deleted_by IS NULL LIMIT 1;
|
| 2 |
0.53 ms |
SELECT t0.id AS id_1, t0.from_url AS from_url_2, t0.to_url AS to_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8 FROM url_redirect t0 WHERE t0.deleted_by IS NULL AND t0.from_url = ? LIMIT 1
Parameters: [
"https://ckdev.centrumkrzesel.pl/narozniki-ogrodowe/324/c"
]
SELECT t0.id AS id_1, t0.from_url AS from_url_2, t0.to_url AS to_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8 FROM url_redirect t0 WHERE t0.deleted_by IS NULL AND t0.from_url = 'https://ckdev.centrumkrzesel.pl/narozniki-ogrodowe/324/c' LIMIT 1;
|
| 3 |
0.22 ms |
SELECT t0.id AS id_1, t0.token AS token_2, t0.valid_to AS valid_to_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8, t0.user_id AS user_id_9 FROM fos_user_token t0 WHERE t0.deleted_by IS NULL AND t0.token IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.token AS token_2, t0.valid_to AS valid_to_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_by AS deleted_by_8, t0.user_id AS user_id_9 FROM fos_user_token t0 WHERE t0.deleted_by IS NULL AND t0.token IS NULL LIMIT 1;
|
| 4 |
0.50 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = ? AND t0.deleted_by IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = 'pl' AND t0.deleted_by IS NULL LIMIT 1;
|
| 5 |
15.71 ms |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c4_.id AS id_52, c4_.visible AS visible_53, c4_.special AS special_54, c4_.shortcut AS shortcut_55, c4_.position AS position_56, c4_.is_homepage AS is_homepage_57, c4_.nb_products AS nb_products_58, c0_.category_parent_id AS category_parent_id_59, c1_.translatable_id AS translatable_id_60, c2_.category_parent_id AS category_parent_id_61, c3_.translatable_id AS translatable_id_62, c4_.category_id AS category_id_63, c4_.language AS language_64 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c5_ ON c0_.id = c5_.category_id INNER JOIN language l6_ ON c5_.language = l6_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id LEFT JOIN category_lang_param c4_ ON c2_.id = c4_.category_id LEFT JOIN language l7_ ON c4_.language = l7_.id WHERE c1_.locale = ? AND l6_.locale = ? AND c5_.special = ? AND c5_.shortcut = ? AND c0_.deleted_by IS NULL AND c5_.visible = ? AND c2_.deleted_by IS NULL AND l7_.locale = ? AND c4_.visible = 1 AND c0_.category_parent_id IS NULL AND c0_.id <> 209 AND c0_.id <> 121 ORDER BY c5_.position ASC, c4_.position ASC, c2_.position ASC
Parameters: [
"pl"
"pl"
0
0
1
"pl"
]
SELECT
c0_.id AS id_0,
c0_.level AS level_1,
c0_.position AS position_2,
c0_.alt AS alt_3,
c0_.image_custom_name AS image_custom_name_4,
c0_.image_name_2 AS image_name_2_5,
c0_.image_name_3 AS image_name_3_6,
c0_.image_name AS image_name_7,
c0_.created_at AS created_at_8,
c0_.updated_at AS updated_at_9,
c0_.created_by AS created_by_10,
c0_.updated_by AS updated_by_11,
c0_.deleted_by AS deleted_by_12,
c1_.id AS id_13,
c1_.name AS name_14,
c1_.description AS description_15,
c1_.meta_title AS meta_title_16,
c1_.meta_description AS meta_description_17,
c1_.meta_keywords AS meta_keywords_18,
c1_.custom_h1 AS custom_h1_19,
c1_.canonical AS canonical_20,
c1_.slug AS slug_21,
c1_.google_product_type AS google_product_type_22,
c1_.google_product_category AS google_product_category_23,
c1_.special_product_category AS special_product_category_24,
c1_.locale AS locale_25,
c2_.id AS id_26,
c2_.level AS level_27,
c2_.position AS position_28,
c2_.alt AS alt_29,
c2_.image_custom_name AS image_custom_name_30,
c2_.image_name_2 AS image_name_2_31,
c2_.image_name_3 AS image_name_3_32,
c2_.image_name AS image_name_33,
c2_.created_at AS created_at_34,
c2_.updated_at AS updated_at_35,
c2_.created_by AS created_by_36,
c2_.updated_by AS updated_by_37,
c2_.deleted_by AS deleted_by_38,
c3_.id AS id_39,
c3_.name AS name_40,
c3_.description AS description_41,
c3_.meta_title AS meta_title_42,
c3_.meta_description AS meta_description_43,
c3_.meta_keywords AS meta_keywords_44,
c3_.custom_h1 AS custom_h1_45,
c3_.canonical AS canonical_46,
c3_.slug AS slug_47,
c3_.google_product_type AS google_product_type_48,
c3_.google_product_category AS google_product_category_49,
c3_.special_product_category AS special_product_category_50,
c3_.locale AS locale_51,
c4_.id AS id_52,
c4_.visible AS visible_53,
c4_.special AS special_54,
c4_.shortcut AS shortcut_55,
c4_.position AS position_56,
c4_.is_homepage AS is_homepage_57,
c4_.nb_products AS nb_products_58,
c0_.category_parent_id AS category_parent_id_59,
c1_.translatable_id AS translatable_id_60,
c2_.category_parent_id AS category_parent_id_61,
c3_.translatable_id AS translatable_id_62,
c4_.category_id AS category_id_63,
c4_.language AS language_64
FROM
category c0_
INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id
INNER JOIN category_lang_param c5_ ON c0_.id = c5_.category_id
INNER JOIN language l6_ ON c5_.language = l6_.id
LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id
LEFT JOIN category_lang_param c4_ ON c2_.id = c4_.category_id
LEFT JOIN language l7_ ON c4_.language = l7_.id
WHERE
c1_.locale = ?
AND l6_.locale = ?
AND c5_.special = ?
AND c5_.shortcut = ?
AND c0_.deleted_by IS NULL
AND c5_.visible = ?
AND c2_.deleted_by IS NULL
AND l7_.locale = ?
AND c4_.visible = 1
AND c0_.category_parent_id IS NULL
AND c0_.id <> 209
AND c0_.id <> 121
ORDER BY
c5_.position ASC,
c4_.position ASC,
c2_.position ASC
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c4_.id AS id_52, c4_.visible AS visible_53, c4_.special AS special_54, c4_.shortcut AS shortcut_55, c4_.position AS position_56, c4_.is_homepage AS is_homepage_57, c4_.nb_products AS nb_products_58, c0_.category_parent_id AS category_parent_id_59, c1_.translatable_id AS translatable_id_60, c2_.category_parent_id AS category_parent_id_61, c3_.translatable_id AS translatable_id_62, c4_.category_id AS category_id_63, c4_.language AS language_64 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c5_ ON c0_.id = c5_.category_id INNER JOIN language l6_ ON c5_.language = l6_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id LEFT JOIN category_lang_param c4_ ON c2_.id = c4_.category_id LEFT JOIN language l7_ ON c4_.language = l7_.id WHERE c1_.locale = 'pl' AND l6_.locale = 'pl' AND c5_.special = 0 AND c5_.shortcut = 0 AND c0_.deleted_by IS NULL AND c5_.visible = 1 AND c2_.deleted_by IS NULL AND l7_.locale = 'pl' AND c4_.visible = 1 AND c0_.category_parent_id IS NULL AND c0_.id <> 209 AND c0_.id <> 121 ORDER BY c5_.position ASC, c4_.position ASC, c2_.position ASC;
|
| 6 |
2.14 ms |
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id WHERE f1_.locale = ? AND f0_.deleted_by IS NULL AND l3_.locale = ? AND f2_.visible = ? ORDER BY f2_.position ASC
Parameters: [
"pl"
"pl"
1
]
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id WHERE f1_.locale = 'pl' AND f0_.deleted_by IS NULL AND l3_.locale = 'pl' AND f2_.visible = 1 ORDER BY f2_.position ASC;
|
| 7 |
0.45 ms |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c0_.category_parent_id AS category_parent_id_13 FROM category c0_ WHERE c0_.id IN (?)
Parameters: [
[
"324"
]
]
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c0_.category_parent_id AS category_parent_id_13 FROM category c0_ WHERE c0_.id IN ('324');
|
| 8 |
1.71 ms |
SELECT p0_.id AS id_0, p0_.available AS available_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.created_by AS created_by_4, p0_.updated_by AS updated_by_5, p0_.deleted_by AS deleted_by_6, p1_.id AS id_7, p1_.is_filter AS is_filter_8, p1_.choosable AS choosable_9, p1_.group_name AS group_name_10, p1_.simple AS simple_11, p1_.created_at AS created_at_12, p1_.updated_at AS updated_at_13, p1_.created_by AS created_by_14, p1_.updated_by AS updated_by_15, p1_.deleted_by AS deleted_by_16, p0_.product_id AS product_id_17, p0_.product_parameter_id AS product_parameter_id_18, p0_.product_parameter_value_id AS product_parameter_value_id_19 FROM product_filter p0_ INNER JOIN product p2_ ON p0_.product_id = p2_.id INNER JOIN product_parameter p1_ ON p0_.product_parameter_id = p1_.id INNER JOIN product_category p3_ ON p2_.id = p3_.product_id INNER JOIN category c4_ ON p3_.category_id = c4_.id INNER JOIN product_parameter_lang_param p5_ ON p1_.id = p5_.product_parameter_id INNER JOIN language l6_ ON p5_.language = l6_.id WHERE l6_.locale = ? AND p0_.available = ? AND c4_.id = ? AND p0_.deleted_by IS NULL GROUP BY p1_.id
Parameters: [
"pl"
1
"324"
]
SELECT p0_.id AS id_0, p0_.available AS available_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.created_by AS created_by_4, p0_.updated_by AS updated_by_5, p0_.deleted_by AS deleted_by_6, p1_.id AS id_7, p1_.is_filter AS is_filter_8, p1_.choosable AS choosable_9, p1_.group_name AS group_name_10, p1_.simple AS simple_11, p1_.created_at AS created_at_12, p1_.updated_at AS updated_at_13, p1_.created_by AS created_by_14, p1_.updated_by AS updated_by_15, p1_.deleted_by AS deleted_by_16, p0_.product_id AS product_id_17, p0_.product_parameter_id AS product_parameter_id_18, p0_.product_parameter_value_id AS product_parameter_value_id_19 FROM product_filter p0_ INNER JOIN product p2_ ON p0_.product_id = p2_.id INNER JOIN product_parameter p1_ ON p0_.product_parameter_id = p1_.id INNER JOIN product_category p3_ ON p2_.id = p3_.product_id INNER JOIN category c4_ ON p3_.category_id = c4_.id INNER JOIN product_parameter_lang_param p5_ ON p1_.id = p5_.product_parameter_id INNER JOIN language l6_ ON p5_.language = l6_.id WHERE l6_.locale = 'pl' AND p0_.available = 1 AND c4_.id = '324' AND p0_.deleted_by IS NULL GROUP BY p1_.id;
|
| 9 |
18.27 ms |
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = ? AND a9_.locale = ? AND l14_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p15_.category_id = ? AND c16_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
1
324
]
SELECT
p0_.listingMarkersIds AS listingMarkersIds_0,
p1_.promotion_icon AS promotion_icon_1,
p1_.is_new AS is_new_2,
p2_.image_name AS image_name_3,
p3_.image_name AS image_name_4,
p1_.bestseller AS bestseller_5,
p4_.id AS id_6,
c5_.sign AS sign_7,
c5_.id AS id_8,
p1_.price_description AS price_description_9,
p1_.price_crossed AS price_crossed_10,
p1_.omnibus_price AS omnibus_price_11,
p0_.id AS id_12,
p0_.symbol AS symbol_13,
p0_.photo3d AS photo3d_14,
p0_.is_variants AS is_variants_15,
p0_.is_palette_delivery AS is_palette_delivery_16,
p0_.payu AS payu_17,
p0_.automatic_price AS automatic_price_18,
p0_.halmar_stock_exchange AS halmar_stock_exchange_19,
p0_.diablo_stock_exchange AS diablo_stock_exchange_20,
p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21,
p0_.actona_stock_exchange AS actona_stock_exchange_22,
p0_.unique_stock_exchange AS unique_stock_exchange_23,
p0_.is_compare AS is_compare_24,
p0_.priority_search_engine AS priority_search_engine_25,
p0_.is_negotiate AS is_negotiate_26,
p0_.is_rebate_code AS is_rebate_code_27,
p0_.old_price AS old_price_28,
p0_.film AS film_29,
p0_.small_product_photo AS small_product_photo_30,
p0_.max_quantity AS max_quantity_31,
p0_.listingMarkersIds AS listingMarkersIds_32,
p0_.temporary_unavailable AS temporary_unavailable_33,
p0_.last_ranking_update AS last_ranking_update_34,
p0_.height AS height_35,
p0_.width AS width_36,
p0_.depth AS depth_37,
p0_.shipping_category AS shipping_category_38,
p0_.created_at AS created_at_39,
p0_.updated_at AS updated_at_40,
p0_.created_by AS created_by_41,
p0_.updated_by AS updated_by_42,
p0_.deleted_by AS deleted_by_43,
p6_.id AS id_44,
p6_.name AS name_45,
p6_.description AS description_46,
p6_.meta_title AS meta_title_47,
p6_.meta_description AS meta_description_48,
p6_.meta_keywords AS meta_keywords_49,
p6_.slug AS slug_50,
p6_.short_description AS short_description_51,
p6_.short_description_textile AS short_description_textile_52,
p6_.short_description_color AS short_description_color_53,
p6_.short_function_description AS short_function_description_54,
p6_.search_engine AS search_engine_55,
p6_.photo3d_gallery_url AS photo3d_gallery_url_56,
p6_.youtube_gallery_url AS youtube_gallery_url_57,
p6_.trans_film AS trans_film_58,
p6_.canonical AS canonical_59,
p6_.photo3d_additional AS photo3d_additional_60,
p6_.locale AS locale_61,
p1_.id AS id_62,
p1_.visible AS visible_63,
p1_.price_description AS price_description_64,
p1_.promotion AS promotion_65,
p1_.is_new AS is_new_66,
p1_.bestseller AS bestseller_67,
p1_.promote_one_homepage AS promote_one_homepage_68,
p1_.ready_for_publication AS ready_for_publication_69,
p1_.sale AS sale_70,
p1_.rating_value AS rating_value_71,
p1_.review_count AS review_count_72,
p1_.price_change AS price_change_73,
p1_.priority AS priority_74,
p1_.price_crossed AS price_crossed_75,
p1_.omnibus_price AS omnibus_price_76,
p1_.promotion_icon AS promotion_icon_77,
p1_.promo_price AS promo_price_78,
l7_.id AS id_79,
l7_.locale AS locale_80,
l7_.domain AS domain_81,
l7_.is_active AS is_active_82,
l7_.is_default AS is_default_83,
l7_.helpline AS helpline_84,
l7_.rounding_precision AS rounding_precision_85,
l7_.phone AS phone_86,
l7_.address AS address_87,
l7_.shop_name AS shop_name_88,
l7_.email AS email_89,
l7_.facebook AS facebook_90,
l7_.instagram AS instagram_91,
l7_.youtube AS youtube_92,
l7_.store_url AS store_url_93,
l7_.password_protected AS password_protected_94,
l7_.store_password AS store_password_95,
l7_.fb_pixel AS fb_pixel_96,
l7_.fb_token AS fb_token_97,
l7_.is_comments AS is_comments_98,
l7_.send_comment_request_days AS send_comment_request_days_99,
l7_.store_email AS store_email_100,
l7_.admin_store_email AS admin_store_email_101,
l7_.complaint_email AS complaint_email_102,
l7_.product_return_email AS product_return_email_103,
l7_.getresponse_campaign_id AS getresponse_campaign_id_104,
l7_.created_at AS created_at_105,
l7_.updated_at AS updated_at_106,
l7_.created_by AS created_by_107,
l7_.updated_by AS updated_by_108,
l7_.deleted_by AS deleted_by_109,
c5_.id AS id_110,
c5_.sign AS sign_111,
c5_.currency_separator AS currency_separator_112,
c5_.position_price AS position_price_113,
c5_.is_default AS is_default_114,
c5_.is_active AS is_active_115,
c5_.factorPln AS factorPln_116,
c5_.iso_code AS iso_code_117,
c5_.created_at AS created_at_118,
c5_.updated_at AS updated_at_119,
c5_.created_by AS created_by_120,
c5_.updated_by AS updated_by_121,
c5_.deleted_by AS deleted_by_122,
a8_.id AS id_123,
a8_.is_visible AS is_visible_124,
a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125,
a8_.days AS days_126,
a8_.ceneo_days AS ceneo_days_127,
a8_.internal_name AS internal_name_128,
a8_.created_at AS created_at_129,
a8_.updated_at AS updated_at_130,
a8_.created_by AS created_by_131,
a8_.updated_by AS updated_by_132,
a8_.deleted_by AS deleted_by_133,
a9_.id AS id_134,
a9_.name AS name_135,
a9_.locale AS locale_136,
p10_.id AS id_137,
p10_.name AS name_138,
p10_.responsible_entity AS responsible_entity_139,
p10_.image_name AS image_name_140,
p10_.created_at AS created_at_141,
p10_.updated_at AS updated_at_142,
p10_.created_by AS created_by_143,
p10_.updated_by AS updated_by_144,
p10_.deleted_by AS deleted_by_145,
p3_.id AS id_146,
p3_.main AS main_147,
p3_.lifestyle AS lifestyle_148,
p3_.hover AS hover_149,
p3_.name AS name_150,
p3_.image_name AS image_name_151,
p3_.position AS position_152,
p3_.alt AS alt_153,
p3_.image_custom_name AS image_custom_name_154,
l11_.id AS id_155,
l11_.locale AS locale_156,
l11_.domain AS domain_157,
l11_.is_active AS is_active_158,
l11_.is_default AS is_default_159,
l11_.helpline AS helpline_160,
l11_.rounding_precision AS rounding_precision_161,
l11_.phone AS phone_162,
l11_.address AS address_163,
l11_.shop_name AS shop_name_164,
l11_.email AS email_165,
l11_.facebook AS facebook_166,
l11_.instagram AS instagram_167,
l11_.youtube AS youtube_168,
l11_.store_url AS store_url_169,
l11_.password_protected AS password_protected_170,
l11_.store_password AS store_password_171,
l11_.fb_pixel AS fb_pixel_172,
l11_.fb_token AS fb_token_173,
l11_.is_comments AS is_comments_174,
l11_.send_comment_request_days AS send_comment_request_days_175,
l11_.store_email AS store_email_176,
l11_.admin_store_email AS admin_store_email_177,
l11_.complaint_email AS complaint_email_178,
l11_.product_return_email AS product_return_email_179,
l11_.getresponse_campaign_id AS getresponse_campaign_id_180,
l11_.created_at AS created_at_181,
l11_.updated_at AS updated_at_182,
l11_.created_by AS created_by_183,
l11_.updated_by AS updated_by_184,
l11_.deleted_by AS deleted_by_185,
p12_.id AS id_186,
p12_.price AS price_187,
p12_.discount AS discount_188,
p12_.old_price AS old_price_189,
p12_.active AS active_190,
p12_.automatic_price_comment AS automatic_price_comment_191,
p12_.ean AS ean_192,
p12_.automatic_price AS automatic_price_193,
p12_.automatic_price_discount AS automatic_price_discount_194,
p12_.created_at AS created_at_195,
p12_.updated_at AS updated_at_196,
p12_.created_by AS created_by_197,
p12_.updated_by AS updated_by_198,
p12_.deleted_by AS deleted_by_199,
p0_.product_family_id AS product_family_id_200,
p0_.product_producer_id AS product_producer_id_201,
p0_.availability_id AS availability_id_202,
p0_.main_category_id AS main_category_id_203,
p6_.translatable_id AS translatable_id_204,
p1_.product_id AS product_id_205,
p1_.language AS language_206,
p1_.vat_id AS vat_id_207,
p1_.availability_id AS availability_id_208,
p1_.product_producer_id AS product_producer_id_209,
l7_.currency_id AS currency_id_210,
a9_.translatable_id AS translatable_id_211,
p3_.product_id AS product_id_212,
l11_.currency_id AS currency_id_213,
p12_.product_id AS product_id_214,
p12_.parent_product_price_id AS parent_product_price_id_215,
p12_.currency_id AS currency_id_216,
p12_.language AS language_217
FROM
product p0_
INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id
INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id
INNER JOIN language l7_ ON p1_.language = l7_.id
INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id
INNER JOIN currency c5_ ON l7_.currency_id = c5_.id
INNER JOIN availability a8_ ON p1_.availability_id = a8_.id
INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id
INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id
INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id
LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id
AND (p2_.lifestyle = 1)
INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id
INNER JOIN language l11_ ON l11_.id = p13_.language_id
LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id
LEFT JOIN language l14_ ON p12_.language = l14_.id
INNER JOIN product_category p15_ ON p0_.id = p15_.product_id
LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id
LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id
LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id
WHERE
p6_.locale = ?
AND a9_.locale = ?
AND l14_.locale = ?
AND a8_.deleted_by IS NULL
AND (p3_.main = ?)
AND l11_.locale = ?
AND l7_.locale = ?
AND p12_.deleted_by IS NULL
AND p0_.deleted_by IS NULL
AND p1_.visible = ?
AND p15_.category_id = ?
AND c16_.deleted_by IS NULL
GROUP BY
p0_.id
ORDER BY
p15_.position ASC,
p3_.position ASC
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = 'pl' AND a9_.locale = 'pl' AND l14_.locale = 'pl' AND a8_.deleted_by IS NULL AND (p3_.main = 1) AND l11_.locale = 'pl' AND l7_.locale = 'pl' AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = 1 AND p15_.category_id = 324 AND c16_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC;
|
| 10 |
0.86 ms |
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = ? AND l3_.locale = ? AND p2_.visible = ? AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = ? AND p0_.id IN (?) ORDER BY p2_.position ASC
Parameters: [
"pl"
"pl"
1
"ergonomia"
[
82
]
]
SELECT
p0_.id AS id_0,
p0_.is_filter AS is_filter_1,
p0_.choosable AS choosable_2,
p0_.group_name AS group_name_3,
p0_.simple AS simple_4,
p0_.created_at AS created_at_5,
p0_.updated_at AS updated_at_6,
p0_.created_by AS created_by_7,
p0_.updated_by AS updated_by_8,
p0_.deleted_by AS deleted_by_9,
p1_.id AS id_10,
p1_.name AS name_11,
p1_.locale AS locale_12,
p2_.id AS id_13,
p2_.visible AS visible_14,
p2_.position AS position_15,
l3_.id AS id_16,
l3_.locale AS locale_17,
l3_.domain AS domain_18,
l3_.is_active AS is_active_19,
l3_.is_default AS is_default_20,
l3_.helpline AS helpline_21,
l3_.rounding_precision AS rounding_precision_22,
l3_.phone AS phone_23,
l3_.address AS address_24,
l3_.shop_name AS shop_name_25,
l3_.email AS email_26,
l3_.facebook AS facebook_27,
l3_.instagram AS instagram_28,
l3_.youtube AS youtube_29,
l3_.store_url AS store_url_30,
l3_.password_protected AS password_protected_31,
l3_.store_password AS store_password_32,
l3_.fb_pixel AS fb_pixel_33,
l3_.fb_token AS fb_token_34,
l3_.is_comments AS is_comments_35,
l3_.send_comment_request_days AS send_comment_request_days_36,
l3_.store_email AS store_email_37,
l3_.admin_store_email AS admin_store_email_38,
l3_.complaint_email AS complaint_email_39,
l3_.product_return_email AS product_return_email_40,
l3_.getresponse_campaign_id AS getresponse_campaign_id_41,
l3_.created_at AS created_at_42,
l3_.updated_at AS updated_at_43,
l3_.created_by AS created_by_44,
l3_.updated_by AS updated_by_45,
l3_.deleted_by AS deleted_by_46,
p1_.translatable_id AS translatable_id_47,
p2_.product_parameter_id AS product_parameter_id_48,
p2_.language AS language_49,
l3_.currency_id AS currency_id_50
FROM
product_parameter p0_
INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id
INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id
INNER JOIN language l3_ ON p2_.language = l3_.id
WHERE
p1_.locale = ?
AND l3_.locale = ?
AND p2_.visible = ?
AND p0_.is_filter = 1
AND p0_.deleted_by IS NULL
AND p0_.group_name = ?
AND p0_.id IN (?)
ORDER BY
p2_.position ASC
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = 'pl' AND l3_.locale = 'pl' AND p2_.visible = 1 AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = 'ergonomia' AND p0_.id IN (82) ORDER BY p2_.position ASC;
|
| 11 |
0.36 ms |
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = ? AND l3_.locale = ? AND p2_.visible = ? AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = ? AND p0_.id IN (?) ORDER BY p2_.position ASC
Parameters: [
"pl"
"pl"
1
"funkcje"
[
82
]
]
SELECT
p0_.id AS id_0,
p0_.is_filter AS is_filter_1,
p0_.choosable AS choosable_2,
p0_.group_name AS group_name_3,
p0_.simple AS simple_4,
p0_.created_at AS created_at_5,
p0_.updated_at AS updated_at_6,
p0_.created_by AS created_by_7,
p0_.updated_by AS updated_by_8,
p0_.deleted_by AS deleted_by_9,
p1_.id AS id_10,
p1_.name AS name_11,
p1_.locale AS locale_12,
p2_.id AS id_13,
p2_.visible AS visible_14,
p2_.position AS position_15,
l3_.id AS id_16,
l3_.locale AS locale_17,
l3_.domain AS domain_18,
l3_.is_active AS is_active_19,
l3_.is_default AS is_default_20,
l3_.helpline AS helpline_21,
l3_.rounding_precision AS rounding_precision_22,
l3_.phone AS phone_23,
l3_.address AS address_24,
l3_.shop_name AS shop_name_25,
l3_.email AS email_26,
l3_.facebook AS facebook_27,
l3_.instagram AS instagram_28,
l3_.youtube AS youtube_29,
l3_.store_url AS store_url_30,
l3_.password_protected AS password_protected_31,
l3_.store_password AS store_password_32,
l3_.fb_pixel AS fb_pixel_33,
l3_.fb_token AS fb_token_34,
l3_.is_comments AS is_comments_35,
l3_.send_comment_request_days AS send_comment_request_days_36,
l3_.store_email AS store_email_37,
l3_.admin_store_email AS admin_store_email_38,
l3_.complaint_email AS complaint_email_39,
l3_.product_return_email AS product_return_email_40,
l3_.getresponse_campaign_id AS getresponse_campaign_id_41,
l3_.created_at AS created_at_42,
l3_.updated_at AS updated_at_43,
l3_.created_by AS created_by_44,
l3_.updated_by AS updated_by_45,
l3_.deleted_by AS deleted_by_46,
p1_.translatable_id AS translatable_id_47,
p2_.product_parameter_id AS product_parameter_id_48,
p2_.language AS language_49,
l3_.currency_id AS currency_id_50
FROM
product_parameter p0_
INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id
INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id
INNER JOIN language l3_ ON p2_.language = l3_.id
WHERE
p1_.locale = ?
AND l3_.locale = ?
AND p2_.visible = ?
AND p0_.is_filter = 1
AND p0_.deleted_by IS NULL
AND p0_.group_name = ?
AND p0_.id IN (?)
ORDER BY
p2_.position ASC
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = 'pl' AND l3_.locale = 'pl' AND p2_.visible = 1 AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = 'funkcje' AND p0_.id IN (82) ORDER BY p2_.position ASC;
|
| 12 |
0.53 ms |
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = ? AND l3_.locale = ? AND p2_.visible = ? AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = ? AND p0_.id IN (?) ORDER BY p2_.position ASC
Parameters: [
"pl"
"pl"
1
"wykonanie"
[
82
]
]
SELECT
p0_.id AS id_0,
p0_.is_filter AS is_filter_1,
p0_.choosable AS choosable_2,
p0_.group_name AS group_name_3,
p0_.simple AS simple_4,
p0_.created_at AS created_at_5,
p0_.updated_at AS updated_at_6,
p0_.created_by AS created_by_7,
p0_.updated_by AS updated_by_8,
p0_.deleted_by AS deleted_by_9,
p1_.id AS id_10,
p1_.name AS name_11,
p1_.locale AS locale_12,
p2_.id AS id_13,
p2_.visible AS visible_14,
p2_.position AS position_15,
l3_.id AS id_16,
l3_.locale AS locale_17,
l3_.domain AS domain_18,
l3_.is_active AS is_active_19,
l3_.is_default AS is_default_20,
l3_.helpline AS helpline_21,
l3_.rounding_precision AS rounding_precision_22,
l3_.phone AS phone_23,
l3_.address AS address_24,
l3_.shop_name AS shop_name_25,
l3_.email AS email_26,
l3_.facebook AS facebook_27,
l3_.instagram AS instagram_28,
l3_.youtube AS youtube_29,
l3_.store_url AS store_url_30,
l3_.password_protected AS password_protected_31,
l3_.store_password AS store_password_32,
l3_.fb_pixel AS fb_pixel_33,
l3_.fb_token AS fb_token_34,
l3_.is_comments AS is_comments_35,
l3_.send_comment_request_days AS send_comment_request_days_36,
l3_.store_email AS store_email_37,
l3_.admin_store_email AS admin_store_email_38,
l3_.complaint_email AS complaint_email_39,
l3_.product_return_email AS product_return_email_40,
l3_.getresponse_campaign_id AS getresponse_campaign_id_41,
l3_.created_at AS created_at_42,
l3_.updated_at AS updated_at_43,
l3_.created_by AS created_by_44,
l3_.updated_by AS updated_by_45,
l3_.deleted_by AS deleted_by_46,
p1_.translatable_id AS translatable_id_47,
p2_.product_parameter_id AS product_parameter_id_48,
p2_.language AS language_49,
l3_.currency_id AS currency_id_50
FROM
product_parameter p0_
INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id
INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id
INNER JOIN language l3_ ON p2_.language = l3_.id
WHERE
p1_.locale = ?
AND l3_.locale = ?
AND p2_.visible = ?
AND p0_.is_filter = 1
AND p0_.deleted_by IS NULL
AND p0_.group_name = ?
AND p0_.id IN (?)
ORDER BY
p2_.position ASC
SELECT p0_.id AS id_0, p0_.is_filter AS is_filter_1, p0_.choosable AS choosable_2, p0_.group_name AS group_name_3, p0_.simple AS simple_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.deleted_by AS deleted_by_9, p1_.id AS id_10, p1_.name AS name_11, p1_.locale AS locale_12, p2_.id AS id_13, p2_.visible AS visible_14, p2_.position AS position_15, l3_.id AS id_16, l3_.locale AS locale_17, l3_.domain AS domain_18, l3_.is_active AS is_active_19, l3_.is_default AS is_default_20, l3_.helpline AS helpline_21, l3_.rounding_precision AS rounding_precision_22, l3_.phone AS phone_23, l3_.address AS address_24, l3_.shop_name AS shop_name_25, l3_.email AS email_26, l3_.facebook AS facebook_27, l3_.instagram AS instagram_28, l3_.youtube AS youtube_29, l3_.store_url AS store_url_30, l3_.password_protected AS password_protected_31, l3_.store_password AS store_password_32, l3_.fb_pixel AS fb_pixel_33, l3_.fb_token AS fb_token_34, l3_.is_comments AS is_comments_35, l3_.send_comment_request_days AS send_comment_request_days_36, l3_.store_email AS store_email_37, l3_.admin_store_email AS admin_store_email_38, l3_.complaint_email AS complaint_email_39, l3_.product_return_email AS product_return_email_40, l3_.getresponse_campaign_id AS getresponse_campaign_id_41, l3_.created_at AS created_at_42, l3_.updated_at AS updated_at_43, l3_.created_by AS created_by_44, l3_.updated_by AS updated_by_45, l3_.deleted_by AS deleted_by_46, p1_.translatable_id AS translatable_id_47, p2_.product_parameter_id AS product_parameter_id_48, p2_.language AS language_49, l3_.currency_id AS currency_id_50 FROM product_parameter p0_ INNER JOIN product_parameter_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN product_parameter_lang_param p2_ ON p0_.id = p2_.product_parameter_id INNER JOIN language l3_ ON p2_.language = l3_.id WHERE p1_.locale = 'pl' AND l3_.locale = 'pl' AND p2_.visible = 1 AND p0_.is_filter = 1 AND p0_.deleted_by IS NULL AND p0_.group_name = 'wykonanie' AND p0_.id IN (82) ORDER BY p2_.position ASC;
|
| 13 |
0.20 ms |
SELECT a0_.id AS id_0, a0_.is_visible AS is_visible_1, a0_.is_currentyly_unavailable AS is_currentyly_unavailable_2, a0_.days AS days_3, a0_.ceneo_days AS ceneo_days_4, a0_.internal_name AS internal_name_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.created_by AS created_by_8, a0_.updated_by AS updated_by_9, a0_.deleted_by AS deleted_by_10 FROM availability a0_ INNER JOIN availability_translation a1_ ON a0_.id = a1_.translatable_id WHERE a1_.locale = ? AND a0_.deleted_by IS NULL AND a0_.is_visible = 1
SELECT a0_.id AS id_0, a0_.is_visible AS is_visible_1, a0_.is_currentyly_unavailable AS is_currentyly_unavailable_2, a0_.days AS days_3, a0_.ceneo_days AS ceneo_days_4, a0_.internal_name AS internal_name_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.created_by AS created_by_8, a0_.updated_by AS updated_by_9, a0_.deleted_by AS deleted_by_10 FROM availability a0_ INNER JOIN availability_translation a1_ ON a0_.id = a1_.translatable_id WHERE a1_.locale = 'pl' AND a0_.deleted_by IS NULL AND a0_.is_visible = 1;
|
| 14 |
0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM availability_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM availability_translation t0 WHERE t0.translatable_id = 5;
|
| 15 |
0.42 ms |
SELECT p0_.id AS id_0, p0_.group_name AS group_name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.created_by AS created_by_4, p0_.updated_by AS updated_by_5, p0_.deleted_by AS deleted_by_6 FROM product_color p0_ INNER JOIN product_color_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ? AND p0_.deleted_by IS NULL ORDER BY p1_.name ASC
SELECT p0_.id AS id_0, p0_.group_name AS group_name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.created_by AS created_by_4, p0_.updated_by AS updated_by_5, p0_.deleted_by AS deleted_by_6 FROM product_color p0_ INNER JOIN product_color_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = 'pl' AND p0_.deleted_by IS NULL ORDER BY p1_.name ASC;
|
| 16 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 1;
|
| 17 |
0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 2;
|
| 18 |
0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 5;
|
| 19 |
0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 10;
|
| 20 |
0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 3;
|
| 21 |
0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 11;
|
| 22 |
0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 6;
|
| 23 |
0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 9;
|
| 24 |
0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 12;
|
| 25 |
0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 4;
|
| 26 |
0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 7;
|
| 27 |
0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_color_translation t0 WHERE t0.translatable_id = 8;
|
| 28 |
217.89 ms |
SELECT p0_.promotion_icon AS promotion_icon_0, p0_.is_new AS is_new_1, p1_.image_name AS image_name_2, p0_.bestseller AS bestseller_3, p2_.id AS id_4, c3_.id AS id_5, p0_.price_description AS price_description_6, p4_.id AS id_7, p4_.session AS session_8, p4_.created_at AS created_at_9, p4_.updated_at AS updated_at_10, p5_.id AS id_11, p5_.symbol AS symbol_12, p5_.photo3d AS photo3d_13, p5_.is_variants AS is_variants_14, p5_.is_palette_delivery AS is_palette_delivery_15, p5_.payu AS payu_16, p5_.automatic_price AS automatic_price_17, p5_.halmar_stock_exchange AS halmar_stock_exchange_18, p5_.diablo_stock_exchange AS diablo_stock_exchange_19, p5_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_20, p5_.actona_stock_exchange AS actona_stock_exchange_21, p5_.unique_stock_exchange AS unique_stock_exchange_22, p5_.is_compare AS is_compare_23, p5_.priority_search_engine AS priority_search_engine_24, p5_.is_negotiate AS is_negotiate_25, p5_.is_rebate_code AS is_rebate_code_26, p5_.old_price AS old_price_27, p5_.film AS film_28, p5_.small_product_photo AS small_product_photo_29, p5_.max_quantity AS max_quantity_30, p5_.listingMarkersIds AS listingMarkersIds_31, p5_.temporary_unavailable AS temporary_unavailable_32, p5_.last_ranking_update AS last_ranking_update_33, p5_.height AS height_34, p5_.width AS width_35, p5_.depth AS depth_36, p5_.shipping_category AS shipping_category_37, p5_.created_at AS created_at_38, p5_.updated_at AS updated_at_39, p5_.created_by AS created_by_40, p5_.updated_by AS updated_by_41, p5_.deleted_by AS deleted_by_42, p6_.id AS id_43, p6_.name AS name_44, p6_.description AS description_45, p6_.meta_title AS meta_title_46, p6_.meta_description AS meta_description_47, p6_.meta_keywords AS meta_keywords_48, p6_.slug AS slug_49, p6_.short_description AS short_description_50, p6_.short_description_textile AS short_description_textile_51, p6_.short_description_color AS short_description_color_52, p6_.short_function_description AS short_function_description_53, p6_.search_engine AS search_engine_54, p6_.photo3d_gallery_url AS photo3d_gallery_url_55, p6_.youtube_gallery_url AS youtube_gallery_url_56, p6_.trans_film AS trans_film_57, p6_.canonical AS canonical_58, p6_.photo3d_additional AS photo3d_additional_59, p6_.locale AS locale_60, p0_.id AS id_61, p0_.visible AS visible_62, p0_.price_description AS price_description_63, p0_.promotion AS promotion_64, p0_.is_new AS is_new_65, p0_.bestseller AS bestseller_66, p0_.promote_one_homepage AS promote_one_homepage_67, p0_.ready_for_publication AS ready_for_publication_68, p0_.sale AS sale_69, p0_.rating_value AS rating_value_70, p0_.review_count AS review_count_71, p0_.price_change AS price_change_72, p0_.priority AS priority_73, p0_.price_crossed AS price_crossed_74, p0_.omnibus_price AS omnibus_price_75, p0_.promotion_icon AS promotion_icon_76, p0_.promo_price AS promo_price_77, p7_.id AS id_78, p7_.name AS name_79, p7_.responsible_entity AS responsible_entity_80, p7_.image_name AS image_name_81, p7_.created_at AS created_at_82, p7_.updated_at AS updated_at_83, p7_.created_by AS created_by_84, p7_.updated_by AS updated_by_85, p7_.deleted_by AS deleted_by_86, l8_.id AS id_87, l8_.locale AS locale_88, l8_.domain AS domain_89, l8_.is_active AS is_active_90, l8_.is_default AS is_default_91, l8_.helpline AS helpline_92, l8_.rounding_precision AS rounding_precision_93, l8_.phone AS phone_94, l8_.address AS address_95, l8_.shop_name AS shop_name_96, l8_.email AS email_97, l8_.facebook AS facebook_98, l8_.instagram AS instagram_99, l8_.youtube AS youtube_100, l8_.store_url AS store_url_101, l8_.password_protected AS password_protected_102, l8_.store_password AS store_password_103, l8_.fb_pixel AS fb_pixel_104, l8_.fb_token AS fb_token_105, l8_.is_comments AS is_comments_106, l8_.send_comment_request_days AS send_comment_request_days_107, l8_.store_email AS store_email_108, l8_.admin_store_email AS admin_store_email_109, l8_.complaint_email AS complaint_email_110, l8_.product_return_email AS product_return_email_111, l8_.getresponse_campaign_id AS getresponse_campaign_id_112, l8_.created_at AS created_at_113, l8_.updated_at AS updated_at_114, l8_.created_by AS created_by_115, l8_.updated_by AS updated_by_116, l8_.deleted_by AS deleted_by_117, c3_.id AS id_118, c3_.sign AS sign_119, c3_.currency_separator AS currency_separator_120, c3_.position_price AS position_price_121, c3_.is_default AS is_default_122, c3_.is_active AS is_active_123, c3_.factorPln AS factorPln_124, c3_.iso_code AS iso_code_125, c3_.created_at AS created_at_126, c3_.updated_at AS updated_at_127, c3_.created_by AS created_by_128, c3_.updated_by AS updated_by_129, c3_.deleted_by AS deleted_by_130, a9_.id AS id_131, a9_.is_visible AS is_visible_132, a9_.is_currentyly_unavailable AS is_currentyly_unavailable_133, a9_.days AS days_134, a9_.ceneo_days AS ceneo_days_135, a9_.internal_name AS internal_name_136, a9_.created_at AS created_at_137, a9_.updated_at AS updated_at_138, a9_.created_by AS created_by_139, a9_.updated_by AS updated_by_140, a9_.deleted_by AS deleted_by_141, a10_.id AS id_142, a10_.name AS name_143, a10_.locale AS locale_144, p1_.id AS id_145, p1_.main AS main_146, p1_.lifestyle AS lifestyle_147, p1_.hover AS hover_148, p1_.name AS name_149, p1_.image_name AS image_name_150, p1_.position AS position_151, p1_.alt AS alt_152, p1_.image_custom_name AS image_custom_name_153, l11_.id AS id_154, l11_.locale AS locale_155, l11_.domain AS domain_156, l11_.is_active AS is_active_157, l11_.is_default AS is_default_158, l11_.helpline AS helpline_159, l11_.rounding_precision AS rounding_precision_160, l11_.phone AS phone_161, l11_.address AS address_162, l11_.shop_name AS shop_name_163, l11_.email AS email_164, l11_.facebook AS facebook_165, l11_.instagram AS instagram_166, l11_.youtube AS youtube_167, l11_.store_url AS store_url_168, l11_.password_protected AS password_protected_169, l11_.store_password AS store_password_170, l11_.fb_pixel AS fb_pixel_171, l11_.fb_token AS fb_token_172, l11_.is_comments AS is_comments_173, l11_.send_comment_request_days AS send_comment_request_days_174, l11_.store_email AS store_email_175, l11_.admin_store_email AS admin_store_email_176, l11_.complaint_email AS complaint_email_177, l11_.product_return_email AS product_return_email_178, l11_.getresponse_campaign_id AS getresponse_campaign_id_179, l11_.created_at AS created_at_180, l11_.updated_at AS updated_at_181, l11_.created_by AS created_by_182, l11_.updated_by AS updated_by_183, l11_.deleted_by AS deleted_by_184, p12_.id AS id_185, p12_.price AS price_186, p12_.discount AS discount_187, p12_.old_price AS old_price_188, p12_.active AS active_189, p12_.automatic_price_comment AS automatic_price_comment_190, p12_.ean AS ean_191, p12_.automatic_price AS automatic_price_192, p12_.automatic_price_discount AS automatic_price_discount_193, p12_.created_at AS created_at_194, p12_.updated_at AS updated_at_195, p12_.created_by AS created_by_196, p12_.updated_by AS updated_by_197, p12_.deleted_by AS deleted_by_198, p4_.product_id AS product_id_199, p5_.product_family_id AS product_family_id_200, p5_.product_producer_id AS product_producer_id_201, p5_.availability_id AS availability_id_202, p5_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p0_.product_id AS product_id_205, p0_.language AS language_206, p0_.vat_id AS vat_id_207, p0_.availability_id AS availability_id_208, p0_.product_producer_id AS product_producer_id_209, l8_.currency_id AS currency_id_210, a10_.translatable_id AS translatable_id_211, p1_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product_view p4_ LEFT JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_translation p6_ ON p5_.id = p6_.translatable_id INNER JOIN product_lang_param p0_ ON p5_.id = p0_.product_id LEFT JOIN product_producer p7_ ON p0_.product_producer_id = p7_.id INNER JOIN language l8_ ON p0_.language = l8_.id INNER JOIN product_vat p2_ ON p0_.vat_id = p2_.id INNER JOIN currency c3_ ON l8_.currency_id = c3_.id INNER JOIN availability a9_ ON p0_.availability_id = a9_.id INNER JOIN availability_translation a10_ ON a9_.id = a10_.translatable_id INNER JOIN product_photo p1_ ON p5_.id = p1_.product_id INNER JOIN product_photo_language p13_ ON p1_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p5_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id WHERE p4_.session = ? AND p6_.locale = ? AND a10_.locale = ? AND l14_.locale = ? AND a9_.deleted_by IS NULL AND p1_.main = ? AND l11_.locale = ? AND l8_.locale = ? AND p5_.deleted_by IS NULL AND p0_.visible = ? ORDER BY p4_.id DESC, p1_.position ASC LIMIT 4
Parameters: [
"fa1743b9bb3e51fb90a1e9cf9fcca6e1"
"pl"
"pl"
"pl"
1
"pl"
"pl"
1
]
SELECT
p0_.promotion_icon AS promotion_icon_0,
p0_.is_new AS is_new_1,
p1_.image_name AS image_name_2,
p0_.bestseller AS bestseller_3,
p2_.id AS id_4,
c3_.id AS id_5,
p0_.price_description AS price_description_6,
p4_.id AS id_7,
p4_.session AS session_8,
p4_.created_at AS created_at_9,
p4_.updated_at AS updated_at_10,
p5_.id AS id_11,
p5_.symbol AS symbol_12,
p5_.photo3d AS photo3d_13,
p5_.is_variants AS is_variants_14,
p5_.is_palette_delivery AS is_palette_delivery_15,
p5_.payu AS payu_16,
p5_.automatic_price AS automatic_price_17,
p5_.halmar_stock_exchange AS halmar_stock_exchange_18,
p5_.diablo_stock_exchange AS diablo_stock_exchange_19,
p5_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_20,
p5_.actona_stock_exchange AS actona_stock_exchange_21,
p5_.unique_stock_exchange AS unique_stock_exchange_22,
p5_.is_compare AS is_compare_23,
p5_.priority_search_engine AS priority_search_engine_24,
p5_.is_negotiate AS is_negotiate_25,
p5_.is_rebate_code AS is_rebate_code_26,
p5_.old_price AS old_price_27,
p5_.film AS film_28,
p5_.small_product_photo AS small_product_photo_29,
p5_.max_quantity AS max_quantity_30,
p5_.listingMarkersIds AS listingMarkersIds_31,
p5_.temporary_unavailable AS temporary_unavailable_32,
p5_.last_ranking_update AS last_ranking_update_33,
p5_.height AS height_34,
p5_.width AS width_35,
p5_.depth AS depth_36,
p5_.shipping_category AS shipping_category_37,
p5_.created_at AS created_at_38,
p5_.updated_at AS updated_at_39,
p5_.created_by AS created_by_40,
p5_.updated_by AS updated_by_41,
p5_.deleted_by AS deleted_by_42,
p6_.id AS id_43,
p6_.name AS name_44,
p6_.description AS description_45,
p6_.meta_title AS meta_title_46,
p6_.meta_description AS meta_description_47,
p6_.meta_keywords AS meta_keywords_48,
p6_.slug AS slug_49,
p6_.short_description AS short_description_50,
p6_.short_description_textile AS short_description_textile_51,
p6_.short_description_color AS short_description_color_52,
p6_.short_function_description AS short_function_description_53,
p6_.search_engine AS search_engine_54,
p6_.photo3d_gallery_url AS photo3d_gallery_url_55,
p6_.youtube_gallery_url AS youtube_gallery_url_56,
p6_.trans_film AS trans_film_57,
p6_.canonical AS canonical_58,
p6_.photo3d_additional AS photo3d_additional_59,
p6_.locale AS locale_60,
p0_.id AS id_61,
p0_.visible AS visible_62,
p0_.price_description AS price_description_63,
p0_.promotion AS promotion_64,
p0_.is_new AS is_new_65,
p0_.bestseller AS bestseller_66,
p0_.promote_one_homepage AS promote_one_homepage_67,
p0_.ready_for_publication AS ready_for_publication_68,
p0_.sale AS sale_69,
p0_.rating_value AS rating_value_70,
p0_.review_count AS review_count_71,
p0_.price_change AS price_change_72,
p0_.priority AS priority_73,
p0_.price_crossed AS price_crossed_74,
p0_.omnibus_price AS omnibus_price_75,
p0_.promotion_icon AS promotion_icon_76,
p0_.promo_price AS promo_price_77,
p7_.id AS id_78,
p7_.name AS name_79,
p7_.responsible_entity AS responsible_entity_80,
p7_.image_name AS image_name_81,
p7_.created_at AS created_at_82,
p7_.updated_at AS updated_at_83,
p7_.created_by AS created_by_84,
p7_.updated_by AS updated_by_85,
p7_.deleted_by AS deleted_by_86,
l8_.id AS id_87,
l8_.locale AS locale_88,
l8_.domain AS domain_89,
l8_.is_active AS is_active_90,
l8_.is_default AS is_default_91,
l8_.helpline AS helpline_92,
l8_.rounding_precision AS rounding_precision_93,
l8_.phone AS phone_94,
l8_.address AS address_95,
l8_.shop_name AS shop_name_96,
l8_.email AS email_97,
l8_.facebook AS facebook_98,
l8_.instagram AS instagram_99,
l8_.youtube AS youtube_100,
l8_.store_url AS store_url_101,
l8_.password_protected AS password_protected_102,
l8_.store_password AS store_password_103,
l8_.fb_pixel AS fb_pixel_104,
l8_.fb_token AS fb_token_105,
l8_.is_comments AS is_comments_106,
l8_.send_comment_request_days AS send_comment_request_days_107,
l8_.store_email AS store_email_108,
l8_.admin_store_email AS admin_store_email_109,
l8_.complaint_email AS complaint_email_110,
l8_.product_return_email AS product_return_email_111,
l8_.getresponse_campaign_id AS getresponse_campaign_id_112,
l8_.created_at AS created_at_113,
l8_.updated_at AS updated_at_114,
l8_.created_by AS created_by_115,
l8_.updated_by AS updated_by_116,
l8_.deleted_by AS deleted_by_117,
c3_.id AS id_118,
c3_.sign AS sign_119,
c3_.currency_separator AS currency_separator_120,
c3_.position_price AS position_price_121,
c3_.is_default AS is_default_122,
c3_.is_active AS is_active_123,
c3_.factorPln AS factorPln_124,
c3_.iso_code AS iso_code_125,
c3_.created_at AS created_at_126,
c3_.updated_at AS updated_at_127,
c3_.created_by AS created_by_128,
c3_.updated_by AS updated_by_129,
c3_.deleted_by AS deleted_by_130,
a9_.id AS id_131,
a9_.is_visible AS is_visible_132,
a9_.is_currentyly_unavailable AS is_currentyly_unavailable_133,
a9_.days AS days_134,
a9_.ceneo_days AS ceneo_days_135,
a9_.internal_name AS internal_name_136,
a9_.created_at AS created_at_137,
a9_.updated_at AS updated_at_138,
a9_.created_by AS created_by_139,
a9_.updated_by AS updated_by_140,
a9_.deleted_by AS deleted_by_141,
a10_.id AS id_142,
a10_.name AS name_143,
a10_.locale AS locale_144,
p1_.id AS id_145,
p1_.main AS main_146,
p1_.lifestyle AS lifestyle_147,
p1_.hover AS hover_148,
p1_.name AS name_149,
p1_.image_name AS image_name_150,
p1_.position AS position_151,
p1_.alt AS alt_152,
p1_.image_custom_name AS image_custom_name_153,
l11_.id AS id_154,
l11_.locale AS locale_155,
l11_.domain AS domain_156,
l11_.is_active AS is_active_157,
l11_.is_default AS is_default_158,
l11_.helpline AS helpline_159,
l11_.rounding_precision AS rounding_precision_160,
l11_.phone AS phone_161,
l11_.address AS address_162,
l11_.shop_name AS shop_name_163,
l11_.email AS email_164,
l11_.facebook AS facebook_165,
l11_.instagram AS instagram_166,
l11_.youtube AS youtube_167,
l11_.store_url AS store_url_168,
l11_.password_protected AS password_protected_169,
l11_.store_password AS store_password_170,
l11_.fb_pixel AS fb_pixel_171,
l11_.fb_token AS fb_token_172,
l11_.is_comments AS is_comments_173,
l11_.send_comment_request_days AS send_comment_request_days_174,
l11_.store_email AS store_email_175,
l11_.admin_store_email AS admin_store_email_176,
l11_.complaint_email AS complaint_email_177,
l11_.product_return_email AS product_return_email_178,
l11_.getresponse_campaign_id AS getresponse_campaign_id_179,
l11_.created_at AS created_at_180,
l11_.updated_at AS updated_at_181,
l11_.created_by AS created_by_182,
l11_.updated_by AS updated_by_183,
l11_.deleted_by AS deleted_by_184,
p12_.id AS id_185,
p12_.price AS price_186,
p12_.discount AS discount_187,
p12_.old_price AS old_price_188,
p12_.active AS active_189,
p12_.automatic_price_comment AS automatic_price_comment_190,
p12_.ean AS ean_191,
p12_.automatic_price AS automatic_price_192,
p12_.automatic_price_discount AS automatic_price_discount_193,
p12_.created_at AS created_at_194,
p12_.updated_at AS updated_at_195,
p12_.created_by AS created_by_196,
p12_.updated_by AS updated_by_197,
p12_.deleted_by AS deleted_by_198,
p4_.product_id AS product_id_199,
p5_.product_family_id AS product_family_id_200,
p5_.product_producer_id AS product_producer_id_201,
p5_.availability_id AS availability_id_202,
p5_.main_category_id AS main_category_id_203,
p6_.translatable_id AS translatable_id_204,
p0_.product_id AS product_id_205,
p0_.language AS language_206,
p0_.vat_id AS vat_id_207,
p0_.availability_id AS availability_id_208,
p0_.product_producer_id AS product_producer_id_209,
l8_.currency_id AS currency_id_210,
a10_.translatable_id AS translatable_id_211,
p1_.product_id AS product_id_212,
l11_.currency_id AS currency_id_213,
p12_.product_id AS product_id_214,
p12_.parent_product_price_id AS parent_product_price_id_215,
p12_.currency_id AS currency_id_216,
p12_.language AS language_217
FROM
product_view p4_
LEFT JOIN product p5_ ON p4_.product_id = p5_.id
INNER JOIN product_translation p6_ ON p5_.id = p6_.translatable_id
INNER JOIN product_lang_param p0_ ON p5_.id = p0_.product_id
LEFT JOIN product_producer p7_ ON p0_.product_producer_id = p7_.id
INNER JOIN language l8_ ON p0_.language = l8_.id
INNER JOIN product_vat p2_ ON p0_.vat_id = p2_.id
INNER JOIN currency c3_ ON l8_.currency_id = c3_.id
INNER JOIN availability a9_ ON p0_.availability_id = a9_.id
INNER JOIN availability_translation a10_ ON a9_.id = a10_.translatable_id
INNER JOIN product_photo p1_ ON p5_.id = p1_.product_id
INNER JOIN product_photo_language p13_ ON p1_.id = p13_.product_photo_id
INNER JOIN language l11_ ON l11_.id = p13_.language_id
LEFT JOIN product_price p12_ ON p5_.id = p12_.product_id
LEFT JOIN language l14_ ON p12_.language = l14_.id
WHERE
p4_.session = ?
AND p6_.locale = ?
AND a10_.locale = ?
AND l14_.locale = ?
AND a9_.deleted_by IS NULL
AND p1_.main = ?
AND l11_.locale = ?
AND l8_.locale = ?
AND p5_.deleted_by IS NULL
AND p0_.visible = ?
ORDER BY
p4_.id DESC,
p1_.position ASC
LIMIT
4
SELECT p0_.promotion_icon AS promotion_icon_0, p0_.is_new AS is_new_1, p1_.image_name AS image_name_2, p0_.bestseller AS bestseller_3, p2_.id AS id_4, c3_.id AS id_5, p0_.price_description AS price_description_6, p4_.id AS id_7, p4_.session AS session_8, p4_.created_at AS created_at_9, p4_.updated_at AS updated_at_10, p5_.id AS id_11, p5_.symbol AS symbol_12, p5_.photo3d AS photo3d_13, p5_.is_variants AS is_variants_14, p5_.is_palette_delivery AS is_palette_delivery_15, p5_.payu AS payu_16, p5_.automatic_price AS automatic_price_17, p5_.halmar_stock_exchange AS halmar_stock_exchange_18, p5_.diablo_stock_exchange AS diablo_stock_exchange_19, p5_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_20, p5_.actona_stock_exchange AS actona_stock_exchange_21, p5_.unique_stock_exchange AS unique_stock_exchange_22, p5_.is_compare AS is_compare_23, p5_.priority_search_engine AS priority_search_engine_24, p5_.is_negotiate AS is_negotiate_25, p5_.is_rebate_code AS is_rebate_code_26, p5_.old_price AS old_price_27, p5_.film AS film_28, p5_.small_product_photo AS small_product_photo_29, p5_.max_quantity AS max_quantity_30, p5_.listingMarkersIds AS listingMarkersIds_31, p5_.temporary_unavailable AS temporary_unavailable_32, p5_.last_ranking_update AS last_ranking_update_33, p5_.height AS height_34, p5_.width AS width_35, p5_.depth AS depth_36, p5_.shipping_category AS shipping_category_37, p5_.created_at AS created_at_38, p5_.updated_at AS updated_at_39, p5_.created_by AS created_by_40, p5_.updated_by AS updated_by_41, p5_.deleted_by AS deleted_by_42, p6_.id AS id_43, p6_.name AS name_44, p6_.description AS description_45, p6_.meta_title AS meta_title_46, p6_.meta_description AS meta_description_47, p6_.meta_keywords AS meta_keywords_48, p6_.slug AS slug_49, p6_.short_description AS short_description_50, p6_.short_description_textile AS short_description_textile_51, p6_.short_description_color AS short_description_color_52, p6_.short_function_description AS short_function_description_53, p6_.search_engine AS search_engine_54, p6_.photo3d_gallery_url AS photo3d_gallery_url_55, p6_.youtube_gallery_url AS youtube_gallery_url_56, p6_.trans_film AS trans_film_57, p6_.canonical AS canonical_58, p6_.photo3d_additional AS photo3d_additional_59, p6_.locale AS locale_60, p0_.id AS id_61, p0_.visible AS visible_62, p0_.price_description AS price_description_63, p0_.promotion AS promotion_64, p0_.is_new AS is_new_65, p0_.bestseller AS bestseller_66, p0_.promote_one_homepage AS promote_one_homepage_67, p0_.ready_for_publication AS ready_for_publication_68, p0_.sale AS sale_69, p0_.rating_value AS rating_value_70, p0_.review_count AS review_count_71, p0_.price_change AS price_change_72, p0_.priority AS priority_73, p0_.price_crossed AS price_crossed_74, p0_.omnibus_price AS omnibus_price_75, p0_.promotion_icon AS promotion_icon_76, p0_.promo_price AS promo_price_77, p7_.id AS id_78, p7_.name AS name_79, p7_.responsible_entity AS responsible_entity_80, p7_.image_name AS image_name_81, p7_.created_at AS created_at_82, p7_.updated_at AS updated_at_83, p7_.created_by AS created_by_84, p7_.updated_by AS updated_by_85, p7_.deleted_by AS deleted_by_86, l8_.id AS id_87, l8_.locale AS locale_88, l8_.domain AS domain_89, l8_.is_active AS is_active_90, l8_.is_default AS is_default_91, l8_.helpline AS helpline_92, l8_.rounding_precision AS rounding_precision_93, l8_.phone AS phone_94, l8_.address AS address_95, l8_.shop_name AS shop_name_96, l8_.email AS email_97, l8_.facebook AS facebook_98, l8_.instagram AS instagram_99, l8_.youtube AS youtube_100, l8_.store_url AS store_url_101, l8_.password_protected AS password_protected_102, l8_.store_password AS store_password_103, l8_.fb_pixel AS fb_pixel_104, l8_.fb_token AS fb_token_105, l8_.is_comments AS is_comments_106, l8_.send_comment_request_days AS send_comment_request_days_107, l8_.store_email AS store_email_108, l8_.admin_store_email AS admin_store_email_109, l8_.complaint_email AS complaint_email_110, l8_.product_return_email AS product_return_email_111, l8_.getresponse_campaign_id AS getresponse_campaign_id_112, l8_.created_at AS created_at_113, l8_.updated_at AS updated_at_114, l8_.created_by AS created_by_115, l8_.updated_by AS updated_by_116, l8_.deleted_by AS deleted_by_117, c3_.id AS id_118, c3_.sign AS sign_119, c3_.currency_separator AS currency_separator_120, c3_.position_price AS position_price_121, c3_.is_default AS is_default_122, c3_.is_active AS is_active_123, c3_.factorPln AS factorPln_124, c3_.iso_code AS iso_code_125, c3_.created_at AS created_at_126, c3_.updated_at AS updated_at_127, c3_.created_by AS created_by_128, c3_.updated_by AS updated_by_129, c3_.deleted_by AS deleted_by_130, a9_.id AS id_131, a9_.is_visible AS is_visible_132, a9_.is_currentyly_unavailable AS is_currentyly_unavailable_133, a9_.days AS days_134, a9_.ceneo_days AS ceneo_days_135, a9_.internal_name AS internal_name_136, a9_.created_at AS created_at_137, a9_.updated_at AS updated_at_138, a9_.created_by AS created_by_139, a9_.updated_by AS updated_by_140, a9_.deleted_by AS deleted_by_141, a10_.id AS id_142, a10_.name AS name_143, a10_.locale AS locale_144, p1_.id AS id_145, p1_.main AS main_146, p1_.lifestyle AS lifestyle_147, p1_.hover AS hover_148, p1_.name AS name_149, p1_.image_name AS image_name_150, p1_.position AS position_151, p1_.alt AS alt_152, p1_.image_custom_name AS image_custom_name_153, l11_.id AS id_154, l11_.locale AS locale_155, l11_.domain AS domain_156, l11_.is_active AS is_active_157, l11_.is_default AS is_default_158, l11_.helpline AS helpline_159, l11_.rounding_precision AS rounding_precision_160, l11_.phone AS phone_161, l11_.address AS address_162, l11_.shop_name AS shop_name_163, l11_.email AS email_164, l11_.facebook AS facebook_165, l11_.instagram AS instagram_166, l11_.youtube AS youtube_167, l11_.store_url AS store_url_168, l11_.password_protected AS password_protected_169, l11_.store_password AS store_password_170, l11_.fb_pixel AS fb_pixel_171, l11_.fb_token AS fb_token_172, l11_.is_comments AS is_comments_173, l11_.send_comment_request_days AS send_comment_request_days_174, l11_.store_email AS store_email_175, l11_.admin_store_email AS admin_store_email_176, l11_.complaint_email AS complaint_email_177, l11_.product_return_email AS product_return_email_178, l11_.getresponse_campaign_id AS getresponse_campaign_id_179, l11_.created_at AS created_at_180, l11_.updated_at AS updated_at_181, l11_.created_by AS created_by_182, l11_.updated_by AS updated_by_183, l11_.deleted_by AS deleted_by_184, p12_.id AS id_185, p12_.price AS price_186, p12_.discount AS discount_187, p12_.old_price AS old_price_188, p12_.active AS active_189, p12_.automatic_price_comment AS automatic_price_comment_190, p12_.ean AS ean_191, p12_.automatic_price AS automatic_price_192, p12_.automatic_price_discount AS automatic_price_discount_193, p12_.created_at AS created_at_194, p12_.updated_at AS updated_at_195, p12_.created_by AS created_by_196, p12_.updated_by AS updated_by_197, p12_.deleted_by AS deleted_by_198, p4_.product_id AS product_id_199, p5_.product_family_id AS product_family_id_200, p5_.product_producer_id AS product_producer_id_201, p5_.availability_id AS availability_id_202, p5_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p0_.product_id AS product_id_205, p0_.language AS language_206, p0_.vat_id AS vat_id_207, p0_.availability_id AS availability_id_208, p0_.product_producer_id AS product_producer_id_209, l8_.currency_id AS currency_id_210, a10_.translatable_id AS translatable_id_211, p1_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product_view p4_ LEFT JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_translation p6_ ON p5_.id = p6_.translatable_id INNER JOIN product_lang_param p0_ ON p5_.id = p0_.product_id LEFT JOIN product_producer p7_ ON p0_.product_producer_id = p7_.id INNER JOIN language l8_ ON p0_.language = l8_.id INNER JOIN product_vat p2_ ON p0_.vat_id = p2_.id INNER JOIN currency c3_ ON l8_.currency_id = c3_.id INNER JOIN availability a9_ ON p0_.availability_id = a9_.id INNER JOIN availability_translation a10_ ON a9_.id = a10_.translatable_id INNER JOIN product_photo p1_ ON p5_.id = p1_.product_id INNER JOIN product_photo_language p13_ ON p1_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p5_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id WHERE p4_.session = 'fa1743b9bb3e51fb90a1e9cf9fcca6e1' AND p6_.locale = 'pl' AND a10_.locale = 'pl' AND l14_.locale = 'pl' AND a9_.deleted_by IS NULL AND p1_.main = 1 AND l11_.locale = 'pl' AND l8_.locale = 'pl' AND p5_.deleted_by IS NULL AND p0_.visible = 1 ORDER BY p4_.id DESC, p1_.position ASC LIMIT 4;
|
| 29 |
15.64 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = ? AND a9_.locale = ? AND l14_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p15_.category_id = ? AND c16_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC) dctrn_table
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
1
324
]
SELECT
COUNT(*) AS dctrn_count
FROM
(
SELECT
p0_.listingMarkersIds AS listingMarkersIds_0,
p1_.promotion_icon AS promotion_icon_1,
p1_.is_new AS is_new_2,
p2_.image_name AS image_name_3,
p3_.image_name AS image_name_4,
p1_.bestseller AS bestseller_5,
p4_.id AS id_6,
c5_.sign AS sign_7,
c5_.id AS id_8,
p1_.price_description AS price_description_9,
p1_.price_crossed AS price_crossed_10,
p1_.omnibus_price AS omnibus_price_11,
p0_.id AS id_12,
p0_.symbol AS symbol_13,
p0_.photo3d AS photo3d_14,
p0_.is_variants AS is_variants_15,
p0_.is_palette_delivery AS is_palette_delivery_16,
p0_.payu AS payu_17,
p0_.automatic_price AS automatic_price_18,
p0_.halmar_stock_exchange AS halmar_stock_exchange_19,
p0_.diablo_stock_exchange AS diablo_stock_exchange_20,
p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21,
p0_.actona_stock_exchange AS actona_stock_exchange_22,
p0_.unique_stock_exchange AS unique_stock_exchange_23,
p0_.is_compare AS is_compare_24,
p0_.priority_search_engine AS priority_search_engine_25,
p0_.is_negotiate AS is_negotiate_26,
p0_.is_rebate_code AS is_rebate_code_27,
p0_.old_price AS old_price_28,
p0_.film AS film_29,
p0_.small_product_photo AS small_product_photo_30,
p0_.max_quantity AS max_quantity_31,
p0_.listingMarkersIds AS listingMarkersIds_32,
p0_.temporary_unavailable AS temporary_unavailable_33,
p0_.last_ranking_update AS last_ranking_update_34,
p0_.height AS height_35,
p0_.width AS width_36,
p0_.depth AS depth_37,
p0_.shipping_category AS shipping_category_38,
p0_.created_at AS created_at_39,
p0_.updated_at AS updated_at_40,
p0_.created_by AS created_by_41,
p0_.updated_by AS updated_by_42,
p0_.deleted_by AS deleted_by_43,
p6_.id AS id_44,
p6_.name AS name_45,
p6_.description AS description_46,
p6_.meta_title AS meta_title_47,
p6_.meta_description AS meta_description_48,
p6_.meta_keywords AS meta_keywords_49,
p6_.slug AS slug_50,
p6_.short_description AS short_description_51,
p6_.short_description_textile AS short_description_textile_52,
p6_.short_description_color AS short_description_color_53,
p6_.short_function_description AS short_function_description_54,
p6_.search_engine AS search_engine_55,
p6_.photo3d_gallery_url AS photo3d_gallery_url_56,
p6_.youtube_gallery_url AS youtube_gallery_url_57,
p6_.trans_film AS trans_film_58,
p6_.canonical AS canonical_59,
p6_.photo3d_additional AS photo3d_additional_60,
p6_.locale AS locale_61,
p1_.id AS id_62,
p1_.visible AS visible_63,
p1_.price_description AS price_description_64,
p1_.promotion AS promotion_65,
p1_.is_new AS is_new_66,
p1_.bestseller AS bestseller_67,
p1_.promote_one_homepage AS promote_one_homepage_68,
p1_.ready_for_publication AS ready_for_publication_69,
p1_.sale AS sale_70,
p1_.rating_value AS rating_value_71,
p1_.review_count AS review_count_72,
p1_.price_change AS price_change_73,
p1_.priority AS priority_74,
p1_.price_crossed AS price_crossed_75,
p1_.omnibus_price AS omnibus_price_76,
p1_.promotion_icon AS promotion_icon_77,
p1_.promo_price AS promo_price_78,
l7_.id AS id_79,
l7_.locale AS locale_80,
l7_.domain AS domain_81,
l7_.is_active AS is_active_82,
l7_.is_default AS is_default_83,
l7_.helpline AS helpline_84,
l7_.rounding_precision AS rounding_precision_85,
l7_.phone AS phone_86,
l7_.address AS address_87,
l7_.shop_name AS shop_name_88,
l7_.email AS email_89,
l7_.facebook AS facebook_90,
l7_.instagram AS instagram_91,
l7_.youtube AS youtube_92,
l7_.store_url AS store_url_93,
l7_.password_protected AS password_protected_94,
l7_.store_password AS store_password_95,
l7_.fb_pixel AS fb_pixel_96,
l7_.fb_token AS fb_token_97,
l7_.is_comments AS is_comments_98,
l7_.send_comment_request_days AS send_comment_request_days_99,
l7_.store_email AS store_email_100,
l7_.admin_store_email AS admin_store_email_101,
l7_.complaint_email AS complaint_email_102,
l7_.product_return_email AS product_return_email_103,
l7_.getresponse_campaign_id AS getresponse_campaign_id_104,
l7_.created_at AS created_at_105,
l7_.updated_at AS updated_at_106,
l7_.created_by AS created_by_107,
l7_.updated_by AS updated_by_108,
l7_.deleted_by AS deleted_by_109,
c5_.id AS id_110,
c5_.sign AS sign_111,
c5_.currency_separator AS currency_separator_112,
c5_.position_price AS position_price_113,
c5_.is_default AS is_default_114,
c5_.is_active AS is_active_115,
c5_.factorPln AS factorPln_116,
c5_.iso_code AS iso_code_117,
c5_.created_at AS created_at_118,
c5_.updated_at AS updated_at_119,
c5_.created_by AS created_by_120,
c5_.updated_by AS updated_by_121,
c5_.deleted_by AS deleted_by_122,
a8_.id AS id_123,
a8_.is_visible AS is_visible_124,
a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125,
a8_.days AS days_126,
a8_.ceneo_days AS ceneo_days_127,
a8_.internal_name AS internal_name_128,
a8_.created_at AS created_at_129,
a8_.updated_at AS updated_at_130,
a8_.created_by AS created_by_131,
a8_.updated_by AS updated_by_132,
a8_.deleted_by AS deleted_by_133,
a9_.id AS id_134,
a9_.name AS name_135,
a9_.locale AS locale_136,
p10_.id AS id_137,
p10_.name AS name_138,
p10_.responsible_entity AS responsible_entity_139,
p10_.image_name AS image_name_140,
p10_.created_at AS created_at_141,
p10_.updated_at AS updated_at_142,
p10_.created_by AS created_by_143,
p10_.updated_by AS updated_by_144,
p10_.deleted_by AS deleted_by_145,
p3_.id AS id_146,
p3_.main AS main_147,
p3_.lifestyle AS lifestyle_148,
p3_.hover AS hover_149,
p3_.name AS name_150,
p3_.image_name AS image_name_151,
p3_.position AS position_152,
p3_.alt AS alt_153,
p3_.image_custom_name AS image_custom_name_154,
l11_.id AS id_155,
l11_.locale AS locale_156,
l11_.domain AS domain_157,
l11_.is_active AS is_active_158,
l11_.is_default AS is_default_159,
l11_.helpline AS helpline_160,
l11_.rounding_precision AS rounding_precision_161,
l11_.phone AS phone_162,
l11_.address AS address_163,
l11_.shop_name AS shop_name_164,
l11_.email AS email_165,
l11_.facebook AS facebook_166,
l11_.instagram AS instagram_167,
l11_.youtube AS youtube_168,
l11_.store_url AS store_url_169,
l11_.password_protected AS password_protected_170,
l11_.store_password AS store_password_171,
l11_.fb_pixel AS fb_pixel_172,
l11_.fb_token AS fb_token_173,
l11_.is_comments AS is_comments_174,
l11_.send_comment_request_days AS send_comment_request_days_175,
l11_.store_email AS store_email_176,
l11_.admin_store_email AS admin_store_email_177,
l11_.complaint_email AS complaint_email_178,
l11_.product_return_email AS product_return_email_179,
l11_.getresponse_campaign_id AS getresponse_campaign_id_180,
l11_.created_at AS created_at_181,
l11_.updated_at AS updated_at_182,
l11_.created_by AS created_by_183,
l11_.updated_by AS updated_by_184,
l11_.deleted_by AS deleted_by_185,
p12_.id AS id_186,
p12_.price AS price_187,
p12_.discount AS discount_188,
p12_.old_price AS old_price_189,
p12_.active AS active_190,
p12_.automatic_price_comment AS automatic_price_comment_191,
p12_.ean AS ean_192,
p12_.automatic_price AS automatic_price_193,
p12_.automatic_price_discount AS automatic_price_discount_194,
p12_.created_at AS created_at_195,
p12_.updated_at AS updated_at_196,
p12_.created_by AS created_by_197,
p12_.updated_by AS updated_by_198,
p12_.deleted_by AS deleted_by_199
FROM
product p0_
INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id
INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id
INNER JOIN language l7_ ON p1_.language = l7_.id
INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id
INNER JOIN currency c5_ ON l7_.currency_id = c5_.id
INNER JOIN availability a8_ ON p1_.availability_id = a8_.id
INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id
INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id
INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id
LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id
AND (p2_.lifestyle = 1)
INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id
INNER JOIN language l11_ ON l11_.id = p13_.language_id
LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id
LEFT JOIN language l14_ ON p12_.language = l14_.id
INNER JOIN product_category p15_ ON p0_.id = p15_.product_id
LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id
LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id
LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id
WHERE
p6_.locale = ?
AND a9_.locale = ?
AND l14_.locale = ?
AND a8_.deleted_by IS NULL
AND (p3_.main = ?)
AND l11_.locale = ?
AND l7_.locale = ?
AND p12_.deleted_by IS NULL
AND p0_.deleted_by IS NULL
AND p1_.visible = ?
AND p15_.category_id = ?
AND c16_.deleted_by IS NULL
GROUP BY
p0_.id
ORDER BY
p15_.position ASC,
p3_.position ASC
) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = 'pl' AND a9_.locale = 'pl' AND l14_.locale = 'pl' AND a8_.deleted_by IS NULL AND (p3_.main = 1) AND l11_.locale = 'pl' AND l7_.locale = 'pl' AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = 1 AND p15_.category_id = 324 AND c16_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC) dctrn_table;
|
| 30 |
15.93 ms |
SELECT DISTINCT id_12 FROM (SELECT DISTINCT id_12, position_202 FROM (SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p2_.lifestyle AS lifestyle_200, l13_.locale AS locale_201, p14_.position AS position_202, c15_.deleted_by AS deleted_by_203 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p16_ ON p3_.id = p16_.product_photo_id INNER JOIN language l11_ ON l11_.id = p16_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l13_ ON p12_.language = l13_.id INNER JOIN product_category p14_ ON p0_.id = p14_.product_id LEFT JOIN category c15_ ON p0_.main_category_id = c15_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = ? AND a9_.locale = ? AND l13_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p14_.category_id = ? AND c15_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p3_.position ASC, p2_.position ASC) dctrn_result_inner ORDER BY position_202 ASC) dctrn_result LIMIT 30
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
1
324
]
SELECT
DISTINCT id_12
FROM
(
SELECT
DISTINCT id_12,
position_202
FROM
(
SELECT
p0_.listingMarkersIds AS listingMarkersIds_0,
p1_.promotion_icon AS promotion_icon_1,
p1_.is_new AS is_new_2,
p2_.image_name AS image_name_3,
p3_.image_name AS image_name_4,
p1_.bestseller AS bestseller_5,
p4_.id AS id_6,
c5_.sign AS sign_7,
c5_.id AS id_8,
p1_.price_description AS price_description_9,
p1_.price_crossed AS price_crossed_10,
p1_.omnibus_price AS omnibus_price_11,
p0_.id AS id_12,
p0_.symbol AS symbol_13,
p0_.photo3d AS photo3d_14,
p0_.is_variants AS is_variants_15,
p0_.is_palette_delivery AS is_palette_delivery_16,
p0_.payu AS payu_17,
p0_.automatic_price AS automatic_price_18,
p0_.halmar_stock_exchange AS halmar_stock_exchange_19,
p0_.diablo_stock_exchange AS diablo_stock_exchange_20,
p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21,
p0_.actona_stock_exchange AS actona_stock_exchange_22,
p0_.unique_stock_exchange AS unique_stock_exchange_23,
p0_.is_compare AS is_compare_24,
p0_.priority_search_engine AS priority_search_engine_25,
p0_.is_negotiate AS is_negotiate_26,
p0_.is_rebate_code AS is_rebate_code_27,
p0_.old_price AS old_price_28,
p0_.film AS film_29,
p0_.small_product_photo AS small_product_photo_30,
p0_.max_quantity AS max_quantity_31,
p0_.listingMarkersIds AS listingMarkersIds_32,
p0_.temporary_unavailable AS temporary_unavailable_33,
p0_.last_ranking_update AS last_ranking_update_34,
p0_.height AS height_35,
p0_.width AS width_36,
p0_.depth AS depth_37,
p0_.shipping_category AS shipping_category_38,
p0_.created_at AS created_at_39,
p0_.updated_at AS updated_at_40,
p0_.created_by AS created_by_41,
p0_.updated_by AS updated_by_42,
p0_.deleted_by AS deleted_by_43,
p6_.id AS id_44,
p6_.name AS name_45,
p6_.description AS description_46,
p6_.meta_title AS meta_title_47,
p6_.meta_description AS meta_description_48,
p6_.meta_keywords AS meta_keywords_49,
p6_.slug AS slug_50,
p6_.short_description AS short_description_51,
p6_.short_description_textile AS short_description_textile_52,
p6_.short_description_color AS short_description_color_53,
p6_.short_function_description AS short_function_description_54,
p6_.search_engine AS search_engine_55,
p6_.photo3d_gallery_url AS photo3d_gallery_url_56,
p6_.youtube_gallery_url AS youtube_gallery_url_57,
p6_.trans_film AS trans_film_58,
p6_.canonical AS canonical_59,
p6_.photo3d_additional AS photo3d_additional_60,
p6_.locale AS locale_61,
p1_.id AS id_62,
p1_.visible AS visible_63,
p1_.price_description AS price_description_64,
p1_.promotion AS promotion_65,
p1_.is_new AS is_new_66,
p1_.bestseller AS bestseller_67,
p1_.promote_one_homepage AS promote_one_homepage_68,
p1_.ready_for_publication AS ready_for_publication_69,
p1_.sale AS sale_70,
p1_.rating_value AS rating_value_71,
p1_.review_count AS review_count_72,
p1_.price_change AS price_change_73,
p1_.priority AS priority_74,
p1_.price_crossed AS price_crossed_75,
p1_.omnibus_price AS omnibus_price_76,
p1_.promotion_icon AS promotion_icon_77,
p1_.promo_price AS promo_price_78,
l7_.id AS id_79,
l7_.locale AS locale_80,
l7_.domain AS domain_81,
l7_.is_active AS is_active_82,
l7_.is_default AS is_default_83,
l7_.helpline AS helpline_84,
l7_.rounding_precision AS rounding_precision_85,
l7_.phone AS phone_86,
l7_.address AS address_87,
l7_.shop_name AS shop_name_88,
l7_.email AS email_89,
l7_.facebook AS facebook_90,
l7_.instagram AS instagram_91,
l7_.youtube AS youtube_92,
l7_.store_url AS store_url_93,
l7_.password_protected AS password_protected_94,
l7_.store_password AS store_password_95,
l7_.fb_pixel AS fb_pixel_96,
l7_.fb_token AS fb_token_97,
l7_.is_comments AS is_comments_98,
l7_.send_comment_request_days AS send_comment_request_days_99,
l7_.store_email AS store_email_100,
l7_.admin_store_email AS admin_store_email_101,
l7_.complaint_email AS complaint_email_102,
l7_.product_return_email AS product_return_email_103,
l7_.getresponse_campaign_id AS getresponse_campaign_id_104,
l7_.created_at AS created_at_105,
l7_.updated_at AS updated_at_106,
l7_.created_by AS created_by_107,
l7_.updated_by AS updated_by_108,
l7_.deleted_by AS deleted_by_109,
c5_.id AS id_110,
c5_.sign AS sign_111,
c5_.currency_separator AS currency_separator_112,
c5_.position_price AS position_price_113,
c5_.is_default AS is_default_114,
c5_.is_active AS is_active_115,
c5_.factorPln AS factorPln_116,
c5_.iso_code AS iso_code_117,
c5_.created_at AS created_at_118,
c5_.updated_at AS updated_at_119,
c5_.created_by AS created_by_120,
c5_.updated_by AS updated_by_121,
c5_.deleted_by AS deleted_by_122,
a8_.id AS id_123,
a8_.is_visible AS is_visible_124,
a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125,
a8_.days AS days_126,
a8_.ceneo_days AS ceneo_days_127,
a8_.internal_name AS internal_name_128,
a8_.created_at AS created_at_129,
a8_.updated_at AS updated_at_130,
a8_.created_by AS created_by_131,
a8_.updated_by AS updated_by_132,
a8_.deleted_by AS deleted_by_133,
a9_.id AS id_134,
a9_.name AS name_135,
a9_.locale AS locale_136,
p10_.id AS id_137,
p10_.name AS name_138,
p10_.responsible_entity AS responsible_entity_139,
p10_.image_name AS image_name_140,
p10_.created_at AS created_at_141,
p10_.updated_at AS updated_at_142,
p10_.created_by AS created_by_143,
p10_.updated_by AS updated_by_144,
p10_.deleted_by AS deleted_by_145,
p3_.id AS id_146,
p3_.main AS main_147,
p3_.lifestyle AS lifestyle_148,
p3_.hover AS hover_149,
p3_.name AS name_150,
p3_.image_name AS image_name_151,
p3_.position AS position_152,
p3_.alt AS alt_153,
p3_.image_custom_name AS image_custom_name_154,
l11_.id AS id_155,
l11_.locale AS locale_156,
l11_.domain AS domain_157,
l11_.is_active AS is_active_158,
l11_.is_default AS is_default_159,
l11_.helpline AS helpline_160,
l11_.rounding_precision AS rounding_precision_161,
l11_.phone AS phone_162,
l11_.address AS address_163,
l11_.shop_name AS shop_name_164,
l11_.email AS email_165,
l11_.facebook AS facebook_166,
l11_.instagram AS instagram_167,
l11_.youtube AS youtube_168,
l11_.store_url AS store_url_169,
l11_.password_protected AS password_protected_170,
l11_.store_password AS store_password_171,
l11_.fb_pixel AS fb_pixel_172,
l11_.fb_token AS fb_token_173,
l11_.is_comments AS is_comments_174,
l11_.send_comment_request_days AS send_comment_request_days_175,
l11_.store_email AS store_email_176,
l11_.admin_store_email AS admin_store_email_177,
l11_.complaint_email AS complaint_email_178,
l11_.product_return_email AS product_return_email_179,
l11_.getresponse_campaign_id AS getresponse_campaign_id_180,
l11_.created_at AS created_at_181,
l11_.updated_at AS updated_at_182,
l11_.created_by AS created_by_183,
l11_.updated_by AS updated_by_184,
l11_.deleted_by AS deleted_by_185,
p12_.id AS id_186,
p12_.price AS price_187,
p12_.discount AS discount_188,
p12_.old_price AS old_price_189,
p12_.active AS active_190,
p12_.automatic_price_comment AS automatic_price_comment_191,
p12_.ean AS ean_192,
p12_.automatic_price AS automatic_price_193,
p12_.automatic_price_discount AS automatic_price_discount_194,
p12_.created_at AS created_at_195,
p12_.updated_at AS updated_at_196,
p12_.created_by AS created_by_197,
p12_.updated_by AS updated_by_198,
p12_.deleted_by AS deleted_by_199,
p2_.lifestyle AS lifestyle_200,
l13_.locale AS locale_201,
p14_.position AS position_202,
c15_.deleted_by AS deleted_by_203
FROM
product p0_
INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id
INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id
INNER JOIN language l7_ ON p1_.language = l7_.id
INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id
INNER JOIN currency c5_ ON l7_.currency_id = c5_.id
INNER JOIN availability a8_ ON p1_.availability_id = a8_.id
INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id
INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id
INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id
LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id
AND (p2_.lifestyle = 1)
INNER JOIN product_photo_language p16_ ON p3_.id = p16_.product_photo_id
INNER JOIN language l11_ ON l11_.id = p16_.language_id
LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id
LEFT JOIN language l13_ ON p12_.language = l13_.id
INNER JOIN product_category p14_ ON p0_.id = p14_.product_id
LEFT JOIN category c15_ ON p0_.main_category_id = c15_.id
LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id
LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id
WHERE
p6_.locale = ?
AND a9_.locale = ?
AND l13_.locale = ?
AND a8_.deleted_by IS NULL
AND (p3_.main = ?)
AND l11_.locale = ?
AND l7_.locale = ?
AND p12_.deleted_by IS NULL
AND p0_.deleted_by IS NULL
AND p1_.visible = ?
AND p14_.category_id = ?
AND c15_.deleted_by IS NULL
GROUP BY
p0_.id
ORDER BY
p3_.position ASC,
p2_.position ASC
) dctrn_result_inner
ORDER BY
position_202 ASC
) dctrn_result
LIMIT
30
SELECT DISTINCT id_12 FROM (SELECT DISTINCT id_12, position_202 FROM (SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p2_.lifestyle AS lifestyle_200, l13_.locale AS locale_201, p14_.position AS position_202, c15_.deleted_by AS deleted_by_203 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p16_ ON p3_.id = p16_.product_photo_id INNER JOIN language l11_ ON l11_.id = p16_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l13_ ON p12_.language = l13_.id INNER JOIN product_category p14_ ON p0_.id = p14_.product_id LEFT JOIN category c15_ ON p0_.main_category_id = c15_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = 'pl' AND a9_.locale = 'pl' AND l13_.locale = 'pl' AND a8_.deleted_by IS NULL AND (p3_.main = 1) AND l11_.locale = 'pl' AND l7_.locale = 'pl' AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = 1 AND p14_.category_id = 324 AND c15_.deleted_by IS NULL GROUP BY p0_.id ORDER BY p3_.position ASC, p2_.position ASC) dctrn_result_inner ORDER BY position_202 ASC) dctrn_result LIMIT 30;
|
| 31 |
3.68 ms |
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = ? AND a9_.locale = ? AND l14_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND p15_.category_id = ? AND c16_.deleted_by IS NULL AND p0_.id IN (?) GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
1
324
[
8028
8033
]
]
SELECT
p0_.listingMarkersIds AS listingMarkersIds_0,
p1_.promotion_icon AS promotion_icon_1,
p1_.is_new AS is_new_2,
p2_.image_name AS image_name_3,
p3_.image_name AS image_name_4,
p1_.bestseller AS bestseller_5,
p4_.id AS id_6,
c5_.sign AS sign_7,
c5_.id AS id_8,
p1_.price_description AS price_description_9,
p1_.price_crossed AS price_crossed_10,
p1_.omnibus_price AS omnibus_price_11,
p0_.id AS id_12,
p0_.symbol AS symbol_13,
p0_.photo3d AS photo3d_14,
p0_.is_variants AS is_variants_15,
p0_.is_palette_delivery AS is_palette_delivery_16,
p0_.payu AS payu_17,
p0_.automatic_price AS automatic_price_18,
p0_.halmar_stock_exchange AS halmar_stock_exchange_19,
p0_.diablo_stock_exchange AS diablo_stock_exchange_20,
p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21,
p0_.actona_stock_exchange AS actona_stock_exchange_22,
p0_.unique_stock_exchange AS unique_stock_exchange_23,
p0_.is_compare AS is_compare_24,
p0_.priority_search_engine AS priority_search_engine_25,
p0_.is_negotiate AS is_negotiate_26,
p0_.is_rebate_code AS is_rebate_code_27,
p0_.old_price AS old_price_28,
p0_.film AS film_29,
p0_.small_product_photo AS small_product_photo_30,
p0_.max_quantity AS max_quantity_31,
p0_.listingMarkersIds AS listingMarkersIds_32,
p0_.temporary_unavailable AS temporary_unavailable_33,
p0_.last_ranking_update AS last_ranking_update_34,
p0_.height AS height_35,
p0_.width AS width_36,
p0_.depth AS depth_37,
p0_.shipping_category AS shipping_category_38,
p0_.created_at AS created_at_39,
p0_.updated_at AS updated_at_40,
p0_.created_by AS created_by_41,
p0_.updated_by AS updated_by_42,
p0_.deleted_by AS deleted_by_43,
p6_.id AS id_44,
p6_.name AS name_45,
p6_.description AS description_46,
p6_.meta_title AS meta_title_47,
p6_.meta_description AS meta_description_48,
p6_.meta_keywords AS meta_keywords_49,
p6_.slug AS slug_50,
p6_.short_description AS short_description_51,
p6_.short_description_textile AS short_description_textile_52,
p6_.short_description_color AS short_description_color_53,
p6_.short_function_description AS short_function_description_54,
p6_.search_engine AS search_engine_55,
p6_.photo3d_gallery_url AS photo3d_gallery_url_56,
p6_.youtube_gallery_url AS youtube_gallery_url_57,
p6_.trans_film AS trans_film_58,
p6_.canonical AS canonical_59,
p6_.photo3d_additional AS photo3d_additional_60,
p6_.locale AS locale_61,
p1_.id AS id_62,
p1_.visible AS visible_63,
p1_.price_description AS price_description_64,
p1_.promotion AS promotion_65,
p1_.is_new AS is_new_66,
p1_.bestseller AS bestseller_67,
p1_.promote_one_homepage AS promote_one_homepage_68,
p1_.ready_for_publication AS ready_for_publication_69,
p1_.sale AS sale_70,
p1_.rating_value AS rating_value_71,
p1_.review_count AS review_count_72,
p1_.price_change AS price_change_73,
p1_.priority AS priority_74,
p1_.price_crossed AS price_crossed_75,
p1_.omnibus_price AS omnibus_price_76,
p1_.promotion_icon AS promotion_icon_77,
p1_.promo_price AS promo_price_78,
l7_.id AS id_79,
l7_.locale AS locale_80,
l7_.domain AS domain_81,
l7_.is_active AS is_active_82,
l7_.is_default AS is_default_83,
l7_.helpline AS helpline_84,
l7_.rounding_precision AS rounding_precision_85,
l7_.phone AS phone_86,
l7_.address AS address_87,
l7_.shop_name AS shop_name_88,
l7_.email AS email_89,
l7_.facebook AS facebook_90,
l7_.instagram AS instagram_91,
l7_.youtube AS youtube_92,
l7_.store_url AS store_url_93,
l7_.password_protected AS password_protected_94,
l7_.store_password AS store_password_95,
l7_.fb_pixel AS fb_pixel_96,
l7_.fb_token AS fb_token_97,
l7_.is_comments AS is_comments_98,
l7_.send_comment_request_days AS send_comment_request_days_99,
l7_.store_email AS store_email_100,
l7_.admin_store_email AS admin_store_email_101,
l7_.complaint_email AS complaint_email_102,
l7_.product_return_email AS product_return_email_103,
l7_.getresponse_campaign_id AS getresponse_campaign_id_104,
l7_.created_at AS created_at_105,
l7_.updated_at AS updated_at_106,
l7_.created_by AS created_by_107,
l7_.updated_by AS updated_by_108,
l7_.deleted_by AS deleted_by_109,
c5_.id AS id_110,
c5_.sign AS sign_111,
c5_.currency_separator AS currency_separator_112,
c5_.position_price AS position_price_113,
c5_.is_default AS is_default_114,
c5_.is_active AS is_active_115,
c5_.factorPln AS factorPln_116,
c5_.iso_code AS iso_code_117,
c5_.created_at AS created_at_118,
c5_.updated_at AS updated_at_119,
c5_.created_by AS created_by_120,
c5_.updated_by AS updated_by_121,
c5_.deleted_by AS deleted_by_122,
a8_.id AS id_123,
a8_.is_visible AS is_visible_124,
a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125,
a8_.days AS days_126,
a8_.ceneo_days AS ceneo_days_127,
a8_.internal_name AS internal_name_128,
a8_.created_at AS created_at_129,
a8_.updated_at AS updated_at_130,
a8_.created_by AS created_by_131,
a8_.updated_by AS updated_by_132,
a8_.deleted_by AS deleted_by_133,
a9_.id AS id_134,
a9_.name AS name_135,
a9_.locale AS locale_136,
p10_.id AS id_137,
p10_.name AS name_138,
p10_.responsible_entity AS responsible_entity_139,
p10_.image_name AS image_name_140,
p10_.created_at AS created_at_141,
p10_.updated_at AS updated_at_142,
p10_.created_by AS created_by_143,
p10_.updated_by AS updated_by_144,
p10_.deleted_by AS deleted_by_145,
p3_.id AS id_146,
p3_.main AS main_147,
p3_.lifestyle AS lifestyle_148,
p3_.hover AS hover_149,
p3_.name AS name_150,
p3_.image_name AS image_name_151,
p3_.position AS position_152,
p3_.alt AS alt_153,
p3_.image_custom_name AS image_custom_name_154,
l11_.id AS id_155,
l11_.locale AS locale_156,
l11_.domain AS domain_157,
l11_.is_active AS is_active_158,
l11_.is_default AS is_default_159,
l11_.helpline AS helpline_160,
l11_.rounding_precision AS rounding_precision_161,
l11_.phone AS phone_162,
l11_.address AS address_163,
l11_.shop_name AS shop_name_164,
l11_.email AS email_165,
l11_.facebook AS facebook_166,
l11_.instagram AS instagram_167,
l11_.youtube AS youtube_168,
l11_.store_url AS store_url_169,
l11_.password_protected AS password_protected_170,
l11_.store_password AS store_password_171,
l11_.fb_pixel AS fb_pixel_172,
l11_.fb_token AS fb_token_173,
l11_.is_comments AS is_comments_174,
l11_.send_comment_request_days AS send_comment_request_days_175,
l11_.store_email AS store_email_176,
l11_.admin_store_email AS admin_store_email_177,
l11_.complaint_email AS complaint_email_178,
l11_.product_return_email AS product_return_email_179,
l11_.getresponse_campaign_id AS getresponse_campaign_id_180,
l11_.created_at AS created_at_181,
l11_.updated_at AS updated_at_182,
l11_.created_by AS created_by_183,
l11_.updated_by AS updated_by_184,
l11_.deleted_by AS deleted_by_185,
p12_.id AS id_186,
p12_.price AS price_187,
p12_.discount AS discount_188,
p12_.old_price AS old_price_189,
p12_.active AS active_190,
p12_.automatic_price_comment AS automatic_price_comment_191,
p12_.ean AS ean_192,
p12_.automatic_price AS automatic_price_193,
p12_.automatic_price_discount AS automatic_price_discount_194,
p12_.created_at AS created_at_195,
p12_.updated_at AS updated_at_196,
p12_.created_by AS created_by_197,
p12_.updated_by AS updated_by_198,
p12_.deleted_by AS deleted_by_199,
p0_.product_family_id AS product_family_id_200,
p0_.product_producer_id AS product_producer_id_201,
p0_.availability_id AS availability_id_202,
p0_.main_category_id AS main_category_id_203,
p6_.translatable_id AS translatable_id_204,
p1_.product_id AS product_id_205,
p1_.language AS language_206,
p1_.vat_id AS vat_id_207,
p1_.availability_id AS availability_id_208,
p1_.product_producer_id AS product_producer_id_209,
l7_.currency_id AS currency_id_210,
a9_.translatable_id AS translatable_id_211,
p3_.product_id AS product_id_212,
l11_.currency_id AS currency_id_213,
p12_.product_id AS product_id_214,
p12_.parent_product_price_id AS parent_product_price_id_215,
p12_.currency_id AS currency_id_216,
p12_.language AS language_217
FROM
product p0_
INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id
INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id
INNER JOIN language l7_ ON p1_.language = l7_.id
INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id
INNER JOIN currency c5_ ON l7_.currency_id = c5_.id
INNER JOIN availability a8_ ON p1_.availability_id = a8_.id
INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id
INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id
INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id
LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id
AND (p2_.lifestyle = 1)
INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id
INNER JOIN language l11_ ON l11_.id = p13_.language_id
LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id
LEFT JOIN language l14_ ON p12_.language = l14_.id
INNER JOIN product_category p15_ ON p0_.id = p15_.product_id
LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id
LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id
LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id
WHERE
p6_.locale = ?
AND a9_.locale = ?
AND l14_.locale = ?
AND a8_.deleted_by IS NULL
AND (p3_.main = ?)
AND l11_.locale = ?
AND l7_.locale = ?
AND p12_.deleted_by IS NULL
AND p0_.deleted_by IS NULL
AND p1_.visible = ?
AND p15_.category_id = ?
AND c16_.deleted_by IS NULL
AND p0_.id IN (?)
GROUP BY
p0_.id
ORDER BY
p15_.position ASC,
p3_.position ASC
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id INNER JOIN product_category p15_ ON p0_.id = p15_.product_id LEFT JOIN category c16_ ON p0_.main_category_id = c16_.id LEFT JOIN product_product_color p18_ ON p0_.id = p18_.product_id LEFT JOIN product_color p17_ ON p17_.id = p18_.product_color_id WHERE p6_.locale = 'pl' AND a9_.locale = 'pl' AND l14_.locale = 'pl' AND a8_.deleted_by IS NULL AND (p3_.main = 1) AND l11_.locale = 'pl' AND l7_.locale = 'pl' AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = 1 AND p15_.category_id = 324 AND c16_.deleted_by IS NULL AND p0_.id IN (8028, 8033) GROUP BY p0_.id ORDER BY p15_.position ASC, p3_.position ASC;
|
| 32 |
0.38 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.deleted_by IS NULL AND t0.locale = ? LIMIT 1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.deleted_by IS NULL AND t0.locale = 'pl' LIMIT 1;
|
| 33 |
48.86 ms |
SELECT t0.id AS id_1, t0.session AS session_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM compare_product t0 WHERE t0.session IS NULL
SELECT t0.id AS id_1, t0.session AS session_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM compare_product t0 WHERE t0.session IS NULL;
|
| 34 |
0.73 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.responsible_entity AS responsible_entity_2, p0_.image_name AS image_name_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.created_by AS created_by_6, p0_.updated_by AS updated_by_7, p0_.deleted_by AS deleted_by_8 FROM product_producer p0_ INNER JOIN product_producer_languages p2_ ON p0_.id = p2_.product_producer_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.deleted_by IS NULL AND p0_.id IN (?) AND l1_.locale = ?
Parameters: [
[
80
]
"pl"
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.responsible_entity AS responsible_entity_2, p0_.image_name AS image_name_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.created_by AS created_by_6, p0_.updated_by AS updated_by_7, p0_.deleted_by AS deleted_by_8 FROM product_producer p0_ INNER JOIN product_producer_languages p2_ ON p0_.id = p2_.product_producer_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.deleted_by IS NULL AND p0_.id IN (80) AND l1_.locale = 'pl';
|
| 35 |
0.16 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = ? AND t0.deleted_by IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = 'pl' AND t0.deleted_by IS NULL LIMIT 1;
|
| 36 |
0.49 ms |
SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.name AS name_2, w0_.working_hours_type AS working_hours_type_3, w0_.nb_of_the_day AS nb_of_the_day_4, w0_.created_at AS created_at_5, w0_.updated_at AS updated_at_6, w0_.created_by AS created_by_7, w0_.updated_by AS updated_by_8, w0_.deleted_by AS deleted_by_9, w1_.id AS id_10, w1_.name AS name_11, w1_.short_name AS short_name_12, w1_.locale AS locale_13, w1_.translatable_id AS translatable_id_14 FROM working_hours w0_ INNER JOIN working_hours_translation w1_ ON w0_.id = w1_.translatable_id WHERE w1_.locale = ? AND w0_.deleted_by IS NULL AND w0_.nb_of_the_day = ? AND w0_.working_hours_type = ?
Parameters: [
"pl"
"6"
"main"
]
SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.name AS name_2, w0_.working_hours_type AS working_hours_type_3, w0_.nb_of_the_day AS nb_of_the_day_4, w0_.created_at AS created_at_5, w0_.updated_at AS updated_at_6, w0_.created_by AS created_by_7, w0_.updated_by AS updated_by_8, w0_.deleted_by AS deleted_by_9, w1_.id AS id_10, w1_.name AS name_11, w1_.short_name AS short_name_12, w1_.locale AS locale_13, w1_.translatable_id AS translatable_id_14 FROM working_hours w0_ INNER JOIN working_hours_translation w1_ ON w0_.id = w1_.translatable_id WHERE w1_.locale = 'pl' AND w0_.deleted_by IS NULL AND w0_.nb_of_the_day = '6' AND w0_.working_hours_type = 'main';
|
| 37 |
0.31 ms |
SELECT h0_.id AS id_0, h0_.day AS day_1, h0_.nb_of_the_day AS nb_of_the_day_2, h0_.created_at AS created_at_3, h0_.updated_at AS updated_at_4, h0_.created_by AS created_by_5, h0_.updated_by AS updated_by_6, h0_.deleted_by AS deleted_by_7, h1_.id AS id_8, h1_.name AS name_9, h1_.short_name AS short_name_10, h1_.locale AS locale_11, h1_.translatable_id AS translatable_id_12 FROM helpline_hours h0_ INNER JOIN helpline_hours_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.locale = ? AND h0_.deleted_by IS NULL AND h0_.nb_of_the_day = ?
SELECT h0_.id AS id_0, h0_.day AS day_1, h0_.nb_of_the_day AS nb_of_the_day_2, h0_.created_at AS created_at_3, h0_.updated_at AS updated_at_4, h0_.created_by AS created_by_5, h0_.updated_by AS updated_by_6, h0_.deleted_by AS deleted_by_7, h1_.id AS id_8, h1_.name AS name_9, h1_.short_name AS short_name_10, h1_.locale AS locale_11, h1_.translatable_id AS translatable_id_12 FROM helpline_hours h0_ INNER JOIN helpline_hours_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.locale = 'pl' AND h0_.deleted_by IS NULL AND h0_.nb_of_the_day = '6';
|
| 38 |
2.26 ms |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c4_.id AS id_52, c4_.visible AS visible_53, c4_.special AS special_54, c4_.shortcut AS shortcut_55, c4_.position AS position_56, c4_.is_homepage AS is_homepage_57, c4_.nb_products AS nb_products_58, c0_.category_parent_id AS category_parent_id_59, c1_.translatable_id AS translatable_id_60, c2_.category_parent_id AS category_parent_id_61, c3_.translatable_id AS translatable_id_62, c4_.category_id AS category_id_63, c4_.language AS language_64 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c5_ ON c0_.id = c5_.category_id INNER JOIN language l6_ ON c5_.language = l6_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id LEFT JOIN category_lang_param c4_ ON c2_.id = c4_.category_id LEFT JOIN language l7_ ON c4_.language = l7_.id WHERE c1_.locale = ? AND l6_.locale = ? AND c5_.special = ? AND c5_.shortcut = ? AND c0_.deleted_by IS NULL AND c5_.visible = ? AND c2_.deleted_by IS NULL AND l7_.locale = ? AND c4_.visible = 1 AND c0_.category_parent_id IS NULL AND c0_.id <> 209 AND c0_.id <> 121 ORDER BY c5_.position ASC, c4_.position ASC, c2_.position ASC
Parameters: [
"pl"
"pl"
0
0
1
"pl"
]
SELECT
c0_.id AS id_0,
c0_.level AS level_1,
c0_.position AS position_2,
c0_.alt AS alt_3,
c0_.image_custom_name AS image_custom_name_4,
c0_.image_name_2 AS image_name_2_5,
c0_.image_name_3 AS image_name_3_6,
c0_.image_name AS image_name_7,
c0_.created_at AS created_at_8,
c0_.updated_at AS updated_at_9,
c0_.created_by AS created_by_10,
c0_.updated_by AS updated_by_11,
c0_.deleted_by AS deleted_by_12,
c1_.id AS id_13,
c1_.name AS name_14,
c1_.description AS description_15,
c1_.meta_title AS meta_title_16,
c1_.meta_description AS meta_description_17,
c1_.meta_keywords AS meta_keywords_18,
c1_.custom_h1 AS custom_h1_19,
c1_.canonical AS canonical_20,
c1_.slug AS slug_21,
c1_.google_product_type AS google_product_type_22,
c1_.google_product_category AS google_product_category_23,
c1_.special_product_category AS special_product_category_24,
c1_.locale AS locale_25,
c2_.id AS id_26,
c2_.level AS level_27,
c2_.position AS position_28,
c2_.alt AS alt_29,
c2_.image_custom_name AS image_custom_name_30,
c2_.image_name_2 AS image_name_2_31,
c2_.image_name_3 AS image_name_3_32,
c2_.image_name AS image_name_33,
c2_.created_at AS created_at_34,
c2_.updated_at AS updated_at_35,
c2_.created_by AS created_by_36,
c2_.updated_by AS updated_by_37,
c2_.deleted_by AS deleted_by_38,
c3_.id AS id_39,
c3_.name AS name_40,
c3_.description AS description_41,
c3_.meta_title AS meta_title_42,
c3_.meta_description AS meta_description_43,
c3_.meta_keywords AS meta_keywords_44,
c3_.custom_h1 AS custom_h1_45,
c3_.canonical AS canonical_46,
c3_.slug AS slug_47,
c3_.google_product_type AS google_product_type_48,
c3_.google_product_category AS google_product_category_49,
c3_.special_product_category AS special_product_category_50,
c3_.locale AS locale_51,
c4_.id AS id_52,
c4_.visible AS visible_53,
c4_.special AS special_54,
c4_.shortcut AS shortcut_55,
c4_.position AS position_56,
c4_.is_homepage AS is_homepage_57,
c4_.nb_products AS nb_products_58,
c0_.category_parent_id AS category_parent_id_59,
c1_.translatable_id AS translatable_id_60,
c2_.category_parent_id AS category_parent_id_61,
c3_.translatable_id AS translatable_id_62,
c4_.category_id AS category_id_63,
c4_.language AS language_64
FROM
category c0_
INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id
INNER JOIN category_lang_param c5_ ON c0_.id = c5_.category_id
INNER JOIN language l6_ ON c5_.language = l6_.id
LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id
LEFT JOIN category_lang_param c4_ ON c2_.id = c4_.category_id
LEFT JOIN language l7_ ON c4_.language = l7_.id
WHERE
c1_.locale = ?
AND l6_.locale = ?
AND c5_.special = ?
AND c5_.shortcut = ?
AND c0_.deleted_by IS NULL
AND c5_.visible = ?
AND c2_.deleted_by IS NULL
AND l7_.locale = ?
AND c4_.visible = 1
AND c0_.category_parent_id IS NULL
AND c0_.id <> 209
AND c0_.id <> 121
ORDER BY
c5_.position ASC,
c4_.position ASC,
c2_.position ASC
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c4_.id AS id_52, c4_.visible AS visible_53, c4_.special AS special_54, c4_.shortcut AS shortcut_55, c4_.position AS position_56, c4_.is_homepage AS is_homepage_57, c4_.nb_products AS nb_products_58, c0_.category_parent_id AS category_parent_id_59, c1_.translatable_id AS translatable_id_60, c2_.category_parent_id AS category_parent_id_61, c3_.translatable_id AS translatable_id_62, c4_.category_id AS category_id_63, c4_.language AS language_64 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c5_ ON c0_.id = c5_.category_id INNER JOIN language l6_ ON c5_.language = l6_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id LEFT JOIN category_lang_param c4_ ON c2_.id = c4_.category_id LEFT JOIN language l7_ ON c4_.language = l7_.id WHERE c1_.locale = 'pl' AND l6_.locale = 'pl' AND c5_.special = 0 AND c5_.shortcut = 0 AND c0_.deleted_by IS NULL AND c5_.visible = 1 AND c2_.deleted_by IS NULL AND l7_.locale = 'pl' AND c4_.visible = 1 AND c0_.category_parent_id IS NULL AND c0_.id <> 209 AND c0_.id <> 121 ORDER BY c5_.position ASC, c4_.position ASC, c2_.position ASC;
|
| 39 |
0.24 ms |
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id WHERE f1_.locale = ? AND f0_.deleted_by IS NULL AND l3_.locale = ? AND f2_.visible = ? ORDER BY f2_.position ASC
Parameters: [
"pl"
"pl"
1
]
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id WHERE f1_.locale = 'pl' AND f0_.deleted_by IS NULL AND l3_.locale = 'pl' AND f2_.visible = 1 ORDER BY f2_.position ASC;
|
| 40 |
1.22 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.slug AS slug_3, a0_.header AS header_4, a0_.footer AS footer_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.created_by AS created_by_8, a0_.updated_by AS updated_by_9, a0_.deleted_by AS deleted_by_10, l1_.id AS id_11, l1_.locale AS locale_12, l1_.domain AS domain_13, l1_.is_active AS is_active_14, l1_.is_default AS is_default_15, l1_.helpline AS helpline_16, l1_.rounding_precision AS rounding_precision_17, l1_.phone AS phone_18, l1_.address AS address_19, l1_.shop_name AS shop_name_20, l1_.email AS email_21, l1_.facebook AS facebook_22, l1_.instagram AS instagram_23, l1_.youtube AS youtube_24, l1_.store_url AS store_url_25, l1_.password_protected AS password_protected_26, l1_.store_password AS store_password_27, l1_.fb_pixel AS fb_pixel_28, l1_.fb_token AS fb_token_29, l1_.is_comments AS is_comments_30, l1_.send_comment_request_days AS send_comment_request_days_31, l1_.store_email AS store_email_32, l1_.admin_store_email AS admin_store_email_33, l1_.complaint_email AS complaint_email_34, l1_.product_return_email AS product_return_email_35, l1_.getresponse_campaign_id AS getresponse_campaign_id_36, l1_.created_at AS created_at_37, l1_.updated_at AS updated_at_38, l1_.created_by AS created_by_39, l1_.updated_by AS updated_by_40, l1_.deleted_by AS deleted_by_41, a0_.language_id AS language_id_42, l1_.currency_id AS currency_id_43 FROM article a0_ INNER JOIN language l1_ ON a0_.language_id = l1_.id WHERE a0_.deleted_by IS NULL AND l1_.locale = ?
SELECT
a0_.id AS id_0,
a0_.title AS title_1,
a0_.content AS content_2,
a0_.slug AS slug_3,
a0_.header AS header_4,
a0_.footer AS footer_5,
a0_.created_at AS created_at_6,
a0_.updated_at AS updated_at_7,
a0_.created_by AS created_by_8,
a0_.updated_by AS updated_by_9,
a0_.deleted_by AS deleted_by_10,
l1_.id AS id_11,
l1_.locale AS locale_12,
l1_.domain AS domain_13,
l1_.is_active AS is_active_14,
l1_.is_default AS is_default_15,
l1_.helpline AS helpline_16,
l1_.rounding_precision AS rounding_precision_17,
l1_.phone AS phone_18,
l1_.address AS address_19,
l1_.shop_name AS shop_name_20,
l1_.email AS email_21,
l1_.facebook AS facebook_22,
l1_.instagram AS instagram_23,
l1_.youtube AS youtube_24,
l1_.store_url AS store_url_25,
l1_.password_protected AS password_protected_26,
l1_.store_password AS store_password_27,
l1_.fb_pixel AS fb_pixel_28,
l1_.fb_token AS fb_token_29,
l1_.is_comments AS is_comments_30,
l1_.send_comment_request_days AS send_comment_request_days_31,
l1_.store_email AS store_email_32,
l1_.admin_store_email AS admin_store_email_33,
l1_.complaint_email AS complaint_email_34,
l1_.product_return_email AS product_return_email_35,
l1_.getresponse_campaign_id AS getresponse_campaign_id_36,
l1_.created_at AS created_at_37,
l1_.updated_at AS updated_at_38,
l1_.created_by AS created_by_39,
l1_.updated_by AS updated_by_40,
l1_.deleted_by AS deleted_by_41,
a0_.language_id AS language_id_42,
l1_.currency_id AS currency_id_43
FROM
article a0_
INNER JOIN language l1_ ON a0_.language_id = l1_.id
WHERE
a0_.deleted_by IS NULL
AND l1_.locale = ?
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.slug AS slug_3, a0_.header AS header_4, a0_.footer AS footer_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.created_by AS created_by_8, a0_.updated_by AS updated_by_9, a0_.deleted_by AS deleted_by_10, l1_.id AS id_11, l1_.locale AS locale_12, l1_.domain AS domain_13, l1_.is_active AS is_active_14, l1_.is_default AS is_default_15, l1_.helpline AS helpline_16, l1_.rounding_precision AS rounding_precision_17, l1_.phone AS phone_18, l1_.address AS address_19, l1_.shop_name AS shop_name_20, l1_.email AS email_21, l1_.facebook AS facebook_22, l1_.instagram AS instagram_23, l1_.youtube AS youtube_24, l1_.store_url AS store_url_25, l1_.password_protected AS password_protected_26, l1_.store_password AS store_password_27, l1_.fb_pixel AS fb_pixel_28, l1_.fb_token AS fb_token_29, l1_.is_comments AS is_comments_30, l1_.send_comment_request_days AS send_comment_request_days_31, l1_.store_email AS store_email_32, l1_.admin_store_email AS admin_store_email_33, l1_.complaint_email AS complaint_email_34, l1_.product_return_email AS product_return_email_35, l1_.getresponse_campaign_id AS getresponse_campaign_id_36, l1_.created_at AS created_at_37, l1_.updated_at AS updated_at_38, l1_.created_by AS created_by_39, l1_.updated_by AS updated_by_40, l1_.deleted_by AS deleted_by_41, a0_.language_id AS language_id_42, l1_.currency_id AS currency_id_43 FROM article a0_ INNER JOIN language l1_ ON a0_.language_id = l1_.id WHERE a0_.deleted_by IS NULL AND l1_.locale = 'pl';
|
| 41 |
1039.15 ms |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c0_.category_parent_id AS category_parent_id_52, c1_.translatable_id AS translatable_id_53, c2_.category_parent_id AS category_parent_id_54, c3_.translatable_id AS translatable_id_55 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c4_ ON c0_.id = c4_.category_id INNER JOIN language l5_ ON c4_.language = l5_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id INNER JOIN product_category p6_ ON c0_.id = p6_.category_id INNER JOIN product p7_ ON p6_.product_id = p7_.id INNER JOIN product_lang_param p8_ ON p7_.id = p8_.product_id INNER JOIN availability a9_ ON p8_.availability_id = a9_.id WHERE c1_.locale = ? AND l5_.locale = ? AND c4_.special = ? AND c4_.shortcut = ? AND c0_.deleted_by IS NULL AND c4_.visible = ? AND c2_.deleted_by IS NULL AND a9_.id = ? AND c0_.category_parent_id IS NULL AND c0_.id <> ? GROUP BY c0_.id ORDER BY c4_.position ASC, c2_.position ASC
Parameters: [
"pl"
"pl"
0
0
1
1
209
]
SELECT
c0_.id AS id_0,
c0_.level AS level_1,
c0_.position AS position_2,
c0_.alt AS alt_3,
c0_.image_custom_name AS image_custom_name_4,
c0_.image_name_2 AS image_name_2_5,
c0_.image_name_3 AS image_name_3_6,
c0_.image_name AS image_name_7,
c0_.created_at AS created_at_8,
c0_.updated_at AS updated_at_9,
c0_.created_by AS created_by_10,
c0_.updated_by AS updated_by_11,
c0_.deleted_by AS deleted_by_12,
c1_.id AS id_13,
c1_.name AS name_14,
c1_.description AS description_15,
c1_.meta_title AS meta_title_16,
c1_.meta_description AS meta_description_17,
c1_.meta_keywords AS meta_keywords_18,
c1_.custom_h1 AS custom_h1_19,
c1_.canonical AS canonical_20,
c1_.slug AS slug_21,
c1_.google_product_type AS google_product_type_22,
c1_.google_product_category AS google_product_category_23,
c1_.special_product_category AS special_product_category_24,
c1_.locale AS locale_25,
c2_.id AS id_26,
c2_.level AS level_27,
c2_.position AS position_28,
c2_.alt AS alt_29,
c2_.image_custom_name AS image_custom_name_30,
c2_.image_name_2 AS image_name_2_31,
c2_.image_name_3 AS image_name_3_32,
c2_.image_name AS image_name_33,
c2_.created_at AS created_at_34,
c2_.updated_at AS updated_at_35,
c2_.created_by AS created_by_36,
c2_.updated_by AS updated_by_37,
c2_.deleted_by AS deleted_by_38,
c3_.id AS id_39,
c3_.name AS name_40,
c3_.description AS description_41,
c3_.meta_title AS meta_title_42,
c3_.meta_description AS meta_description_43,
c3_.meta_keywords AS meta_keywords_44,
c3_.custom_h1 AS custom_h1_45,
c3_.canonical AS canonical_46,
c3_.slug AS slug_47,
c3_.google_product_type AS google_product_type_48,
c3_.google_product_category AS google_product_category_49,
c3_.special_product_category AS special_product_category_50,
c3_.locale AS locale_51,
c0_.category_parent_id AS category_parent_id_52,
c1_.translatable_id AS translatable_id_53,
c2_.category_parent_id AS category_parent_id_54,
c3_.translatable_id AS translatable_id_55
FROM
category c0_
INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id
INNER JOIN category_lang_param c4_ ON c0_.id = c4_.category_id
INNER JOIN language l5_ ON c4_.language = l5_.id
LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id
LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id
INNER JOIN product_category p6_ ON c0_.id = p6_.category_id
INNER JOIN product p7_ ON p6_.product_id = p7_.id
INNER JOIN product_lang_param p8_ ON p7_.id = p8_.product_id
INNER JOIN availability a9_ ON p8_.availability_id = a9_.id
WHERE
c1_.locale = ?
AND l5_.locale = ?
AND c4_.special = ?
AND c4_.shortcut = ?
AND c0_.deleted_by IS NULL
AND c4_.visible = ?
AND c2_.deleted_by IS NULL
AND a9_.id = ?
AND c0_.category_parent_id IS NULL
AND c0_.id <> ?
GROUP BY
c0_.id
ORDER BY
c4_.position ASC,
c2_.position ASC
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c1_.id AS id_13, c1_.name AS name_14, c1_.description AS description_15, c1_.meta_title AS meta_title_16, c1_.meta_description AS meta_description_17, c1_.meta_keywords AS meta_keywords_18, c1_.custom_h1 AS custom_h1_19, c1_.canonical AS canonical_20, c1_.slug AS slug_21, c1_.google_product_type AS google_product_type_22, c1_.google_product_category AS google_product_category_23, c1_.special_product_category AS special_product_category_24, c1_.locale AS locale_25, c2_.id AS id_26, c2_.level AS level_27, c2_.position AS position_28, c2_.alt AS alt_29, c2_.image_custom_name AS image_custom_name_30, c2_.image_name_2 AS image_name_2_31, c2_.image_name_3 AS image_name_3_32, c2_.image_name AS image_name_33, c2_.created_at AS created_at_34, c2_.updated_at AS updated_at_35, c2_.created_by AS created_by_36, c2_.updated_by AS updated_by_37, c2_.deleted_by AS deleted_by_38, c3_.id AS id_39, c3_.name AS name_40, c3_.description AS description_41, c3_.meta_title AS meta_title_42, c3_.meta_description AS meta_description_43, c3_.meta_keywords AS meta_keywords_44, c3_.custom_h1 AS custom_h1_45, c3_.canonical AS canonical_46, c3_.slug AS slug_47, c3_.google_product_type AS google_product_type_48, c3_.google_product_category AS google_product_category_49, c3_.special_product_category AS special_product_category_50, c3_.locale AS locale_51, c0_.category_parent_id AS category_parent_id_52, c1_.translatable_id AS translatable_id_53, c2_.category_parent_id AS category_parent_id_54, c3_.translatable_id AS translatable_id_55 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c4_ ON c0_.id = c4_.category_id INNER JOIN language l5_ ON c4_.language = l5_.id LEFT JOIN category c2_ ON c0_.id = c2_.category_parent_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id INNER JOIN product_category p6_ ON c0_.id = p6_.category_id INNER JOIN product p7_ ON p6_.product_id = p7_.id INNER JOIN product_lang_param p8_ ON p7_.id = p8_.product_id INNER JOIN availability a9_ ON p8_.availability_id = a9_.id WHERE c1_.locale = 'pl' AND l5_.locale = 'pl' AND c4_.special = 0 AND c4_.shortcut = 0 AND c0_.deleted_by IS NULL AND c4_.visible = 1 AND c2_.deleted_by IS NULL AND a9_.id = 1 AND c0_.category_parent_id IS NULL AND c0_.id <> 209 GROUP BY c0_.id ORDER BY c4_.position ASC, c2_.position ASC;
|
| 42 |
25.19 ms |
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id INNER JOIN product_furniture_type p4_ ON f0_.id = p4_.furniture_type_id INNER JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_lang_param p6_ ON p5_.id = p6_.product_id INNER JOIN availability a7_ ON p6_.availability_id = a7_.id WHERE f1_.locale = ? AND f0_.deleted_by IS NULL AND l3_.locale = ? AND f2_.visible = ? AND a7_.id = ? GROUP BY f0_.id ORDER BY f2_.position ASC
Parameters: [
"pl"
"pl"
1
1
]
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id INNER JOIN product_furniture_type p4_ ON f0_.id = p4_.furniture_type_id INNER JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_lang_param p6_ ON p5_.id = p6_.product_id INNER JOIN availability a7_ ON p6_.availability_id = a7_.id WHERE f1_.locale = 'pl' AND f0_.deleted_by IS NULL AND l3_.locale = 'pl' AND f2_.visible = 1 AND a7_.id = 1 GROUP BY f0_.id ORDER BY f2_.position ASC;
|
| 43 |
53.37 ms |
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id INNER JOIN product_furniture_type p4_ ON f0_.id = p4_.furniture_type_id INNER JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_category p6_ ON p5_.id = p6_.product_id INNER JOIN category c7_ ON p6_.category_id = c7_.id WHERE f1_.locale = ? AND f0_.deleted_by IS NULL AND l3_.locale = ? AND f2_.visible = ? AND ((c7_.id = 237 OR c7_.id = 127)) GROUP BY f0_.id ORDER BY f2_.position ASC
Parameters: [
"pl"
"pl"
1
]
SELECT f0_.id AS id_0, f0_.image_name AS image_name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.created_by AS created_by_4, f0_.updated_by AS updated_by_5, f0_.deleted_by AS deleted_by_6, f1_.id AS id_7, f1_.name AS name_8, f1_.description AS description_9, f1_.meta_title AS meta_title_10, f1_.meta_description AS meta_description_11, f1_.meta_keywords AS meta_keywords_12, f1_.canonical AS canonical_13, f1_.slug AS slug_14, f1_.locale AS locale_15, f2_.id AS id_16, f2_.visible AS visible_17, f2_.position AS position_18, f2_.nb_products AS nb_products_19, f0_.vat_id AS vat_id_20, f1_.translatable_id AS translatable_id_21, f2_.furniture_type_id AS furniture_type_id_22, f2_.language AS language_23 FROM furniture_type f0_ INNER JOIN furniture_type_translation f1_ ON f0_.id = f1_.translatable_id INNER JOIN furniture_lang_param f2_ ON f0_.id = f2_.furniture_type_id INNER JOIN language l3_ ON f2_.language = l3_.id INNER JOIN product_furniture_type p4_ ON f0_.id = p4_.furniture_type_id INNER JOIN product p5_ ON p4_.product_id = p5_.id INNER JOIN product_category p6_ ON p5_.id = p6_.product_id INNER JOIN category c7_ ON p6_.category_id = c7_.id WHERE f1_.locale = 'pl' AND f0_.deleted_by IS NULL AND l3_.locale = 'pl' AND f2_.visible = 1 AND ((c7_.id = 237 OR c7_.id = 127)) GROUP BY f0_.id ORDER BY f2_.position ASC;
|
| 44 |
0.29 ms |
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c0_.category_parent_id AS category_parent_id_13 FROM category c0_ WHERE c0_.id IN (?)
Parameters: [
[
237
121
]
]
SELECT c0_.id AS id_0, c0_.level AS level_1, c0_.position AS position_2, c0_.alt AS alt_3, c0_.image_custom_name AS image_custom_name_4, c0_.image_name_2 AS image_name_2_5, c0_.image_name_3 AS image_name_3_6, c0_.image_name AS image_name_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.created_by AS created_by_10, c0_.updated_by AS updated_by_11, c0_.deleted_by AS deleted_by_12, c0_.category_parent_id AS category_parent_id_13 FROM category c0_ WHERE c0_.id IN (237, 121);
|
| 45 |
29.52 ms |
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id WHERE p6_.locale = ? AND a9_.locale = ? AND l14_.locale = ? AND a8_.deleted_by IS NULL AND (p3_.main = ?) AND l11_.locale = ? AND l7_.locale = ? AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = ? AND (p1_.promotion = ?) ORDER BY p0_.id DESC, p3_.position ASC
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
1
1
]
SELECT
p0_.listingMarkersIds AS listingMarkersIds_0,
p1_.promotion_icon AS promotion_icon_1,
p1_.is_new AS is_new_2,
p2_.image_name AS image_name_3,
p3_.image_name AS image_name_4,
p1_.bestseller AS bestseller_5,
p4_.id AS id_6,
c5_.sign AS sign_7,
c5_.id AS id_8,
p1_.price_description AS price_description_9,
p1_.price_crossed AS price_crossed_10,
p1_.omnibus_price AS omnibus_price_11,
p0_.id AS id_12,
p0_.symbol AS symbol_13,
p0_.photo3d AS photo3d_14,
p0_.is_variants AS is_variants_15,
p0_.is_palette_delivery AS is_palette_delivery_16,
p0_.payu AS payu_17,
p0_.automatic_price AS automatic_price_18,
p0_.halmar_stock_exchange AS halmar_stock_exchange_19,
p0_.diablo_stock_exchange AS diablo_stock_exchange_20,
p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21,
p0_.actona_stock_exchange AS actona_stock_exchange_22,
p0_.unique_stock_exchange AS unique_stock_exchange_23,
p0_.is_compare AS is_compare_24,
p0_.priority_search_engine AS priority_search_engine_25,
p0_.is_negotiate AS is_negotiate_26,
p0_.is_rebate_code AS is_rebate_code_27,
p0_.old_price AS old_price_28,
p0_.film AS film_29,
p0_.small_product_photo AS small_product_photo_30,
p0_.max_quantity AS max_quantity_31,
p0_.listingMarkersIds AS listingMarkersIds_32,
p0_.temporary_unavailable AS temporary_unavailable_33,
p0_.last_ranking_update AS last_ranking_update_34,
p0_.height AS height_35,
p0_.width AS width_36,
p0_.depth AS depth_37,
p0_.shipping_category AS shipping_category_38,
p0_.created_at AS created_at_39,
p0_.updated_at AS updated_at_40,
p0_.created_by AS created_by_41,
p0_.updated_by AS updated_by_42,
p0_.deleted_by AS deleted_by_43,
p6_.id AS id_44,
p6_.name AS name_45,
p6_.description AS description_46,
p6_.meta_title AS meta_title_47,
p6_.meta_description AS meta_description_48,
p6_.meta_keywords AS meta_keywords_49,
p6_.slug AS slug_50,
p6_.short_description AS short_description_51,
p6_.short_description_textile AS short_description_textile_52,
p6_.short_description_color AS short_description_color_53,
p6_.short_function_description AS short_function_description_54,
p6_.search_engine AS search_engine_55,
p6_.photo3d_gallery_url AS photo3d_gallery_url_56,
p6_.youtube_gallery_url AS youtube_gallery_url_57,
p6_.trans_film AS trans_film_58,
p6_.canonical AS canonical_59,
p6_.photo3d_additional AS photo3d_additional_60,
p6_.locale AS locale_61,
p1_.id AS id_62,
p1_.visible AS visible_63,
p1_.price_description AS price_description_64,
p1_.promotion AS promotion_65,
p1_.is_new AS is_new_66,
p1_.bestseller AS bestseller_67,
p1_.promote_one_homepage AS promote_one_homepage_68,
p1_.ready_for_publication AS ready_for_publication_69,
p1_.sale AS sale_70,
p1_.rating_value AS rating_value_71,
p1_.review_count AS review_count_72,
p1_.price_change AS price_change_73,
p1_.priority AS priority_74,
p1_.price_crossed AS price_crossed_75,
p1_.omnibus_price AS omnibus_price_76,
p1_.promotion_icon AS promotion_icon_77,
p1_.promo_price AS promo_price_78,
l7_.id AS id_79,
l7_.locale AS locale_80,
l7_.domain AS domain_81,
l7_.is_active AS is_active_82,
l7_.is_default AS is_default_83,
l7_.helpline AS helpline_84,
l7_.rounding_precision AS rounding_precision_85,
l7_.phone AS phone_86,
l7_.address AS address_87,
l7_.shop_name AS shop_name_88,
l7_.email AS email_89,
l7_.facebook AS facebook_90,
l7_.instagram AS instagram_91,
l7_.youtube AS youtube_92,
l7_.store_url AS store_url_93,
l7_.password_protected AS password_protected_94,
l7_.store_password AS store_password_95,
l7_.fb_pixel AS fb_pixel_96,
l7_.fb_token AS fb_token_97,
l7_.is_comments AS is_comments_98,
l7_.send_comment_request_days AS send_comment_request_days_99,
l7_.store_email AS store_email_100,
l7_.admin_store_email AS admin_store_email_101,
l7_.complaint_email AS complaint_email_102,
l7_.product_return_email AS product_return_email_103,
l7_.getresponse_campaign_id AS getresponse_campaign_id_104,
l7_.created_at AS created_at_105,
l7_.updated_at AS updated_at_106,
l7_.created_by AS created_by_107,
l7_.updated_by AS updated_by_108,
l7_.deleted_by AS deleted_by_109,
c5_.id AS id_110,
c5_.sign AS sign_111,
c5_.currency_separator AS currency_separator_112,
c5_.position_price AS position_price_113,
c5_.is_default AS is_default_114,
c5_.is_active AS is_active_115,
c5_.factorPln AS factorPln_116,
c5_.iso_code AS iso_code_117,
c5_.created_at AS created_at_118,
c5_.updated_at AS updated_at_119,
c5_.created_by AS created_by_120,
c5_.updated_by AS updated_by_121,
c5_.deleted_by AS deleted_by_122,
a8_.id AS id_123,
a8_.is_visible AS is_visible_124,
a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125,
a8_.days AS days_126,
a8_.ceneo_days AS ceneo_days_127,
a8_.internal_name AS internal_name_128,
a8_.created_at AS created_at_129,
a8_.updated_at AS updated_at_130,
a8_.created_by AS created_by_131,
a8_.updated_by AS updated_by_132,
a8_.deleted_by AS deleted_by_133,
a9_.id AS id_134,
a9_.name AS name_135,
a9_.locale AS locale_136,
p10_.id AS id_137,
p10_.name AS name_138,
p10_.responsible_entity AS responsible_entity_139,
p10_.image_name AS image_name_140,
p10_.created_at AS created_at_141,
p10_.updated_at AS updated_at_142,
p10_.created_by AS created_by_143,
p10_.updated_by AS updated_by_144,
p10_.deleted_by AS deleted_by_145,
p3_.id AS id_146,
p3_.main AS main_147,
p3_.lifestyle AS lifestyle_148,
p3_.hover AS hover_149,
p3_.name AS name_150,
p3_.image_name AS image_name_151,
p3_.position AS position_152,
p3_.alt AS alt_153,
p3_.image_custom_name AS image_custom_name_154,
l11_.id AS id_155,
l11_.locale AS locale_156,
l11_.domain AS domain_157,
l11_.is_active AS is_active_158,
l11_.is_default AS is_default_159,
l11_.helpline AS helpline_160,
l11_.rounding_precision AS rounding_precision_161,
l11_.phone AS phone_162,
l11_.address AS address_163,
l11_.shop_name AS shop_name_164,
l11_.email AS email_165,
l11_.facebook AS facebook_166,
l11_.instagram AS instagram_167,
l11_.youtube AS youtube_168,
l11_.store_url AS store_url_169,
l11_.password_protected AS password_protected_170,
l11_.store_password AS store_password_171,
l11_.fb_pixel AS fb_pixel_172,
l11_.fb_token AS fb_token_173,
l11_.is_comments AS is_comments_174,
l11_.send_comment_request_days AS send_comment_request_days_175,
l11_.store_email AS store_email_176,
l11_.admin_store_email AS admin_store_email_177,
l11_.complaint_email AS complaint_email_178,
l11_.product_return_email AS product_return_email_179,
l11_.getresponse_campaign_id AS getresponse_campaign_id_180,
l11_.created_at AS created_at_181,
l11_.updated_at AS updated_at_182,
l11_.created_by AS created_by_183,
l11_.updated_by AS updated_by_184,
l11_.deleted_by AS deleted_by_185,
p12_.id AS id_186,
p12_.price AS price_187,
p12_.discount AS discount_188,
p12_.old_price AS old_price_189,
p12_.active AS active_190,
p12_.automatic_price_comment AS automatic_price_comment_191,
p12_.ean AS ean_192,
p12_.automatic_price AS automatic_price_193,
p12_.automatic_price_discount AS automatic_price_discount_194,
p12_.created_at AS created_at_195,
p12_.updated_at AS updated_at_196,
p12_.created_by AS created_by_197,
p12_.updated_by AS updated_by_198,
p12_.deleted_by AS deleted_by_199,
p0_.product_family_id AS product_family_id_200,
p0_.product_producer_id AS product_producer_id_201,
p0_.availability_id AS availability_id_202,
p0_.main_category_id AS main_category_id_203,
p6_.translatable_id AS translatable_id_204,
p1_.product_id AS product_id_205,
p1_.language AS language_206,
p1_.vat_id AS vat_id_207,
p1_.availability_id AS availability_id_208,
p1_.product_producer_id AS product_producer_id_209,
l7_.currency_id AS currency_id_210,
a9_.translatable_id AS translatable_id_211,
p3_.product_id AS product_id_212,
l11_.currency_id AS currency_id_213,
p12_.product_id AS product_id_214,
p12_.parent_product_price_id AS parent_product_price_id_215,
p12_.currency_id AS currency_id_216,
p12_.language AS language_217
FROM
product p0_
INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id
INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id
INNER JOIN language l7_ ON p1_.language = l7_.id
INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id
INNER JOIN currency c5_ ON l7_.currency_id = c5_.id
INNER JOIN availability a8_ ON p1_.availability_id = a8_.id
INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id
INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id
INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id
LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id
AND (p2_.lifestyle = 1)
INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id
INNER JOIN language l11_ ON l11_.id = p13_.language_id
LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id
LEFT JOIN language l14_ ON p12_.language = l14_.id
WHERE
p6_.locale = ?
AND a9_.locale = ?
AND l14_.locale = ?
AND a8_.deleted_by IS NULL
AND (p3_.main = ?)
AND l11_.locale = ?
AND l7_.locale = ?
AND p12_.deleted_by IS NULL
AND p0_.deleted_by IS NULL
AND p1_.visible = ?
AND (p1_.promotion = ?)
ORDER BY
p0_.id DESC,
p3_.position ASC
SELECT p0_.listingMarkersIds AS listingMarkersIds_0, p1_.promotion_icon AS promotion_icon_1, p1_.is_new AS is_new_2, p2_.image_name AS image_name_3, p3_.image_name AS image_name_4, p1_.bestseller AS bestseller_5, p4_.id AS id_6, c5_.sign AS sign_7, c5_.id AS id_8, p1_.price_description AS price_description_9, p1_.price_crossed AS price_crossed_10, p1_.omnibus_price AS omnibus_price_11, p0_.id AS id_12, p0_.symbol AS symbol_13, p0_.photo3d AS photo3d_14, p0_.is_variants AS is_variants_15, p0_.is_palette_delivery AS is_palette_delivery_16, p0_.payu AS payu_17, p0_.automatic_price AS automatic_price_18, p0_.halmar_stock_exchange AS halmar_stock_exchange_19, p0_.diablo_stock_exchange AS diablo_stock_exchange_20, p0_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_21, p0_.actona_stock_exchange AS actona_stock_exchange_22, p0_.unique_stock_exchange AS unique_stock_exchange_23, p0_.is_compare AS is_compare_24, p0_.priority_search_engine AS priority_search_engine_25, p0_.is_negotiate AS is_negotiate_26, p0_.is_rebate_code AS is_rebate_code_27, p0_.old_price AS old_price_28, p0_.film AS film_29, p0_.small_product_photo AS small_product_photo_30, p0_.max_quantity AS max_quantity_31, p0_.listingMarkersIds AS listingMarkersIds_32, p0_.temporary_unavailable AS temporary_unavailable_33, p0_.last_ranking_update AS last_ranking_update_34, p0_.height AS height_35, p0_.width AS width_36, p0_.depth AS depth_37, p0_.shipping_category AS shipping_category_38, p0_.created_at AS created_at_39, p0_.updated_at AS updated_at_40, p0_.created_by AS created_by_41, p0_.updated_by AS updated_by_42, p0_.deleted_by AS deleted_by_43, p6_.id AS id_44, p6_.name AS name_45, p6_.description AS description_46, p6_.meta_title AS meta_title_47, p6_.meta_description AS meta_description_48, p6_.meta_keywords AS meta_keywords_49, p6_.slug AS slug_50, p6_.short_description AS short_description_51, p6_.short_description_textile AS short_description_textile_52, p6_.short_description_color AS short_description_color_53, p6_.short_function_description AS short_function_description_54, p6_.search_engine AS search_engine_55, p6_.photo3d_gallery_url AS photo3d_gallery_url_56, p6_.youtube_gallery_url AS youtube_gallery_url_57, p6_.trans_film AS trans_film_58, p6_.canonical AS canonical_59, p6_.photo3d_additional AS photo3d_additional_60, p6_.locale AS locale_61, p1_.id AS id_62, p1_.visible AS visible_63, p1_.price_description AS price_description_64, p1_.promotion AS promotion_65, p1_.is_new AS is_new_66, p1_.bestseller AS bestseller_67, p1_.promote_one_homepage AS promote_one_homepage_68, p1_.ready_for_publication AS ready_for_publication_69, p1_.sale AS sale_70, p1_.rating_value AS rating_value_71, p1_.review_count AS review_count_72, p1_.price_change AS price_change_73, p1_.priority AS priority_74, p1_.price_crossed AS price_crossed_75, p1_.omnibus_price AS omnibus_price_76, p1_.promotion_icon AS promotion_icon_77, p1_.promo_price AS promo_price_78, l7_.id AS id_79, l7_.locale AS locale_80, l7_.domain AS domain_81, l7_.is_active AS is_active_82, l7_.is_default AS is_default_83, l7_.helpline AS helpline_84, l7_.rounding_precision AS rounding_precision_85, l7_.phone AS phone_86, l7_.address AS address_87, l7_.shop_name AS shop_name_88, l7_.email AS email_89, l7_.facebook AS facebook_90, l7_.instagram AS instagram_91, l7_.youtube AS youtube_92, l7_.store_url AS store_url_93, l7_.password_protected AS password_protected_94, l7_.store_password AS store_password_95, l7_.fb_pixel AS fb_pixel_96, l7_.fb_token AS fb_token_97, l7_.is_comments AS is_comments_98, l7_.send_comment_request_days AS send_comment_request_days_99, l7_.store_email AS store_email_100, l7_.admin_store_email AS admin_store_email_101, l7_.complaint_email AS complaint_email_102, l7_.product_return_email AS product_return_email_103, l7_.getresponse_campaign_id AS getresponse_campaign_id_104, l7_.created_at AS created_at_105, l7_.updated_at AS updated_at_106, l7_.created_by AS created_by_107, l7_.updated_by AS updated_by_108, l7_.deleted_by AS deleted_by_109, c5_.id AS id_110, c5_.sign AS sign_111, c5_.currency_separator AS currency_separator_112, c5_.position_price AS position_price_113, c5_.is_default AS is_default_114, c5_.is_active AS is_active_115, c5_.factorPln AS factorPln_116, c5_.iso_code AS iso_code_117, c5_.created_at AS created_at_118, c5_.updated_at AS updated_at_119, c5_.created_by AS created_by_120, c5_.updated_by AS updated_by_121, c5_.deleted_by AS deleted_by_122, a8_.id AS id_123, a8_.is_visible AS is_visible_124, a8_.is_currentyly_unavailable AS is_currentyly_unavailable_125, a8_.days AS days_126, a8_.ceneo_days AS ceneo_days_127, a8_.internal_name AS internal_name_128, a8_.created_at AS created_at_129, a8_.updated_at AS updated_at_130, a8_.created_by AS created_by_131, a8_.updated_by AS updated_by_132, a8_.deleted_by AS deleted_by_133, a9_.id AS id_134, a9_.name AS name_135, a9_.locale AS locale_136, p10_.id AS id_137, p10_.name AS name_138, p10_.responsible_entity AS responsible_entity_139, p10_.image_name AS image_name_140, p10_.created_at AS created_at_141, p10_.updated_at AS updated_at_142, p10_.created_by AS created_by_143, p10_.updated_by AS updated_by_144, p10_.deleted_by AS deleted_by_145, p3_.id AS id_146, p3_.main AS main_147, p3_.lifestyle AS lifestyle_148, p3_.hover AS hover_149, p3_.name AS name_150, p3_.image_name AS image_name_151, p3_.position AS position_152, p3_.alt AS alt_153, p3_.image_custom_name AS image_custom_name_154, l11_.id AS id_155, l11_.locale AS locale_156, l11_.domain AS domain_157, l11_.is_active AS is_active_158, l11_.is_default AS is_default_159, l11_.helpline AS helpline_160, l11_.rounding_precision AS rounding_precision_161, l11_.phone AS phone_162, l11_.address AS address_163, l11_.shop_name AS shop_name_164, l11_.email AS email_165, l11_.facebook AS facebook_166, l11_.instagram AS instagram_167, l11_.youtube AS youtube_168, l11_.store_url AS store_url_169, l11_.password_protected AS password_protected_170, l11_.store_password AS store_password_171, l11_.fb_pixel AS fb_pixel_172, l11_.fb_token AS fb_token_173, l11_.is_comments AS is_comments_174, l11_.send_comment_request_days AS send_comment_request_days_175, l11_.store_email AS store_email_176, l11_.admin_store_email AS admin_store_email_177, l11_.complaint_email AS complaint_email_178, l11_.product_return_email AS product_return_email_179, l11_.getresponse_campaign_id AS getresponse_campaign_id_180, l11_.created_at AS created_at_181, l11_.updated_at AS updated_at_182, l11_.created_by AS created_by_183, l11_.updated_by AS updated_by_184, l11_.deleted_by AS deleted_by_185, p12_.id AS id_186, p12_.price AS price_187, p12_.discount AS discount_188, p12_.old_price AS old_price_189, p12_.active AS active_190, p12_.automatic_price_comment AS automatic_price_comment_191, p12_.ean AS ean_192, p12_.automatic_price AS automatic_price_193, p12_.automatic_price_discount AS automatic_price_discount_194, p12_.created_at AS created_at_195, p12_.updated_at AS updated_at_196, p12_.created_by AS created_by_197, p12_.updated_by AS updated_by_198, p12_.deleted_by AS deleted_by_199, p0_.product_family_id AS product_family_id_200, p0_.product_producer_id AS product_producer_id_201, p0_.availability_id AS availability_id_202, p0_.main_category_id AS main_category_id_203, p6_.translatable_id AS translatable_id_204, p1_.product_id AS product_id_205, p1_.language AS language_206, p1_.vat_id AS vat_id_207, p1_.availability_id AS availability_id_208, p1_.product_producer_id AS product_producer_id_209, l7_.currency_id AS currency_id_210, a9_.translatable_id AS translatable_id_211, p3_.product_id AS product_id_212, l11_.currency_id AS currency_id_213, p12_.product_id AS product_id_214, p12_.parent_product_price_id AS parent_product_price_id_215, p12_.currency_id AS currency_id_216, p12_.language AS language_217 FROM product p0_ INNER JOIN product_translation p6_ ON p0_.id = p6_.translatable_id INNER JOIN product_lang_param p1_ ON p0_.id = p1_.product_id INNER JOIN language l7_ ON p1_.language = l7_.id INNER JOIN product_vat p4_ ON p1_.vat_id = p4_.id INNER JOIN currency c5_ ON l7_.currency_id = c5_.id INNER JOIN availability a8_ ON p1_.availability_id = a8_.id INNER JOIN availability_translation a9_ ON a8_.id = a9_.translatable_id INNER JOIN product_producer p10_ ON p1_.product_producer_id = p10_.id INNER JOIN product_photo p3_ ON p0_.id = p3_.product_id LEFT JOIN product_photo p2_ ON p0_.id = p2_.product_id AND (p2_.lifestyle = 1) INNER JOIN product_photo_language p13_ ON p3_.id = p13_.product_photo_id INNER JOIN language l11_ ON l11_.id = p13_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l14_ ON p12_.language = l14_.id WHERE p6_.locale = 'pl' AND a9_.locale = 'pl' AND l14_.locale = 'pl' AND a8_.deleted_by IS NULL AND (p3_.main = 1) AND l11_.locale = 'pl' AND l7_.locale = 'pl' AND p12_.deleted_by IS NULL AND p0_.deleted_by IS NULL AND p1_.visible = 1 AND (p1_.promotion = 1) ORDER BY p0_.id DESC, p3_.position ASC;
|
| 46 |
0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.header AS header_3, t0.description AS description_4, t0.visible AS visible_5, t0.special_for_buy_cheaper AS special_for_buy_cheaper_6, t0.slug AS slug_7, t0.redirect AS redirect_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.deleted_by AS deleted_by_15, t0.top_banner_id AS top_banner_id_16, t0.language_id AS language_id_17, t0.product_producer_id AS product_producer_id_18, t0.banner_id AS banner_id_19 FROM landing_page t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.header AS header_3, t0.description AS description_4, t0.visible AS visible_5, t0.special_for_buy_cheaper AS special_for_buy_cheaper_6, t0.slug AS slug_7, t0.redirect AS redirect_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.deleted_by AS deleted_by_15, t0.top_banner_id AS top_banner_id_16, t0.language_id AS language_id_17, t0.product_producer_id AS product_producer_id_18, t0.banner_id AS banner_id_19 FROM landing_page t0 WHERE t0.id = 228;
|
| 47 |
1.09 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.visible AS visible_4, b0_.visible_in_promotions AS visible_in_promotions_5, b0_.url AS url_6, b0_.position AS position_7, b0_.color AS color_8, b0_.additional_text AS additional_text_9, b0_.button_color AS button_color_10, b0_.button_text_color AS button_text_color_11, b0_.campaign_text_color AS campaign_text_color_12, b0_.button_text AS button_text_13, b0_.bottom_button_text AS bottom_button_text_14, b0_.bottom_button_text_color AS bottom_button_text_color_15, b0_.bottom_button_color AS bottom_button_color_16, b0_.bottom_background_color AS bottom_background_color_17, b0_.bottom_text_color AS bottom_text_color_18, b0_.image_name AS image_name_19, b0_.created_at AS created_at_20, b0_.updated_at AS updated_at_21, b0_.created_by AS created_by_22, b0_.updated_by AS updated_by_23, b0_.deleted_by AS deleted_by_24, b0_.language AS language_25 FROM banners b0_ INNER JOIN language l1_ ON b0_.language = l1_.id WHERE l1_.locale = ? AND b0_.deleted_by IS NULL AND b0_.visible = ? AND b0_.button_text IS NOT NULL AND b0_.visible_in_promotions = ? ORDER BY b0_.position ASC
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.visible AS visible_4, b0_.visible_in_promotions AS visible_in_promotions_5, b0_.url AS url_6, b0_.position AS position_7, b0_.color AS color_8, b0_.additional_text AS additional_text_9, b0_.button_color AS button_color_10, b0_.button_text_color AS button_text_color_11, b0_.campaign_text_color AS campaign_text_color_12, b0_.button_text AS button_text_13, b0_.bottom_button_text AS bottom_button_text_14, b0_.bottom_button_text_color AS bottom_button_text_color_15, b0_.bottom_button_color AS bottom_button_color_16, b0_.bottom_background_color AS bottom_background_color_17, b0_.bottom_text_color AS bottom_text_color_18, b0_.image_name AS image_name_19, b0_.created_at AS created_at_20, b0_.updated_at AS updated_at_21, b0_.created_by AS created_by_22, b0_.updated_by AS updated_by_23, b0_.deleted_by AS deleted_by_24, b0_.language AS language_25 FROM banners b0_ INNER JOIN language l1_ ON b0_.language = l1_.id WHERE l1_.locale = 'pl' AND b0_.deleted_by IS NULL AND b0_.visible = 1 AND b0_.button_text IS NOT NULL AND b0_.visible_in_promotions = 1 ORDER BY b0_.position ASC;
|
| 48 |
29.88 ms |
SELECT t0.id AS id_1, t0.shipping_cost AS shipping_cost_2, t0.session AS session_3, t0.ip AS ip_4, t0.user_agent AS user_agent_5, t0.rebate_code_content AS rebate_code_content_6, t0.removed_products_notiication AS removed_products_notiication_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.deleted_by AS deleted_by_12, t0.user_id AS user_id_13, t0.delivery_country_id AS delivery_country_id_14, t0.language_id AS language_id_15, t0.delivery_method_id AS delivery_method_id_16, t0.payment_method_id AS payment_method_id_17, t0.rebate_code_id AS rebate_code_id_18 FROM cart t0 WHERE t0.session IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.shipping_cost AS shipping_cost_2, t0.session AS session_3, t0.ip AS ip_4, t0.user_agent AS user_agent_5, t0.rebate_code_content AS rebate_code_content_6, t0.removed_products_notiication AS removed_products_notiication_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.deleted_by AS deleted_by_12, t0.user_id AS user_id_13, t0.delivery_country_id AS delivery_country_id_14, t0.language_id AS language_id_15, t0.delivery_method_id AS delivery_method_id_16, t0.payment_method_id AS payment_method_id_17, t0.rebate_code_id AS rebate_code_id_18 FROM cart t0 WHERE t0.session IS NULL LIMIT 1;
|
| 49 |
0.54 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.inscription AS inscription_3, t0.price AS price_4, t0.session AS session_5, t0.code AS code_6, t0.price_initial AS price_initial_7, t0.price_net AS price_net_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.cart_id AS cart_id_14, t0.product_id AS product_id_15, t0.sub_product_id AS sub_product_id_16, t0.currency_id AS currency_id_17, t0.vat_id AS vat_id_18, t0.variant_id AS variant_id_19 FROM cart_product t0 WHERE t0.cart_id = ? ORDER BY t0.id DESC
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.inscription AS inscription_3, t0.price AS price_4, t0.session AS session_5, t0.code AS code_6, t0.price_initial AS price_initial_7, t0.price_net AS price_net_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13, t0.cart_id AS cart_id_14, t0.product_id AS product_id_15, t0.sub_product_id AS sub_product_id_16, t0.currency_id AS currency_id_17, t0.vat_id AS vat_id_18, t0.variant_id AS variant_id_19 FROM cart_product t0 WHERE t0.cart_id = 239957 ORDER BY t0.id DESC;
|
| 50 |
0.83 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.is_active AS is_active_2, t0_.text_left AS text_left_3, t0_.text_right AS text_right_4, t0_.url AS url_5, t0_.background AS background_6, t0_.text_color AS text_color_7, t0_.end_date AS end_date_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.created_by AS created_by_11, t0_.updated_by AS updated_by_12, t0_.deleted_by AS deleted_by_13, t0_.language AS language_14 FROM top_banner t0_ INNER JOIN language l1_ ON t0_.language = l1_.id WHERE t0_.deleted_by IS NULL AND l1_.locale = ? AND t0_.is_active = ?
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.is_active AS is_active_2, t0_.text_left AS text_left_3, t0_.text_right AS text_right_4, t0_.url AS url_5, t0_.background AS background_6, t0_.text_color AS text_color_7, t0_.end_date AS end_date_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.created_by AS created_by_11, t0_.updated_by AS updated_by_12, t0_.deleted_by AS deleted_by_13, t0_.language AS language_14 FROM top_banner t0_ INNER JOIN language l1_ ON t0_.language = l1_.id WHERE t0_.deleted_by IS NULL AND l1_.locale = 'pl' AND t0_.is_active = 1;
|
| 51 |
0.08 ms |
SELECT t0.id AS id_1, t0.session AS session_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM compare_product t0 WHERE t0.session IS NULL
SELECT t0.id AS id_1, t0.session AS session_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM compare_product t0 WHERE t0.session IS NULL;
|
| 52 |
0.10 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.deleted_by IS NULL AND t0.locale = ? LIMIT 1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.deleted_by IS NULL AND t0.locale = 'pl' LIMIT 1;
|
| 53 |
0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.custom_h1 AS custom_h1_7, t0.canonical AS canonical_8, t0.slug AS slug_9, t0.google_product_type AS google_product_type_10, t0.google_product_category AS google_product_category_11, t0.special_product_category AS special_product_category_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM category_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.custom_h1 AS custom_h1_7, t0.canonical AS canonical_8, t0.slug AS slug_9, t0.google_product_type AS google_product_type_10, t0.google_product_category AS google_product_category_11, t0.special_product_category AS special_product_category_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM category_translation t0 WHERE t0.translatable_id = 121;
|
| 54 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.custom_h1 AS custom_h1_7, t0.canonical AS canonical_8, t0.slug AS slug_9, t0.google_product_type AS google_product_type_10, t0.google_product_category AS google_product_category_11, t0.special_product_category AS special_product_category_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM category_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.custom_h1 AS custom_h1_7, t0.canonical AS canonical_8, t0.slug AS slug_9, t0.google_product_type AS google_product_type_10, t0.google_product_category AS google_product_category_11, t0.special_product_category AS special_product_category_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM category_translation t0 WHERE t0.translatable_id = 237;
|