Query Metrics
129
Database Queries
66
Different statements
1356.69 ms
Query time
6
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.44 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
Parameters:
[
1
]
|
2 | 0.39 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-flare/4811/p"
]
|
3 | 0.14 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
Parameters:
[] |
4 | 0.38 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = ? AND t0.deleted_by IS NULL LIMIT 1
Parameters:
[
"pl"
]
|
5 | 14.01 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 "4811" ] |
6 | 0.55 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 = ?
Parameters:
[ "pl" "7" ] |
7 | 0.26 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
Parameters:
[
"pl"
]
|
8 | 0.24 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 = ?
Parameters:
[
8
]
|
9 | 3.84 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
Parameters:
[ 4811 8 ] |
10 | 0.71 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.cart AS cart_3, t0.short_description AS short_description_4, t0.visible AS visible_5, t0.path AS path_6, t0.photo3d AS photo3d_7, t0.image_name AS image_name_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.parameter_id AS parameter_id_14, t0.group_id AS group_id_15 FROM product_parameter_value t0 WHERE t0.id IN (?)
Parameters:
[ [ 4748 4750 ] ] |
11 | 0.46 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.id = ?
Parameters:
[
3648958
]
|
12 | 0.24 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.id = ?
Parameters:
[
3668188
]
|
13 | 0.20 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.id = ?
Parameters:
[
3587928
]
|
14 | 0.19 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.id = ?
Parameters:
[
3668189
]
|
15 | 0.21 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.id = ?
Parameters:
[
3648957
]
|
16 | 0.25 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.id = ?
Parameters:
[
3
]
|
17 | 0.71 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_.price AS price_7, p1_.discount AS discount_8, p1_.old_price AS old_price_9, p1_.active AS active_10, p1_.automatic_price_comment AS automatic_price_comment_11, p1_.ean AS ean_12, p1_.automatic_price AS automatic_price_13, p1_.automatic_price_discount AS automatic_price_discount_14, p1_.created_at AS created_at_15, p1_.updated_at AS updated_at_16, p1_.created_by AS created_by_17, p1_.updated_by AS updated_by_18, p1_.deleted_by AS deleted_by_19, p0_.product_id AS product_id_20, p0_.product_price_id AS product_price_id_21, p0_.parameter_id AS parameter_id_22, p0_.product_parameter_value_id AS product_parameter_value_id_23, p0_.product_parameter_value_group_id AS product_parameter_value_group_id_24, p1_.product_id AS product_id_25, p1_.parent_product_price_id AS parent_product_price_id_26, p1_.currency_id AS currency_id_27, p1_.language AS language_28 FROM product_price_variants p0_ INNER JOIN product_parameter p2_ ON p0_.parameter_id = p2_.id LEFT JOIN product_price p1_ ON p0_.product_price_id = p1_.id WHERE p2_.id IN (?) AND p0_.product_price_id = ? AND p0_.deleted_by IS NULL AND p1_.deleted_by IS NULL ORDER BY p1_.price ASC
Parameters:
[ [ 9 ] 3587927 ] |
18 | 0.36 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.cart AS cart_3, t0.visible AS visible_4, t0.image_name AS image_name_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.parameter_id AS parameter_id_11, t12.id AS id_13, t12.is_filter AS is_filter_14, t12.choosable AS choosable_15, t12.group_name AS group_name_16, t12.simple AS simple_17, t12.created_at AS created_at_18, t12.updated_at AS updated_at_19, t12.created_by AS created_by_20, t12.updated_by AS updated_by_21, t12.deleted_by AS deleted_by_22 FROM product_parameter_value_group t0 LEFT JOIN product_parameter t12 ON t0.parameter_id = t12.id WHERE t0.id IN (?)
Parameters:
[
[
371
]
]
|
19 | 0.25 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.id = ?
Parameters:
[
4
]
|
20 | 0.23 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.id = ?
Parameters:
[
2
]
|
21 | 0.42 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_.price AS price_7, p1_.discount AS discount_8, p1_.old_price AS old_price_9, p1_.active AS active_10, p1_.automatic_price_comment AS automatic_price_comment_11, p1_.ean AS ean_12, p1_.automatic_price AS automatic_price_13, p1_.automatic_price_discount AS automatic_price_discount_14, p1_.created_at AS created_at_15, p1_.updated_at AS updated_at_16, p1_.created_by AS created_by_17, p1_.updated_by AS updated_by_18, p1_.deleted_by AS deleted_by_19, p0_.product_id AS product_id_20, p0_.product_price_id AS product_price_id_21, p0_.parameter_id AS parameter_id_22, p0_.product_parameter_value_id AS product_parameter_value_id_23, p0_.product_parameter_value_group_id AS product_parameter_value_group_id_24, p1_.product_id AS product_id_25, p1_.parent_product_price_id AS parent_product_price_id_26, p1_.currency_id AS currency_id_27, p1_.language AS language_28 FROM product_price_variants p0_ INNER JOIN product_parameter p2_ ON p0_.parameter_id = p2_.id LEFT JOIN product_price p1_ ON p0_.product_price_id = p1_.id WHERE p2_.id IN (?) AND p0_.product_price_id = ? AND p0_.deleted_by IS NULL AND p1_.deleted_by IS NULL ORDER BY p1_.price ASC
Parameters:
[ [ 9 ] 3587928 ] |
22 | 0.28 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.cart AS cart_3, t0.visible AS visible_4, t0.image_name AS image_name_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.parameter_id AS parameter_id_11, t12.id AS id_13, t12.is_filter AS is_filter_14, t12.choosable AS choosable_15, t12.group_name AS group_name_16, t12.simple AS simple_17, t12.created_at AS created_at_18, t12.updated_at AS updated_at_19, t12.created_by AS created_by_20, t12.updated_by AS updated_by_21, t12.deleted_by AS deleted_by_22 FROM product_parameter_value_group t0 LEFT JOIN product_parameter t12 ON t0.parameter_id = t12.id WHERE t0.id IN (?)
Parameters:
[
[
375
]
]
|
23 | 5.33 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:
[ 4811 "pl" "pl" "pl" "pl" ] |
24 | 25.22 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 4811 ] |
25 | 1.06 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 = ?
Parameters:
[
4811
]
|
26 | 1.16 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 [] ] |
27 | 0.42 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 = ?
Parameters:
[
4811
]
|
28 | 0.26 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 [] ] |
29 | 0.43 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.cart AS cart_2, p0_.short_description AS short_description_3, p0_.visible AS visible_4, p0_.path AS path_5, p0_.photo3d AS photo3d_6, p0_.image_name AS image_name_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.created_by AS created_by_10, p0_.updated_by AS updated_by_11, p0_.deleted_by AS deleted_by_12, p1_.id AS id_13, p1_.path AS path_14, p1_.cart AS cart_15, p1_.visible AS visible_16, p1_.image_name AS image_name_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19, p1_.created_by AS created_by_20, p1_.updated_by AS updated_by_21, p1_.deleted_by AS deleted_by_22, p2_.id AS id_23, p2_.is_filter AS is_filter_24, p2_.choosable AS choosable_25, p2_.group_name AS group_name_26, p2_.simple AS simple_27, p2_.created_at AS created_at_28, p2_.updated_at AS updated_at_29, p2_.created_by AS created_by_30, p2_.updated_by AS updated_by_31, p2_.deleted_by AS deleted_by_32, p3_.id AS id_33, p3_.name AS name_34, p3_.locale AS locale_35, p4_.id AS id_36, p4_.name AS name_37, p4_.locale AS locale_38, p0_.parameter_id AS parameter_id_39, p0_.group_id AS group_id_40, p1_.parameter_id AS parameter_id_41, p3_.translatable_id AS translatable_id_42, p4_.translatable_id AS translatable_id_43 FROM product_parameter_value p0_ LEFT JOIN product_parameter_value_group p1_ ON p0_.group_id = p1_.id LEFT JOIN product_parameter p2_ ON p0_.parameter_id = p2_.id LEFT JOIN product_parameter_translation p3_ ON p2_.id = p3_.translatable_id INNER JOIN product_parameter_value_translation p4_ ON p0_.id = p4_.translatable_id WHERE p3_.locale = ? AND p0_.visible = 1 AND p4_.locale = ? AND p0_.group_id = ? AND p0_.deleted_by IS NULL
Parameters:
[ "pl" "pl" 371 ] |
30 | 0.38 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.cart AS cart_2, p0_.short_description AS short_description_3, p0_.visible AS visible_4, p0_.path AS path_5, p0_.photo3d AS photo3d_6, p0_.image_name AS image_name_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.created_by AS created_by_10, p0_.updated_by AS updated_by_11, p0_.deleted_by AS deleted_by_12, p1_.id AS id_13, p1_.path AS path_14, p1_.cart AS cart_15, p1_.visible AS visible_16, p1_.image_name AS image_name_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19, p1_.created_by AS created_by_20, p1_.updated_by AS updated_by_21, p1_.deleted_by AS deleted_by_22, p2_.id AS id_23, p2_.is_filter AS is_filter_24, p2_.choosable AS choosable_25, p2_.group_name AS group_name_26, p2_.simple AS simple_27, p2_.created_at AS created_at_28, p2_.updated_at AS updated_at_29, p2_.created_by AS created_by_30, p2_.updated_by AS updated_by_31, p2_.deleted_by AS deleted_by_32, p3_.id AS id_33, p3_.name AS name_34, p3_.locale AS locale_35, p4_.id AS id_36, p4_.name AS name_37, p4_.locale AS locale_38, p0_.parameter_id AS parameter_id_39, p0_.group_id AS group_id_40, p1_.parameter_id AS parameter_id_41, p3_.translatable_id AS translatable_id_42, p4_.translatable_id AS translatable_id_43 FROM product_parameter_value p0_ LEFT JOIN product_parameter_value_group p1_ ON p0_.group_id = p1_.id LEFT JOIN product_parameter p2_ ON p0_.parameter_id = p2_.id LEFT JOIN product_parameter_translation p3_ ON p2_.id = p3_.translatable_id INNER JOIN product_parameter_value_translation p4_ ON p0_.id = p4_.translatable_id WHERE p3_.locale = ? AND p0_.visible = 1 AND p4_.locale = ? AND p0_.group_id = ? AND p0_.deleted_by IS NULL
Parameters:
[ "pl" "pl" 375 ] |
31 | 0.75 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
Parameters:
[ 1 4811 1 ] |
32 | 0.34 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 = ?
Parameters:
[
3587927
]
|
33 | 0.25 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 = ?
Parameters:
[
3587928
]
|
34 | 0.29 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_.deleted_by IS NULL AND p1_.id = ? AND p1_.deleted_by IS NULL AND p1_.active = 1 ORDER BY p1_.price ASC
Parameters:
[ 4811 3587927 ] |
35 | 0.27 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_.deleted_by IS NULL AND p1_.id = ? AND p1_.deleted_by IS NULL AND p1_.active = 1 ORDER BY p1_.price ASC
Parameters:
[ 4811 3587928 ] |
36 | 1.27 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:
[ "4e34bd3bef08e781e280b5333ce32d19" 4811 ] |
37 | 0.11 ms |
"START TRANSACTION"
Parameters:
[] |
38 | 0.28 ms |
INSERT INTO product_view (session, created_at, updated_at, product_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "4e34bd3bef08e781e280b5333ce32d19" 2 => "2025-04-06 19:39:56" 3 => "2025-04-06 19:39:56" 4 => 4811 ] |
39 | 2.87 ms |
"COMMIT"
Parameters:
[] |
40 | 2.14 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
Parameters:
[ 1 1 ] |
41 | 0.41 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
Parameters:
[ 1 4811 ] |
42 | 0.38 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
Parameters:
[ 4811 1 ] |
43 | 0.15 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 = ?
Parameters:
[
1
]
|
44 | 0.12 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
Parameters:
[ 1 4811 ] |
45 | 0.13 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
Parameters:
[ 4811 1 ] |
46 | 0.94 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 = ?
Parameters:
[
788
]
|
47 | 0.24 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
Parameters:
[ 1 4811 ] |
48 | 4.01 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:
[ 4811 1 "2025-03-07 19:39:56" ] |
49 | 0.87 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 4811 ] |
50 | 0.13 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 4811 ] |
51 | 47.17 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
Parameters:
[] |
52 | 0.15 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
Parameters:
[ 1 4811 ] |
53 | 0.10 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
Parameters:
[ 4811 1 ] |
54 | 0.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_parameter_value_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4748
]
|
55 | 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
Parameters:
[ 1 4811 ] |
56 | 0.09 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
Parameters:
[ 4811 1 ] |
57 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_parameter_value_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4750
]
|
58 | 0.55 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 = ?
Parameters:
[
4811
]
|
59 | 0.16 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.locale = ? AND t0.deleted_by IS NULL LIMIT 1
Parameters:
[
"pl"
]
|
60 | 0.55 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" "7" "main" ] |
61 | 0.11 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 = ?
Parameters:
[ "pl" "7" ] |
62 | 14.03 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" ] |
63 | 1.80 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 ] |
64 | 1.10 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 = ?
Parameters:
[
"pl"
]
|
65 | 1049.76 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 ] |
66 | 22.82 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 ] |
67 | 51.95 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 ] |
68 | 0.30 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 ] ] |
69 | 24.77 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 ] |
70 | 1.22 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
Parameters:
[ "pl" 1 1 ] |
71 | 29.96 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
Parameters:
[] |
72 | 0.68 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
Parameters:
[
239957
]
|
73 | 1.00 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 = ?
Parameters:
[ "pl" 1 ] |
74 | 0.11 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
Parameters:
[] |
75 | 0.12 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
Parameters:
[
"pl"
]
|
76 | 0.28 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 = ?
Parameters:
[
121
]
|
77 | 0.21 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 = ?
Parameters:
[
237
]
|
78 | 0.57 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
10258
]
|
79 | 0.86 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18448
]
|
80 | 0.29 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18447
]
|
81 | 0.28 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18446
]
|
82 | 0.32 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18449
]
|
83 | 0.28 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18450
]
|
84 | 0.43 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18496
]
|
85 | 0.28 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18451
]
|
86 | 0.30 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18452
]
|
87 | 0.28 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18453
]
|
88 | 0.24 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18455
]
|
89 | 0.28 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18456
]
|
90 | 0.24 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 INNER JOIN product_photo_language ON t0.id = product_photo_language.language_id WHERE product_photo_language.product_photo_id = ?
Parameters:
[
18495
]
|
91 | 0.36 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 INNER JOIN producer_landing_page ON t0.id = producer_landing_page.product_producer_id WHERE producer_landing_page.landing_page_id = ?
Parameters:
[
52
]
|
92 | 0.27 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.currency_id = ? LIMIT 1
Parameters:
[
1
]
|
93 | 0.11 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.currency_id = ? LIMIT 1
Parameters:
[
1
]
|
94 | 0.58 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 INNER JOIN product_markers ON t0.id = product_markers.marker_id WHERE product_markers.product_id = ?
Parameters:
[
4811
]
|
95 | 0.21 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.product_producer_id = ?
Parameters:
[
52
]
|
96 | 1.01 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 INNER JOIN landing_page_products ON t0.id = landing_page_products.landing_page_id WHERE landing_page_products.product_id = ?
Parameters:
[
4811
]
|
97 | 0.19 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.landing_page_id = ?
Parameters:
[
247
]
|
98 | 0.21 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.landing_page_id = ?
Parameters:
[
296
]
|
99 | 0.82 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.image_name AS image_name_3, t0.sold_time AS sold_time_4, t0.add_to_cart_time AS add_to_cart_time_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.product_id AS product_id_11 FROM sub_product t0 WHERE t0.product_id = ?
Parameters:
[
4811
]
|
100 | 0.09 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.currency_id = ? LIMIT 1
Parameters:
[
1
]
|
101 | 0.10 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.currency_id = ? LIMIT 1
Parameters:
[
1
]
|
102 | 1.37 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
10259
]
|
103 | 0.15 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
10258
]
|
104 | 1.09 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18448
]
|
105 | 0.17 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18447
]
|
106 | 0.15 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18446
]
|
107 | 0.12 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18449
]
|
108 | 0.10 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18450
]
|
109 | 0.09 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18496
]
|
110 | 0.12 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18451
]
|
111 | 1.55 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18452
]
|
112 | 0.11 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18453
]
|
113 | 0.10 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18455
]
|
114 | 0.23 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18456
]
|
115 | 0.15 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM product_photo_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
18495
]
|
116 | 0.11 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.currency_id = ? LIMIT 1
Parameters:
[
1
]
|
117 | 1.25 ms |
SELECT p0_.id AS id_0, p0_.main AS main_1, p0_.lifestyle AS lifestyle_2, p0_.hover AS hover_3, p0_.name AS name_4, p0_.image_name AS image_name_5, p0_.position AS position_6, p0_.alt AS alt_7, p0_.image_custom_name AS image_custom_name_8, l1_.id AS id_9, l1_.locale AS locale_10, l1_.domain AS domain_11, l1_.is_active AS is_active_12, l1_.is_default AS is_default_13, l1_.helpline AS helpline_14, l1_.rounding_precision AS rounding_precision_15, l1_.phone AS phone_16, l1_.address AS address_17, l1_.shop_name AS shop_name_18, l1_.email AS email_19, l1_.facebook AS facebook_20, l1_.instagram AS instagram_21, l1_.youtube AS youtube_22, l1_.store_url AS store_url_23, l1_.password_protected AS password_protected_24, l1_.store_password AS store_password_25, l1_.fb_pixel AS fb_pixel_26, l1_.fb_token AS fb_token_27, l1_.is_comments AS is_comments_28, l1_.send_comment_request_days AS send_comment_request_days_29, l1_.store_email AS store_email_30, l1_.admin_store_email AS admin_store_email_31, l1_.complaint_email AS complaint_email_32, l1_.product_return_email AS product_return_email_33, l1_.getresponse_campaign_id AS getresponse_campaign_id_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.created_by AS created_by_37, l1_.updated_by AS updated_by_38, l1_.deleted_by AS deleted_by_39, p0_.product_id AS product_id_40, l1_.currency_id AS currency_id_41 FROM product_photo p0_ INNER JOIN product_photo_language p2_ ON p0_.id = p2_.product_photo_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.product_id = ? AND l1_.id = ? AND p0_.main <> 1 ORDER BY p0_.position ASC
Parameters:
[ 4807 1 ] |
118 | 0.13 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.currency_id = ? LIMIT 1
Parameters:
[
1
]
|
119 | 0.41 ms |
SELECT p0_.id AS id_0, p0_.main AS main_1, p0_.lifestyle AS lifestyle_2, p0_.hover AS hover_3, p0_.name AS name_4, p0_.image_name AS image_name_5, p0_.position AS position_6, p0_.alt AS alt_7, p0_.image_custom_name AS image_custom_name_8, l1_.id AS id_9, l1_.locale AS locale_10, l1_.domain AS domain_11, l1_.is_active AS is_active_12, l1_.is_default AS is_default_13, l1_.helpline AS helpline_14, l1_.rounding_precision AS rounding_precision_15, l1_.phone AS phone_16, l1_.address AS address_17, l1_.shop_name AS shop_name_18, l1_.email AS email_19, l1_.facebook AS facebook_20, l1_.instagram AS instagram_21, l1_.youtube AS youtube_22, l1_.store_url AS store_url_23, l1_.password_protected AS password_protected_24, l1_.store_password AS store_password_25, l1_.fb_pixel AS fb_pixel_26, l1_.fb_token AS fb_token_27, l1_.is_comments AS is_comments_28, l1_.send_comment_request_days AS send_comment_request_days_29, l1_.store_email AS store_email_30, l1_.admin_store_email AS admin_store_email_31, l1_.complaint_email AS complaint_email_32, l1_.product_return_email AS product_return_email_33, l1_.getresponse_campaign_id AS getresponse_campaign_id_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.created_by AS created_by_37, l1_.updated_by AS updated_by_38, l1_.deleted_by AS deleted_by_39, p0_.product_id AS product_id_40, l1_.currency_id AS currency_id_41 FROM product_photo p0_ INNER JOIN product_photo_language p2_ ON p0_.id = p2_.product_photo_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.product_id = ? AND l1_.id = ? AND p0_.main <> 1 ORDER BY p0_.position ASC
Parameters:
[ 4813 1 ] |
120 | 0.12 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.currency_id = ? LIMIT 1
Parameters:
[
1
]
|
121 | 0.40 ms |
SELECT p0_.id AS id_0, p0_.main AS main_1, p0_.lifestyle AS lifestyle_2, p0_.hover AS hover_3, p0_.name AS name_4, p0_.image_name AS image_name_5, p0_.position AS position_6, p0_.alt AS alt_7, p0_.image_custom_name AS image_custom_name_8, l1_.id AS id_9, l1_.locale AS locale_10, l1_.domain AS domain_11, l1_.is_active AS is_active_12, l1_.is_default AS is_default_13, l1_.helpline AS helpline_14, l1_.rounding_precision AS rounding_precision_15, l1_.phone AS phone_16, l1_.address AS address_17, l1_.shop_name AS shop_name_18, l1_.email AS email_19, l1_.facebook AS facebook_20, l1_.instagram AS instagram_21, l1_.youtube AS youtube_22, l1_.store_url AS store_url_23, l1_.password_protected AS password_protected_24, l1_.store_password AS store_password_25, l1_.fb_pixel AS fb_pixel_26, l1_.fb_token AS fb_token_27, l1_.is_comments AS is_comments_28, l1_.send_comment_request_days AS send_comment_request_days_29, l1_.store_email AS store_email_30, l1_.admin_store_email AS admin_store_email_31, l1_.complaint_email AS complaint_email_32, l1_.product_return_email AS product_return_email_33, l1_.getresponse_campaign_id AS getresponse_campaign_id_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.created_by AS created_by_37, l1_.updated_by AS updated_by_38, l1_.deleted_by AS deleted_by_39, p0_.product_id AS product_id_40, l1_.currency_id AS currency_id_41 FROM product_photo p0_ INNER JOIN product_photo_language p2_ ON p0_.id = p2_.product_photo_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.product_id = ? AND l1_.id = ? AND p0_.main <> 1 ORDER BY p0_.position ASC
Parameters:
[ 5776 1 ] |
122 | 0.10 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.domain AS domain_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.helpline AS helpline_6, t0.rounding_precision AS rounding_precision_7, t0.phone AS phone_8, t0.address AS address_9, t0.shop_name AS shop_name_10, t0.email AS email_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.youtube AS youtube_14, t0.store_url AS store_url_15, t0.password_protected AS password_protected_16, t0.store_password AS store_password_17, t0.fb_pixel AS fb_pixel_18, t0.fb_token AS fb_token_19, t0.is_comments AS is_comments_20, t0.send_comment_request_days AS send_comment_request_days_21, t0.store_email AS store_email_22, t0.admin_store_email AS admin_store_email_23, t0.complaint_email AS complaint_email_24, t0.product_return_email AS product_return_email_25, t0.getresponse_campaign_id AS getresponse_campaign_id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t0.deleted_by AS deleted_by_31, t0.currency_id AS currency_id_32 FROM language t0 WHERE t0.currency_id = ? LIMIT 1
Parameters:
[
1
]
|
123 | 0.38 ms |
SELECT p0_.id AS id_0, p0_.main AS main_1, p0_.lifestyle AS lifestyle_2, p0_.hover AS hover_3, p0_.name AS name_4, p0_.image_name AS image_name_5, p0_.position AS position_6, p0_.alt AS alt_7, p0_.image_custom_name AS image_custom_name_8, l1_.id AS id_9, l1_.locale AS locale_10, l1_.domain AS domain_11, l1_.is_active AS is_active_12, l1_.is_default AS is_default_13, l1_.helpline AS helpline_14, l1_.rounding_precision AS rounding_precision_15, l1_.phone AS phone_16, l1_.address AS address_17, l1_.shop_name AS shop_name_18, l1_.email AS email_19, l1_.facebook AS facebook_20, l1_.instagram AS instagram_21, l1_.youtube AS youtube_22, l1_.store_url AS store_url_23, l1_.password_protected AS password_protected_24, l1_.store_password AS store_password_25, l1_.fb_pixel AS fb_pixel_26, l1_.fb_token AS fb_token_27, l1_.is_comments AS is_comments_28, l1_.send_comment_request_days AS send_comment_request_days_29, l1_.store_email AS store_email_30, l1_.admin_store_email AS admin_store_email_31, l1_.complaint_email AS complaint_email_32, l1_.product_return_email AS product_return_email_33, l1_.getresponse_campaign_id AS getresponse_campaign_id_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.created_by AS created_by_37, l1_.updated_by AS updated_by_38, l1_.deleted_by AS deleted_by_39, p0_.product_id AS product_id_40, l1_.currency_id AS currency_id_41 FROM product_photo p0_ INNER JOIN product_photo_language p2_ ON p0_.id = p2_.product_photo_id INNER JOIN language l1_ ON l1_.id = p2_.language_id WHERE p0_.product_id = ? AND l1_.id = ? AND p0_.main <> 1 ORDER BY p0_.position ASC
Parameters:
[ 5778 1 ] |
124 | 0.34 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 ORDER BY h0_.nb_of_the_day ASC
Parameters:
[
"pl"
]
|
125 | 4.97 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.slug AS slug_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.created_by AS created_by_6, a0_.updated_by AS updated_by_7, a0_.deleted_by AS deleted_by_8, l1_.id AS id_9, l1_.locale AS locale_10, l1_.domain AS domain_11, l1_.is_active AS is_active_12, l1_.is_default AS is_default_13, l1_.helpline AS helpline_14, l1_.rounding_precision AS rounding_precision_15, l1_.phone AS phone_16, l1_.address AS address_17, l1_.shop_name AS shop_name_18, l1_.email AS email_19, l1_.facebook AS facebook_20, l1_.instagram AS instagram_21, l1_.youtube AS youtube_22, l1_.store_url AS store_url_23, l1_.password_protected AS password_protected_24, l1_.store_password AS store_password_25, l1_.fb_pixel AS fb_pixel_26, l1_.fb_token AS fb_token_27, l1_.is_comments AS is_comments_28, l1_.send_comment_request_days AS send_comment_request_days_29, l1_.store_email AS store_email_30, l1_.admin_store_email AS admin_store_email_31, l1_.complaint_email AS complaint_email_32, l1_.product_return_email AS product_return_email_33, l1_.getresponse_campaign_id AS getresponse_campaign_id_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.created_by AS created_by_37, l1_.updated_by AS updated_by_38, l1_.deleted_by AS deleted_by_39, a0_.language_id AS language_id_40, l1_.currency_id AS currency_id_41 FROM article_news a0_ INNER JOIN language l1_ ON a0_.language_id = l1_.id WHERE a0_.deleted_by IS NULL AND l1_.locale = ? ORDER BY a0_.id DESC
Parameters:
[
"pl"
]
|
126 | 0.32 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 = ?
Parameters:
[
"pl"
]
|
127 | 0.94 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, c0_.category_parent_id AS category_parent_id_26, c1_.translatable_id AS translatable_id_27 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id INNER JOIN category_lang_param c2_ ON c0_.id = c2_.category_id INNER JOIN language l3_ ON c2_.language = l3_.id WHERE c1_.locale = ? AND l3_.locale = ? AND c2_.shortcut = ? AND c0_.deleted_by IS NULL AND c2_.visible = ? AND c0_.category_parent_id IS NULL ORDER BY c2_.position ASC
Parameters:
[ "pl" "pl" 1 1 ] |
128 | 0.13 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
Parameters:
[
"pl"
]
|
129 | 7.79 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.meta_title AS meta_title_3, b0_.meta_description AS meta_description_4, b0_.meta_keywords AS meta_keywords_5, b0_.alt AS alt_6, b0_.image_custom_name AS image_custom_name_7, b0_.tags AS tags_8, b0_.slug AS slug_9, b0_.visible AS visible_10, b0_.special AS special_11, b0_.image_name AS image_name_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.created_by AS created_by_15, b0_.updated_by AS updated_by_16, b0_.deleted_by AS deleted_by_17, l1_.id AS id_18, l1_.locale AS locale_19, l1_.domain AS domain_20, l1_.is_active AS is_active_21, l1_.is_default AS is_default_22, l1_.helpline AS helpline_23, l1_.rounding_precision AS rounding_precision_24, l1_.phone AS phone_25, l1_.address AS address_26, l1_.shop_name AS shop_name_27, l1_.email AS email_28, l1_.facebook AS facebook_29, l1_.instagram AS instagram_30, l1_.youtube AS youtube_31, l1_.store_url AS store_url_32, l1_.password_protected AS password_protected_33, l1_.store_password AS store_password_34, l1_.fb_pixel AS fb_pixel_35, l1_.fb_token AS fb_token_36, l1_.is_comments AS is_comments_37, l1_.send_comment_request_days AS send_comment_request_days_38, l1_.store_email AS store_email_39, l1_.admin_store_email AS admin_store_email_40, l1_.complaint_email AS complaint_email_41, l1_.product_return_email AS product_return_email_42, l1_.getresponse_campaign_id AS getresponse_campaign_id_43, l1_.created_at AS created_at_44, l1_.updated_at AS updated_at_45, l1_.created_by AS created_by_46, l1_.updated_by AS updated_by_47, l1_.deleted_by AS deleted_by_48, b0_.language AS language_49, l1_.currency_id AS currency_id_50 FROM blog b0_ INNER JOIN language l1_ ON b0_.language = l1_.id WHERE b0_.deleted_by IS NULL AND l1_.locale = ? AND b0_.visible = 1 ORDER BY b0_.id DESC
Parameters:
[
"pl"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\PaymentMethod | No errors. |
App\Entity\DeliveryMethod | No errors. |
App\Entity\DeliveryCountry | No errors. |
App\Entity\Cart | No errors. |
App\Entity\Language | No errors. |
App\Entity\Product |
|
App\Entity\Category | No errors. |
App\Entity\ProductPrice | No errors. |
App\Entity\ProductPriceVariants | No errors. |
App\Entity\Currency | No errors. |
App\Entity\CurrencyTranslation | No errors. |
App\Entity\UrlRedirect | No errors. |
App\Entity\UserToken | No errors. |
FOS\UserBundle\Model\User | No errors. |
App\Entity\User | No errors. |
App\Entity\HelplineHours | No errors. |
App\Entity\ProductParameterValue | No errors. |
App\Entity\ProductComment |
|
App\Entity\LanguageTranslation | No errors. |
App\Entity\ProductTranslation | No errors. |
App\Entity\ProductLangParam | No errors. |
App\Entity\ProductVat | No errors. |
App\Entity\Availability | No errors. |
App\Entity\AvailabilityTranslation | No errors. |
App\Entity\ProductProducer | No errors. |
App\Entity\ProductPhoto | No errors. |
App\Entity\ProductFamily |
|
App\Entity\Marker | No errors. |
App\Entity\ProductColor | No errors. |
App\Entity\ListingMarker | No errors. |
App\Entity\ProductEquipment | No errors. |
App\Entity\SubProduct | No errors. |
App\Entity\ProductFilter | No errors. |
App\Entity\ProductPriceChangeLog | No errors. |
App\Entity\ProductPriceDraft | No errors. |
App\Entity\ProductXml | No errors. |
App\Entity\CompareParameterValue | No errors. |
App\Entity\ProductFurnitureType | No errors. |
App\Entity\ProductCategory | No errors. |
App\Entity\ProductRecommendation | No errors. |
App\Entity\ProductSimilarColors | No errors. |
App\Entity\ProductCrossSelling | No errors. |
App\Entity\LandingPage |
|
App\Entity\ProductProducerPriceChange | No errors. |
App\Entity\ProductPhotoTranslation | No errors. |
App\Entity\HelplineHoursTranslation | No errors. |
App\Entity\ProductParameter | No errors. |
App\Entity\ProductParameterValueGroup | No errors. |
App\Entity\ProductParameterLangParam | No errors. |
App\Entity\ProductParameterTranslation | No errors. |
App\Entity\ProductParameterValueTranslation | No errors. |
App\Entity\ProductParameterValueGroupTranslation | No errors. |
App\Entity\ProductView | No errors. |
App\Entity\TopBanner | No errors. |
App\Entity\Banners | No errors. |
App\Entity\Order | No errors. |
App\Entity\CompareProduct | No errors. |
App\Entity\WorkingHours | No errors. |
App\Entity\Article | No errors. |
App\Entity\FurnitureType |
|
App\Entity\WorkingHoursTranslation | No errors. |
App\Entity\CategoryTranslation | No errors. |
App\Entity\CategoryLangParam | No errors. |
App\Entity\CompareParameter | No errors. |
App\Entity\FurnitureTypeTranslation | No errors. |
App\Entity\FurnitureTypeLangParam | No errors. |
App\Entity\RebateCode | No errors. |
App\Entity\CartProduct | No errors. |
App\Entity\PaymentMethodPrice | No errors. |
App\Entity\EmailTemplate | No errors. |
App\Entity\OrderStatus | No errors. |
App\Entity\PaymentMethodTranslation | No errors. |
App\Entity\DeliveryPrice | No errors. |
App\Entity\DeliveryMethodTranslation | No errors. |
App\Entity\DeliveryCountryTranslation | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Address |
|
App\Entity\Country | No errors. |
App\Entity\UserGroup | No errors. |
App\Entity\RoJudet | No errors. |
App\Entity\ProductFamilyLangParam | No errors. |
App\Entity\ProductFamilyTranslation | No errors. |
App\Entity\ProductColorTranslation | No errors. |
App\Entity\OrderProduct | No errors. |
App\Entity\SubProductTranslation | No errors. |
App\Entity\GoogleLabel | No errors. |
App\Entity\CompareParameterValueTranslation | No errors. |
App\Entity\CompareParameterTranslation | No errors. |
App\Entity\CartProductParameterValue | No errors. |
App\Entity\CartProductEquipment | No errors. |
App\Entity\News | No errors. |
App\Entity\Blog | No errors. |
App\Entity\CountryTranslation | No errors. |
App\Entity\UserGroupModule | No errors. |
App\Entity\UserGroupTranslation | No errors. |
App\Entity\OrderProductParameterValue | No errors. |
App\Entity\OrderProductEquipment | No errors. |