| 1 |
0.23 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.40 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/dywan-soil-dark-gray/4807/p"
]
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/dywan-soil-dark-gray/4807/p' LIMIT 1;
|
| 3 |
0.21 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.21 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 |
5.25 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, p13_.id AS id_200, p13_.main AS main_201, p13_.lifestyle AS lifestyle_202, p13_.hover AS hover_203, p13_.name AS name_204, p13_.image_name AS image_name_205, p13_.position AS position_206, p13_.alt AS alt_207, p13_.image_custom_name AS image_custom_name_208, p0_.product_family_id AS product_family_id_209, p0_.product_producer_id AS product_producer_id_210, p0_.availability_id AS availability_id_211, p0_.main_category_id AS main_category_id_212, p6_.translatable_id AS translatable_id_213, p1_.product_id AS product_id_214, p1_.language AS language_215, p1_.vat_id AS vat_id_216, p1_.availability_id AS availability_id_217, p1_.product_producer_id AS product_producer_id_218, l7_.currency_id AS currency_id_219, a9_.translatable_id AS translatable_id_220, p3_.product_id AS product_id_221, l11_.currency_id AS currency_id_222, p12_.product_id AS product_id_223, p12_.parent_product_price_id AS parent_product_price_id_224, p12_.currency_id AS currency_id_225, p12_.language AS language_226, p13_.product_id AS product_id_227 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 p14_ ON p3_.id = p14_.product_photo_id INNER JOIN language l11_ ON l11_.id = p14_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l15_ ON p12_.language = l15_.id LEFT JOIN product_photo p13_ ON p0_.id = p13_.product_id WHERE p6_.locale = ? AND a9_.locale = ? AND l15_.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 p0_.id = ? GROUP BY p13_.id ORDER BY p3_.position ASC, p13_.position ASC
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
1
"4807"
]
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,
p13_.id AS id_200,
p13_.main AS main_201,
p13_.lifestyle AS lifestyle_202,
p13_.hover AS hover_203,
p13_.name AS name_204,
p13_.image_name AS image_name_205,
p13_.position AS position_206,
p13_.alt AS alt_207,
p13_.image_custom_name AS image_custom_name_208,
p0_.product_family_id AS product_family_id_209,
p0_.product_producer_id AS product_producer_id_210,
p0_.availability_id AS availability_id_211,
p0_.main_category_id AS main_category_id_212,
p6_.translatable_id AS translatable_id_213,
p1_.product_id AS product_id_214,
p1_.language AS language_215,
p1_.vat_id AS vat_id_216,
p1_.availability_id AS availability_id_217,
p1_.product_producer_id AS product_producer_id_218,
l7_.currency_id AS currency_id_219,
a9_.translatable_id AS translatable_id_220,
p3_.product_id AS product_id_221,
l11_.currency_id AS currency_id_222,
p12_.product_id AS product_id_223,
p12_.parent_product_price_id AS parent_product_price_id_224,
p12_.currency_id AS currency_id_225,
p12_.language AS language_226,
p13_.product_id AS product_id_227
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 p14_ ON p3_.id = p14_.product_photo_id
INNER JOIN language l11_ ON l11_.id = p14_.language_id
LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id
LEFT JOIN language l15_ ON p12_.language = l15_.id
LEFT JOIN product_photo p13_ ON p0_.id = p13_.product_id
WHERE
p6_.locale = ?
AND a9_.locale = ?
AND l15_.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 p0_.id = ?
GROUP BY
p13_.id
ORDER BY
p3_.position ASC,
p13_.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, p13_.id AS id_200, p13_.main AS main_201, p13_.lifestyle AS lifestyle_202, p13_.hover AS hover_203, p13_.name AS name_204, p13_.image_name AS image_name_205, p13_.position AS position_206, p13_.alt AS alt_207, p13_.image_custom_name AS image_custom_name_208, p0_.product_family_id AS product_family_id_209, p0_.product_producer_id AS product_producer_id_210, p0_.availability_id AS availability_id_211, p0_.main_category_id AS main_category_id_212, p6_.translatable_id AS translatable_id_213, p1_.product_id AS product_id_214, p1_.language AS language_215, p1_.vat_id AS vat_id_216, p1_.availability_id AS availability_id_217, p1_.product_producer_id AS product_producer_id_218, l7_.currency_id AS currency_id_219, a9_.translatable_id AS translatable_id_220, p3_.product_id AS product_id_221, l11_.currency_id AS currency_id_222, p12_.product_id AS product_id_223, p12_.parent_product_price_id AS parent_product_price_id_224, p12_.currency_id AS currency_id_225, p12_.language AS language_226, p13_.product_id AS product_id_227 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 p14_ ON p3_.id = p14_.product_photo_id INNER JOIN language l11_ ON l11_.id = p14_.language_id LEFT JOIN product_price p12_ ON p0_.id = p12_.product_id LEFT JOIN language l15_ ON p12_.language = l15_.id LEFT JOIN product_photo p13_ ON p0_.id = p13_.product_id WHERE p6_.locale = 'pl' AND a9_.locale = 'pl' AND l15_.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 p0_.id = '4807' GROUP BY p13_.id ORDER BY p3_.position ASC, p13_.position ASC;
|
| 6 |
0.17 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 = '4';
|
| 7 |
0.14 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;
|
| 8 |
0.32 ms |
SELECT t0.id AS id_1, t0.is_filter AS is_filter_2, t0.choosable AS choosable_3, t0.group_name AS group_name_4, t0.simple AS simple_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10 FROM product_parameter t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_filter AS is_filter_2, t0.choosable AS choosable_3, t0.group_name AS group_name_4, t0.simple AS simple_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10 FROM product_parameter t0 WHERE t0.id = 8;
|
| 9 |
1.39 ms |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.created_by AS created_by_3, p0_.updated_by AS updated_by_4, p0_.deleted_by AS deleted_by_5, p0_.product_id AS product_id_6, p0_.product_price_id AS product_price_id_7, p0_.parameter_id AS parameter_id_8, p0_.product_parameter_value_id AS product_parameter_value_id_9, p0_.product_parameter_value_group_id AS product_parameter_value_group_id_10 FROM product_price_variants p0_ LEFT JOIN product_price p1_ ON p0_.product_price_id = p1_.id WHERE p0_.product_id = ? AND p0_.parameter_id = ? AND p0_.deleted_by IS NULL AND p1_.deleted_by IS NULL ORDER BY p1_.price ASC
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.created_by AS created_by_3, p0_.updated_by AS updated_by_4, p0_.deleted_by AS deleted_by_5, p0_.product_id AS product_id_6, p0_.product_price_id AS product_price_id_7, p0_.parameter_id AS parameter_id_8, p0_.product_parameter_value_id AS product_parameter_value_id_9, p0_.product_parameter_value_group_id AS product_parameter_value_group_id_10 FROM product_price_variants p0_ LEFT JOIN product_price p1_ ON p0_.product_price_id = p1_.id WHERE p0_.product_id = 4807 AND p0_.parameter_id = 8 AND p0_.deleted_by IS NULL AND p1_.deleted_by IS NULL ORDER BY p1_.price ASC;
|
| 10 |
1.56 ms |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.created_by AS created_by_3, p0_.updated_by AS updated_by_4, p0_.deleted_by AS deleted_by_5, p1_.id AS id_6, p1_.symbol AS symbol_7, p1_.photo3d AS photo3d_8, p1_.is_variants AS is_variants_9, p1_.is_palette_delivery AS is_palette_delivery_10, p1_.payu AS payu_11, p1_.automatic_price AS automatic_price_12, p1_.halmar_stock_exchange AS halmar_stock_exchange_13, p1_.diablo_stock_exchange AS diablo_stock_exchange_14, p1_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_15, p1_.actona_stock_exchange AS actona_stock_exchange_16, p1_.unique_stock_exchange AS unique_stock_exchange_17, p1_.is_compare AS is_compare_18, p1_.priority_search_engine AS priority_search_engine_19, p1_.is_negotiate AS is_negotiate_20, p1_.is_rebate_code AS is_rebate_code_21, p1_.old_price AS old_price_22, p1_.film AS film_23, p1_.small_product_photo AS small_product_photo_24, p1_.max_quantity AS max_quantity_25, p1_.listingMarkersIds AS listingMarkersIds_26, p1_.temporary_unavailable AS temporary_unavailable_27, p1_.last_ranking_update AS last_ranking_update_28, p1_.height AS height_29, p1_.width AS width_30, p1_.depth AS depth_31, p1_.shipping_category AS shipping_category_32, p1_.created_at AS created_at_33, p1_.updated_at AS updated_at_34, p1_.created_by AS created_by_35, p1_.updated_by AS updated_by_36, p1_.deleted_by AS deleted_by_37, p2_.id AS id_38, p2_.path AS path_39, p2_.cart AS cart_40, p2_.visible AS visible_41, p2_.image_name AS image_name_42, p2_.created_at AS created_at_43, p2_.updated_at AS updated_at_44, p2_.created_by AS created_by_45, p2_.updated_by AS updated_by_46, p2_.deleted_by AS deleted_by_47, p3_.id AS id_48, p3_.value AS value_49, p3_.cart AS cart_50, p3_.short_description AS short_description_51, p3_.visible AS visible_52, p3_.path AS path_53, p3_.photo3d AS photo3d_54, p3_.image_name AS image_name_55, p3_.created_at AS created_at_56, p3_.updated_at AS updated_at_57, p3_.created_by AS created_by_58, p3_.updated_by AS updated_by_59, p3_.deleted_by AS deleted_by_60, p4_.id AS id_61, p4_.name AS name_62, p4_.description AS description_63, p4_.locale AS locale_64, p5_.id AS id_65, p5_.value AS value_66, p5_.cart AS cart_67, p5_.short_description AS short_description_68, p5_.visible AS visible_69, p5_.path AS path_70, p5_.photo3d AS photo3d_71, p5_.image_name AS image_name_72, p5_.created_at AS created_at_73, p5_.updated_at AS updated_at_74, p5_.created_by AS created_by_75, p5_.updated_by AS updated_by_76, p5_.deleted_by AS deleted_by_77, p6_.id AS id_78, p6_.is_filter AS is_filter_79, p6_.choosable AS choosable_80, p6_.group_name AS group_name_81, p6_.simple AS simple_82, p6_.created_at AS created_at_83, p6_.updated_at AS updated_at_84, p6_.created_by AS created_by_85, p6_.updated_by AS updated_by_86, p6_.deleted_by AS deleted_by_87, p7_.id AS id_88, p7_.name AS name_89, p7_.locale AS locale_90, p8_.id AS id_91, p8_.name AS name_92, p8_.locale AS locale_93, p0_.product_id AS product_id_94, p0_.product_price_id AS product_price_id_95, p0_.parameter_id AS parameter_id_96, p0_.product_parameter_value_id AS product_parameter_value_id_97, p0_.product_parameter_value_group_id AS product_parameter_value_group_id_98, p1_.product_family_id AS product_family_id_99, p1_.product_producer_id AS product_producer_id_100, p1_.availability_id AS availability_id_101, p1_.main_category_id AS main_category_id_102, p2_.parameter_id AS parameter_id_103, p3_.parameter_id AS parameter_id_104, p3_.group_id AS group_id_105, p4_.translatable_id AS translatable_id_106, p5_.parameter_id AS parameter_id_107, p5_.group_id AS group_id_108, p7_.translatable_id AS translatable_id_109, p8_.translatable_id AS translatable_id_110 FROM product_price_variants p0_ LEFT JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_parameter_value_group p2_ ON p0_.product_parameter_value_group_id = p2_.id LEFT JOIN product_parameter_value p3_ ON p0_.product_parameter_value_id = p3_.id LEFT JOIN product_parameter_value_group_translation p4_ ON p2_.id = p4_.translatable_id LEFT JOIN product_parameter_value p5_ ON p2_.id = p5_.group_id LEFT JOIN product_parameter p6_ ON p5_.parameter_id = p6_.id LEFT JOIN product_parameter_translation p7_ ON p6_.id = p7_.translatable_id INNER JOIN product_parameter_value_translation p8_ ON p5_.id = p8_.translatable_id LEFT JOIN product_price p9_ ON p0_.product_price_id = p9_.id INNER JOIN language l10_ ON p9_.language = l10_.id WHERE p1_.id = ? AND p4_.locale = ? AND p7_.locale = ? AND p8_.locale = ? AND p0_.deleted_by IS NULL AND p9_.deleted_by IS NULL AND p9_.active = 1 AND l10_.locale = ? GROUP BY p2_.id ORDER BY p9_.price ASC, p5_.id DESC
Parameters: [
4807
"pl"
"pl"
"pl"
"pl"
]
SELECT
p0_.id AS id_0,
p0_.created_at AS created_at_1,
p0_.updated_at AS updated_at_2,
p0_.created_by AS created_by_3,
p0_.updated_by AS updated_by_4,
p0_.deleted_by AS deleted_by_5,
p1_.id AS id_6,
p1_.symbol AS symbol_7,
p1_.photo3d AS photo3d_8,
p1_.is_variants AS is_variants_9,
p1_.is_palette_delivery AS is_palette_delivery_10,
p1_.payu AS payu_11,
p1_.automatic_price AS automatic_price_12,
p1_.halmar_stock_exchange AS halmar_stock_exchange_13,
p1_.diablo_stock_exchange AS diablo_stock_exchange_14,
p1_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_15,
p1_.actona_stock_exchange AS actona_stock_exchange_16,
p1_.unique_stock_exchange AS unique_stock_exchange_17,
p1_.is_compare AS is_compare_18,
p1_.priority_search_engine AS priority_search_engine_19,
p1_.is_negotiate AS is_negotiate_20,
p1_.is_rebate_code AS is_rebate_code_21,
p1_.old_price AS old_price_22,
p1_.film AS film_23,
p1_.small_product_photo AS small_product_photo_24,
p1_.max_quantity AS max_quantity_25,
p1_.listingMarkersIds AS listingMarkersIds_26,
p1_.temporary_unavailable AS temporary_unavailable_27,
p1_.last_ranking_update AS last_ranking_update_28,
p1_.height AS height_29,
p1_.width AS width_30,
p1_.depth AS depth_31,
p1_.shipping_category AS shipping_category_32,
p1_.created_at AS created_at_33,
p1_.updated_at AS updated_at_34,
p1_.created_by AS created_by_35,
p1_.updated_by AS updated_by_36,
p1_.deleted_by AS deleted_by_37,
p2_.id AS id_38,
p2_.path AS path_39,
p2_.cart AS cart_40,
p2_.visible AS visible_41,
p2_.image_name AS image_name_42,
p2_.created_at AS created_at_43,
p2_.updated_at AS updated_at_44,
p2_.created_by AS created_by_45,
p2_.updated_by AS updated_by_46,
p2_.deleted_by AS deleted_by_47,
p3_.id AS id_48,
p3_.value AS value_49,
p3_.cart AS cart_50,
p3_.short_description AS short_description_51,
p3_.visible AS visible_52,
p3_.path AS path_53,
p3_.photo3d AS photo3d_54,
p3_.image_name AS image_name_55,
p3_.created_at AS created_at_56,
p3_.updated_at AS updated_at_57,
p3_.created_by AS created_by_58,
p3_.updated_by AS updated_by_59,
p3_.deleted_by AS deleted_by_60,
p4_.id AS id_61,
p4_.name AS name_62,
p4_.description AS description_63,
p4_.locale AS locale_64,
p5_.id AS id_65,
p5_.value AS value_66,
p5_.cart AS cart_67,
p5_.short_description AS short_description_68,
p5_.visible AS visible_69,
p5_.path AS path_70,
p5_.photo3d AS photo3d_71,
p5_.image_name AS image_name_72,
p5_.created_at AS created_at_73,
p5_.updated_at AS updated_at_74,
p5_.created_by AS created_by_75,
p5_.updated_by AS updated_by_76,
p5_.deleted_by AS deleted_by_77,
p6_.id AS id_78,
p6_.is_filter AS is_filter_79,
p6_.choosable AS choosable_80,
p6_.group_name AS group_name_81,
p6_.simple AS simple_82,
p6_.created_at AS created_at_83,
p6_.updated_at AS updated_at_84,
p6_.created_by AS created_by_85,
p6_.updated_by AS updated_by_86,
p6_.deleted_by AS deleted_by_87,
p7_.id AS id_88,
p7_.name AS name_89,
p7_.locale AS locale_90,
p8_.id AS id_91,
p8_.name AS name_92,
p8_.locale AS locale_93,
p0_.product_id AS product_id_94,
p0_.product_price_id AS product_price_id_95,
p0_.parameter_id AS parameter_id_96,
p0_.product_parameter_value_id AS product_parameter_value_id_97,
p0_.product_parameter_value_group_id AS product_parameter_value_group_id_98,
p1_.product_family_id AS product_family_id_99,
p1_.product_producer_id AS product_producer_id_100,
p1_.availability_id AS availability_id_101,
p1_.main_category_id AS main_category_id_102,
p2_.parameter_id AS parameter_id_103,
p3_.parameter_id AS parameter_id_104,
p3_.group_id AS group_id_105,
p4_.translatable_id AS translatable_id_106,
p5_.parameter_id AS parameter_id_107,
p5_.group_id AS group_id_108,
p7_.translatable_id AS translatable_id_109,
p8_.translatable_id AS translatable_id_110
FROM
product_price_variants p0_
LEFT JOIN product p1_ ON p0_.product_id = p1_.id
LEFT JOIN product_parameter_value_group p2_ ON p0_.product_parameter_value_group_id = p2_.id
LEFT JOIN product_parameter_value p3_ ON p0_.product_parameter_value_id = p3_.id
LEFT JOIN product_parameter_value_group_translation p4_ ON p2_.id = p4_.translatable_id
LEFT JOIN product_parameter_value p5_ ON p2_.id = p5_.group_id
LEFT JOIN product_parameter p6_ ON p5_.parameter_id = p6_.id
LEFT JOIN product_parameter_translation p7_ ON p6_.id = p7_.translatable_id
INNER JOIN product_parameter_value_translation p8_ ON p5_.id = p8_.translatable_id
LEFT JOIN product_price p9_ ON p0_.product_price_id = p9_.id
INNER JOIN language l10_ ON p9_.language = l10_.id
WHERE
p1_.id = ?
AND p4_.locale = ?
AND p7_.locale = ?
AND p8_.locale = ?
AND p0_.deleted_by IS NULL
AND p9_.deleted_by IS NULL
AND p9_.active = 1
AND l10_.locale = ?
GROUP BY
p2_.id
ORDER BY
p9_.price ASC,
p5_.id DESC
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.created_by AS created_by_3, p0_.updated_by AS updated_by_4, p0_.deleted_by AS deleted_by_5, p1_.id AS id_6, p1_.symbol AS symbol_7, p1_.photo3d AS photo3d_8, p1_.is_variants AS is_variants_9, p1_.is_palette_delivery AS is_palette_delivery_10, p1_.payu AS payu_11, p1_.automatic_price AS automatic_price_12, p1_.halmar_stock_exchange AS halmar_stock_exchange_13, p1_.diablo_stock_exchange AS diablo_stock_exchange_14, p1_.jan_nowak_stock_exchange AS jan_nowak_stock_exchange_15, p1_.actona_stock_exchange AS actona_stock_exchange_16, p1_.unique_stock_exchange AS unique_stock_exchange_17, p1_.is_compare AS is_compare_18, p1_.priority_search_engine AS priority_search_engine_19, p1_.is_negotiate AS is_negotiate_20, p1_.is_rebate_code AS is_rebate_code_21, p1_.old_price AS old_price_22, p1_.film AS film_23, p1_.small_product_photo AS small_product_photo_24, p1_.max_quantity AS max_quantity_25, p1_.listingMarkersIds AS listingMarkersIds_26, p1_.temporary_unavailable AS temporary_unavailable_27, p1_.last_ranking_update AS last_ranking_update_28, p1_.height AS height_29, p1_.width AS width_30, p1_.depth AS depth_31, p1_.shipping_category AS shipping_category_32, p1_.created_at AS created_at_33, p1_.updated_at AS updated_at_34, p1_.created_by AS created_by_35, p1_.updated_by AS updated_by_36, p1_.deleted_by AS deleted_by_37, p2_.id AS id_38, p2_.path AS path_39, p2_.cart AS cart_40, p2_.visible AS visible_41, p2_.image_name AS image_name_42, p2_.created_at AS created_at_43, p2_.updated_at AS updated_at_44, p2_.created_by AS created_by_45, p2_.updated_by AS updated_by_46, p2_.deleted_by AS deleted_by_47, p3_.id AS id_48, p3_.value AS value_49, p3_.cart AS cart_50, p3_.short_description AS short_description_51, p3_.visible AS visible_52, p3_.path AS path_53, p3_.photo3d AS photo3d_54, p3_.image_name AS image_name_55, p3_.created_at AS created_at_56, p3_.updated_at AS updated_at_57, p3_.created_by AS created_by_58, p3_.updated_by AS updated_by_59, p3_.deleted_by AS deleted_by_60, p4_.id AS id_61, p4_.name AS name_62, p4_.description AS description_63, p4_.locale AS locale_64, p5_.id AS id_65, p5_.value AS value_66, p5_.cart AS cart_67, p5_.short_description AS short_description_68, p5_.visible AS visible_69, p5_.path AS path_70, p5_.photo3d AS photo3d_71, p5_.image_name AS image_name_72, p5_.created_at AS created_at_73, p5_.updated_at AS updated_at_74, p5_.created_by AS created_by_75, p5_.updated_by AS updated_by_76, p5_.deleted_by AS deleted_by_77, p6_.id AS id_78, p6_.is_filter AS is_filter_79, p6_.choosable AS choosable_80, p6_.group_name AS group_name_81, p6_.simple AS simple_82, p6_.created_at AS created_at_83, p6_.updated_at AS updated_at_84, p6_.created_by AS created_by_85, p6_.updated_by AS updated_by_86, p6_.deleted_by AS deleted_by_87, p7_.id AS id_88, p7_.name AS name_89, p7_.locale AS locale_90, p8_.id AS id_91, p8_.name AS name_92, p8_.locale AS locale_93, p0_.product_id AS product_id_94, p0_.product_price_id AS product_price_id_95, p0_.parameter_id AS parameter_id_96, p0_.product_parameter_value_id AS product_parameter_value_id_97, p0_.product_parameter_value_group_id AS product_parameter_value_group_id_98, p1_.product_family_id AS product_family_id_99, p1_.product_producer_id AS product_producer_id_100, p1_.availability_id AS availability_id_101, p1_.main_category_id AS main_category_id_102, p2_.parameter_id AS parameter_id_103, p3_.parameter_id AS parameter_id_104, p3_.group_id AS group_id_105, p4_.translatable_id AS translatable_id_106, p5_.parameter_id AS parameter_id_107, p5_.group_id AS group_id_108, p7_.translatable_id AS translatable_id_109, p8_.translatable_id AS translatable_id_110 FROM product_price_variants p0_ LEFT JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_parameter_value_group p2_ ON p0_.product_parameter_value_group_id = p2_.id LEFT JOIN product_parameter_value p3_ ON p0_.product_parameter_value_id = p3_.id LEFT JOIN product_parameter_value_group_translation p4_ ON p2_.id = p4_.translatable_id LEFT JOIN product_parameter_value p5_ ON p2_.id = p5_.group_id LEFT JOIN product_parameter p6_ ON p5_.parameter_id = p6_.id LEFT JOIN product_parameter_translation p7_ ON p6_.id = p7_.translatable_id INNER JOIN product_parameter_value_translation p8_ ON p5_.id = p8_.translatable_id LEFT JOIN product_price p9_ ON p0_.product_price_id = p9_.id INNER JOIN language l10_ ON p9_.language = l10_.id WHERE p1_.id = 4807 AND p4_.locale = 'pl' AND p7_.locale = 'pl' AND p8_.locale = 'pl' AND p0_.deleted_by IS NULL AND p9_.deleted_by IS NULL AND p9_.active = 1 AND l10_.locale = 'pl' GROUP BY p2_.id ORDER BY p9_.price ASC, p5_.id DESC;
|
| 11 |
35.80 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 p0_.product_family_id = ? AND p0_.id <> ? ORDER BY p3_.position ASC
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
1
241
4807
]
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 p0_.product_family_id = ?
AND p0_.id <> ?
ORDER BY
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 p0_.product_family_id = 241 AND p0_.id <> 4807 ORDER BY p3_.position ASC;
|
| 12 |
0.58 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_by AS deleted_by_6, t0.product_id AS product_id_7, t0.accessory_id AS accessory_id_8 FROM product_recommendation t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_by AS deleted_by_6, t0.product_id AS product_id_7, t0.accessory_id AS accessory_id_8 FROM product_recommendation t0 WHERE t0.product_id = 4807;
|
| 13 |
1.42 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 p0_.id IN (?) GROUP BY p0_.id ORDER BY p0_.priority_search_engine ASC, p3_.position ASC
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
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 p0_.id IN (?)
GROUP BY
p0_.id
ORDER BY
p0_.priority_search_engine 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 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 p0_.id IN () GROUP BY p0_.id ORDER BY p0_.priority_search_engine ASC, p3_.position ASC;
|
| 14 |
0.28 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_by AS deleted_by_6, t0.product_id AS product_id_7, t0.accessory_id AS accessory_id_8 FROM product_similar_colors t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_by AS deleted_by_6, t0.product_id AS product_id_7, t0.accessory_id AS accessory_id_8 FROM product_similar_colors t0 WHERE t0.product_id = 4807;
|
| 15 |
0.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 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 p0_.id IN (?) GROUP BY p0_.id ORDER BY p0_.priority_search_engine ASC, p3_.position ASC
Parameters: [
"pl"
"pl"
"pl"
1
"pl"
"pl"
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 p0_.id IN (?)
GROUP BY
p0_.id
ORDER BY
p0_.priority_search_engine 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 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 p0_.id IN () GROUP BY p0_.id ORDER BY p0_.priority_search_engine ASC, p3_.position ASC;
|
| 16 |
1.10 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount AS discount_3, t0.old_price AS old_price_4, t0.active AS active_5, t0.automatic_price_comment AS automatic_price_comment_6, t0.ean AS ean_7, t0.automatic_price AS automatic_price_8, t0.automatic_price_discount AS automatic_price_discount_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.deleted_by AS deleted_by_14, t0.product_id AS product_id_15, t0.parent_product_price_id AS parent_product_price_id_16, t0.currency_id AS currency_id_17, t0.language AS language_18 FROM product_price t0 WHERE t0.active = ? AND t0.product_id = ? AND t0.language = ? AND t0.deleted_by IS NULL ORDER BY t0.price ASC
SELECT t0.id AS id_1, t0.price AS price_2, t0.discount AS discount_3, t0.old_price AS old_price_4, t0.active AS active_5, t0.automatic_price_comment AS automatic_price_comment_6, t0.ean AS ean_7, t0.automatic_price AS automatic_price_8, t0.automatic_price_discount AS automatic_price_discount_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.deleted_by AS deleted_by_14, t0.product_id AS product_id_15, t0.parent_product_price_id AS parent_product_price_id_16, t0.currency_id AS currency_id_17, t0.language AS language_18 FROM product_price t0 WHERE t0.active = 1 AND t0.product_id = 4807 AND t0.language = 1 AND t0.deleted_by IS NULL ORDER BY t0.price ASC;
|
| 17 |
0.83 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_by AS deleted_by_6, t0.product_id AS product_id_7, t0.product_price_id AS product_price_id_8, t0.parameter_id AS parameter_id_9, t0.product_parameter_value_id AS product_parameter_value_id_10, t11.id AS id_12, t11.value AS value_13, t11.cart AS cart_14, t11.short_description AS short_description_15, t11.visible AS visible_16, t11.path AS path_17, t11.photo3d AS photo3d_18, t11.image_name AS image_name_19, t11.created_at AS created_at_20, t11.updated_at AS updated_at_21, t11.created_by AS created_by_22, t11.updated_by AS updated_by_23, t11.deleted_by AS deleted_by_24, t11.parameter_id AS parameter_id_25, t11.group_id AS group_id_26, t0.product_parameter_value_group_id AS product_parameter_value_group_id_27, t28.id AS id_29, t28.path AS path_30, t28.cart AS cart_31, t28.visible AS visible_32, t28.image_name AS image_name_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.created_by AS created_by_36, t28.updated_by AS updated_by_37, t28.deleted_by AS deleted_by_38, t28.parameter_id AS parameter_id_39 FROM product_price_variants t0 LEFT JOIN product_parameter_value t11 ON t0.product_parameter_value_id = t11.id LEFT JOIN product_parameter_value_group t28 ON t0.product_parameter_value_group_id = t28.id WHERE t0.product_price_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_by AS deleted_by_6, t0.product_id AS product_id_7, t0.product_price_id AS product_price_id_8, t0.parameter_id AS parameter_id_9, t0.product_parameter_value_id AS product_parameter_value_id_10, t11.id AS id_12, t11.value AS value_13, t11.cart AS cart_14, t11.short_description AS short_description_15, t11.visible AS visible_16, t11.path AS path_17, t11.photo3d AS photo3d_18, t11.image_name AS image_name_19, t11.created_at AS created_at_20, t11.updated_at AS updated_at_21, t11.created_by AS created_by_22, t11.updated_by AS updated_by_23, t11.deleted_by AS deleted_by_24, t11.parameter_id AS parameter_id_25, t11.group_id AS group_id_26, t0.product_parameter_value_group_id AS product_parameter_value_group_id_27, t28.id AS id_29, t28.path AS path_30, t28.cart AS cart_31, t28.visible AS visible_32, t28.image_name AS image_name_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.created_by AS created_by_36, t28.updated_by AS updated_by_37, t28.deleted_by AS deleted_by_38, t28.parameter_id AS parameter_id_39 FROM product_price_variants t0 LEFT JOIN product_parameter_value t11 ON t0.product_parameter_value_id = t11.id LEFT JOIN product_parameter_value_group t28 ON t0.product_parameter_value_group_id = t28.id WHERE t0.product_price_id = 3587750;
|
| 18 |
1.81 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 product_view t0 WHERE t0.session = ? AND t0.product_id = ? LIMIT 1
Parameters: [
"d99b9ad1637a6beeb762e32ef94bd86b"
4807
]
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 product_view t0 WHERE t0.session = 'd99b9ad1637a6beeb762e32ef94bd86b' AND t0.product_id = 4807 LIMIT 1;
|
| 19 |
0.10 ms |
"START TRANSACTION"
|
| 20 |
0.41 ms |
INSERT INTO product_view (session, created_at, updated_at, product_id) VALUES (?, ?, ?, ?)
Parameters: [
1 => "d99b9ad1637a6beeb762e32ef94bd86b"
2 => "2025-04-17 11:56:59"
3 => "2025-04-17 11:56:59"
4 => 4807
]
INSERT INTO product_view (session, created_at, updated_at, product_id) VALUES ('d99b9ad1637a6beeb762e32ef94bd86b', '2025-04-17 11:56:59', '2025-04-17 11:56:59', 4807);
|
| 21 |
3.10 ms |
"COMMIT"
|
| 22 |
2.98 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.deleted_by IS NULL AND t0.language_id = ? AND t0.special_for_buy_cheaper = ? LIMIT 1
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.deleted_by IS NULL AND t0.language_id = 1 AND t0.special_for_buy_cheaper = 1 LIMIT 1;
|
| 23 |
0.48 ms |
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.discount AS discount_2, p0_.old_price AS old_price_3, p0_.active AS active_4, p0_.automatic_price_comment AS automatic_price_comment_5, p0_.ean AS ean_6, p0_.automatic_price AS automatic_price_7, p0_.automatic_price_discount AS automatic_price_discount_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.created_by AS created_by_11, p0_.updated_by AS updated_by_12, p0_.deleted_by AS deleted_by_13, p0_.product_id AS product_id_14, p0_.parent_product_price_id AS parent_product_price_id_15, p0_.currency_id AS currency_id_16, p0_.language AS language_17 FROM product_price p0_ INNER JOIN language l1_ ON p0_.language = l1_.id WHERE l1_.id = ? AND p0_.product_id = ? AND p0_.deleted_by IS NULL AND p0_.active = 1 ORDER BY p0_.price ASC
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.discount AS discount_2, p0_.old_price AS old_price_3, p0_.active AS active_4, p0_.automatic_price_comment AS automatic_price_comment_5, p0_.ean AS ean_6, p0_.automatic_price AS automatic_price_7, p0_.automatic_price_discount AS automatic_price_discount_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.created_by AS created_by_11, p0_.updated_by AS updated_by_12, p0_.deleted_by AS deleted_by_13, p0_.product_id AS product_id_14, p0_.parent_product_price_id AS parent_product_price_id_15, p0_.currency_id AS currency_id_16, p0_.language AS language_17 FROM product_price p0_ INNER JOIN language l1_ ON p0_.language = l1_.id WHERE l1_.id = 1 AND p0_.product_id = 4807 AND p0_.deleted_by IS NULL AND p0_.active = 1 ORDER BY p0_.price ASC;
|
| 24 |
0.46 ms |
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.price_description AS price_description_3, t0.promotion AS promotion_4, t0.is_new AS is_new_5, t0.bestseller AS bestseller_6, t0.promote_one_homepage AS promote_one_homepage_7, t0.ready_for_publication AS ready_for_publication_8, t0.sale AS sale_9, t0.rating_value AS rating_value_10, t0.review_count AS review_count_11, t0.price_change AS price_change_12, t0.priority AS priority_13, t0.price_crossed AS price_crossed_14, t0.omnibus_price AS omnibus_price_15, t0.promotion_icon AS promotion_icon_16, t0.promo_price AS promo_price_17, t0.product_id AS product_id_18, t0.language AS language_19, t0.vat_id AS vat_id_20, t0.availability_id AS availability_id_21, t0.product_producer_id AS product_producer_id_22 FROM product_lang_param t0 WHERE t0.product_id = ? AND t0.language = ? LIMIT 1
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.price_description AS price_description_3, t0.promotion AS promotion_4, t0.is_new AS is_new_5, t0.bestseller AS bestseller_6, t0.promote_one_homepage AS promote_one_homepage_7, t0.ready_for_publication AS ready_for_publication_8, t0.sale AS sale_9, t0.rating_value AS rating_value_10, t0.review_count AS review_count_11, t0.price_change AS price_change_12, t0.priority AS priority_13, t0.price_crossed AS price_crossed_14, t0.omnibus_price AS omnibus_price_15, t0.promotion_icon AS promotion_icon_16, t0.promo_price AS promo_price_17, t0.product_id AS product_id_18, t0.language AS language_19, t0.vat_id AS vat_id_20, t0.availability_id AS availability_id_21, t0.product_producer_id AS product_producer_id_22 FROM product_lang_param t0 WHERE t0.product_id = 4807 AND t0.language = 1 LIMIT 1;
|
| 25 |
0.16 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_by AS deleted_by_7 FROM product_vat t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_by AS deleted_by_7 FROM product_vat t0 WHERE t0.id = 1;
|
| 26 |
0.10 ms |
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.discount AS discount_2, p0_.old_price AS old_price_3, p0_.active AS active_4, p0_.automatic_price_comment AS automatic_price_comment_5, p0_.ean AS ean_6, p0_.automatic_price AS automatic_price_7, p0_.automatic_price_discount AS automatic_price_discount_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.created_by AS created_by_11, p0_.updated_by AS updated_by_12, p0_.deleted_by AS deleted_by_13, p0_.product_id AS product_id_14, p0_.parent_product_price_id AS parent_product_price_id_15, p0_.currency_id AS currency_id_16, p0_.language AS language_17 FROM product_price p0_ INNER JOIN language l1_ ON p0_.language = l1_.id WHERE l1_.id = ? AND p0_.product_id = ? AND p0_.deleted_by IS NULL AND p0_.active = 1 ORDER BY p0_.price ASC
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.discount AS discount_2, p0_.old_price AS old_price_3, p0_.active AS active_4, p0_.automatic_price_comment AS automatic_price_comment_5, p0_.ean AS ean_6, p0_.automatic_price AS automatic_price_7, p0_.automatic_price_discount AS automatic_price_discount_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.created_by AS created_by_11, p0_.updated_by AS updated_by_12, p0_.deleted_by AS deleted_by_13, p0_.product_id AS product_id_14, p0_.parent_product_price_id AS parent_product_price_id_15, p0_.currency_id AS currency_id_16, p0_.language AS language_17 FROM product_price p0_ INNER JOIN language l1_ ON p0_.language = l1_.id WHERE l1_.id = 1 AND p0_.product_id = 4807 AND p0_.deleted_by IS NULL AND p0_.active = 1 ORDER BY p0_.price ASC;
|
| 27 |
0.11 ms |
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.price_description AS price_description_3, t0.promotion AS promotion_4, t0.is_new AS is_new_5, t0.bestseller AS bestseller_6, t0.promote_one_homepage AS promote_one_homepage_7, t0.ready_for_publication AS ready_for_publication_8, t0.sale AS sale_9, t0.rating_value AS rating_value_10, t0.review_count AS review_count_11, t0.price_change AS price_change_12, t0.priority AS priority_13, t0.price_crossed AS price_crossed_14, t0.omnibus_price AS omnibus_price_15, t0.promotion_icon AS promotion_icon_16, t0.promo_price AS promo_price_17, t0.product_id AS product_id_18, t0.language AS language_19, t0.vat_id AS vat_id_20, t0.availability_id AS availability_id_21, t0.product_producer_id AS product_producer_id_22 FROM product_lang_param t0 WHERE t0.product_id = ? AND t0.language = ? LIMIT 1
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.price_description AS price_description_3, t0.promotion AS promotion_4, t0.is_new AS is_new_5, t0.bestseller AS bestseller_6, t0.promote_one_homepage AS promote_one_homepage_7, t0.ready_for_publication AS ready_for_publication_8, t0.sale AS sale_9, t0.rating_value AS rating_value_10, t0.review_count AS review_count_11, t0.price_change AS price_change_12, t0.priority AS priority_13, t0.price_crossed AS price_crossed_14, t0.omnibus_price AS omnibus_price_15, t0.promotion_icon AS promotion_icon_16, t0.promo_price AS promo_price_17, t0.product_id AS product_id_18, t0.language AS language_19, t0.vat_id AS vat_id_20, t0.availability_id AS availability_id_21, t0.product_producer_id AS product_producer_id_22 FROM product_lang_param t0 WHERE t0.product_id = 4807 AND t0.language = 1 LIMIT 1;
|
| 28 |
0.33 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.color AS color_3, t0.language AS language_4, t0.product_producer_id AS product_producer_id_5, t0.landing_page_id AS landing_page_id_6 FROM marker t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.content AS content_2, t0.color AS color_3, t0.language AS language_4, t0.product_producer_id AS product_producer_id_5, t0.landing_page_id AS landing_page_id_6 FROM marker t0 WHERE t0.id = 788;
|
| 29 |
0.30 ms |
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.price_description AS price_description_3, t0.promotion AS promotion_4, t0.is_new AS is_new_5, t0.bestseller AS bestseller_6, t0.promote_one_homepage AS promote_one_homepage_7, t0.ready_for_publication AS ready_for_publication_8, t0.sale AS sale_9, t0.rating_value AS rating_value_10, t0.review_count AS review_count_11, t0.price_change AS price_change_12, t0.priority AS priority_13, t0.price_crossed AS price_crossed_14, t0.omnibus_price AS omnibus_price_15, t0.promotion_icon AS promotion_icon_16, t0.promo_price AS promo_price_17, t0.product_id AS product_id_18, t0.language AS language_19, t0.vat_id AS vat_id_20, t0.availability_id AS availability_id_21, t0.product_producer_id AS product_producer_id_22 FROM product_lang_param t0 WHERE t0.language = ? AND t0.product_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.price_description AS price_description_3, t0.promotion AS promotion_4, t0.is_new AS is_new_5, t0.bestseller AS bestseller_6, t0.promote_one_homepage AS promote_one_homepage_7, t0.ready_for_publication AS ready_for_publication_8, t0.sale AS sale_9, t0.rating_value AS rating_value_10, t0.review_count AS review_count_11, t0.price_change AS price_change_12, t0.priority AS priority_13, t0.price_crossed AS price_crossed_14, t0.omnibus_price AS omnibus_price_15, t0.promotion_icon AS promotion_icon_16, t0.promo_price AS promo_price_17, t0.product_id AS product_id_18, t0.language AS language_19, t0.vat_id AS vat_id_20, t0.availability_id AS availability_id_21, t0.product_producer_id AS product_producer_id_22 FROM product_lang_param t0 WHERE t0.language = 1 AND t0.product_id = 4807 LIMIT 1;
|
| 30 |
2.06 ms |
SELECT p0_.price_after AS price_after_0, p0_.price_before AS price_before_1, p0_.automatic_price_comment AS automatic_price_comment_2 FROM product_price_change_log p0_ WHERE p0_.product_id = ? AND p0_.language = ? AND p0_.created_at > ? ORDER BY p0_.id DESC
Parameters: [
4807
1
"2025-03-18 11:56:59"
]
SELECT p0_.price_after AS price_after_0, p0_.price_before AS price_before_1, p0_.automatic_price_comment AS automatic_price_comment_2 FROM product_price_change_log p0_ WHERE p0_.product_id = 4807 AND p0_.language = 1 AND p0_.created_at > '2025-03-18 11:56:59' ORDER BY p0_.id DESC;
|
| 31 |
0.64 ms |
SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.viewed AS viewed_2, p0_.content AS content_3, p0_.opinion_rate AS opinion_rate_4, p0_.code AS code_5, p0_.image_name AS image_name_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.created_by AS created_by_9, p0_.updated_by AS updated_by_10, p0_.deleted_by AS deleted_by_11, p0_.user_id AS user_id_12, p0_.order_id AS order_id_13, p0_.language AS language_14 FROM product_comment p0_ INNER JOIN language l1_ ON p0_.language = l1_.id INNER JOIN product_comment_associated_products p3_ ON p0_.id = p3_.product_comment_id INNER JOIN product p2_ ON p2_.id = p3_.product_id WHERE p0_.deleted_by IS NULL AND l1_.locale = ? AND p0_.visible = ? AND p2_.id = ? ORDER BY p0_.id DESC
Parameters: [
"pl"
1
4807
]
SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.viewed AS viewed_2, p0_.content AS content_3, p0_.opinion_rate AS opinion_rate_4, p0_.code AS code_5, p0_.image_name AS image_name_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.created_by AS created_by_9, p0_.updated_by AS updated_by_10, p0_.deleted_by AS deleted_by_11, p0_.user_id AS user_id_12, p0_.order_id AS order_id_13, p0_.language AS language_14 FROM product_comment p0_ INNER JOIN language l1_ ON p0_.language = l1_.id INNER JOIN product_comment_associated_products p3_ ON p0_.id = p3_.product_comment_id INNER JOIN product p2_ ON p2_.id = p3_.product_id WHERE p0_.deleted_by IS NULL AND l1_.locale = 'pl' AND p0_.visible = 1 AND p2_.id = 4807 ORDER BY p0_.id DESC;
|
| 32 |
0.11 ms |
SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.viewed AS viewed_2, p0_.content AS content_3, p0_.opinion_rate AS opinion_rate_4, p0_.code AS code_5, p0_.image_name AS image_name_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.created_by AS created_by_9, p0_.updated_by AS updated_by_10, p0_.deleted_by AS deleted_by_11, p0_.user_id AS user_id_12, p0_.order_id AS order_id_13, p0_.language AS language_14 FROM product_comment p0_ INNER JOIN language l1_ ON p0_.language = l1_.id INNER JOIN product_comment_associated_products p3_ ON p0_.id = p3_.product_comment_id INNER JOIN product p2_ ON p2_.id = p3_.product_id WHERE p0_.deleted_by IS NULL AND l1_.locale = ? AND p0_.visible = ? AND p2_.id = ? ORDER BY p0_.id DESC
Parameters: [
"pl"
1
4807
]
SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.viewed AS viewed_2, p0_.content AS content_3, p0_.opinion_rate AS opinion_rate_4, p0_.code AS code_5, p0_.image_name AS image_name_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.created_by AS created_by_9, p0_.updated_by AS updated_by_10, p0_.deleted_by AS deleted_by_11, p0_.user_id AS user_id_12, p0_.order_id AS order_id_13, p0_.language AS language_14 FROM product_comment p0_ INNER JOIN language l1_ ON p0_.language = l1_.id INNER JOIN product_comment_associated_products p3_ ON p0_.id = p3_.product_comment_id INNER JOIN product p2_ ON p2_.id = p3_.product_id WHERE p0_.deleted_by IS NULL AND l1_.locale = 'pl' AND p0_.visible = 1 AND p2_.id = 4807 ORDER BY p0_.id DESC;
|
| 33 |
0.09 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.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price_net AS price_net_3, t0.price AS price_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10, t0.language_id AS language_id_11 FROM product_equipment t0 INNER JOIN product_equipment_relation ON t0.id = product_equipment_relation.product_equipment_id WHERE product_equipment_relation.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price_net AS price_net_3, t0.price AS price_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10, t0.language_id AS language_id_11 FROM product_equipment t0 INNER JOIN product_equipment_relation ON t0.id = product_equipment_relation.product_equipment_id WHERE product_equipment_relation.product_id = 4807;
|
| 35 |
0.14 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.07 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"
"4"
"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 = '4' AND w0_.working_hours_type = 'main';
|
| 37 |
0.06 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 = '4';
|
| 38 |
1.74 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.21 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 |
0.28 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 |
0.18 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 |
0.15 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 |
0.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 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.09 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 |
0.19 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.08 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;
|
| 47 |
0.06 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;
|
| 48 |
0.08 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;
|
| 49 |
0.06 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;
|
| 50 |
0.05 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;
|
| 51 |
0.07 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;
|
| 52 |
0.08 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;
|
| 53 |
0.06 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;
|