| Queries | Time | Rows |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.001 | 77 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_base_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_auth_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_secret'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_token'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_developer_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `parameter_value` FROM `shop_parameters_values` | 0.000 | 542 |
| SELECT `attribute_value` FROM `shop_attributes_values_description` | 0.000 | 221 |
| SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 1
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_currencies`)
ORDER BY `id_currency` ASC | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`calendar`)
LEFT JOIN `calendar_info` ON (`calendar_info`.`calendar_day_id` = `calendar`.`id_calendar_day`)
WHERE `calendar_lang` = 'pl_PL'
AND `calendar_date` >= '2026-04-07'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
| SELECT *
FROM (`configuration`) | 0.000 | 66 |
| SELECT *
FROM (`configuration`) | 0.000 | 66 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 113 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`shop_parameters` AS `p`)
INNER JOIN `shop_parameters_description` AS `pd` ON (`pd`.`parameter_id` = `p`.`id_parameter`)
WHERE `p`.`active` = 'Y' | 0.000 | 1 |
| SELECT `shop_parameters`.*, `shop_product_parameters`.*, `shop_parameters_values`.*
FROM (`shop_parameters`)
LEFT JOIN `shop_product_parameters` ON (`shop_product_parameters`.`parameter_id` = `shop_parameters`.`id_parameter`)
LEFT JOIN `shop_products_parameters` ON (`shop_products_parameters`.`product_id` = `shop_product_parameters`.`product_id`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`id_parameter_value` ASC | 0.003 | 518 |
| SELECT *
FROM (`pages`)
WHERE `lang` = 'pl_PL'
AND `available` = 'Y'
AND `show_in_menu` = 1
AND `page_type` != 'news'
ORDER BY `page_position` DESC, `available` ASC | 0.000 | 5 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '2'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1'
ORDER BY `boxes`.`position` DESC | 0.000 | 4 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '4'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1' | 0.000 | 3 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '72' | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '7' | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '4' | 0.000 | 1 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 72 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (7,4)
ORDER BY `level` ASC | 0.000 | 2 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '72'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| Select * from( SELECT s.*
FROM ( SELECT p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo, p.sum_quantity_mag1 AS sum_quantity FROM (shop_products AS `p`)
LEFT JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y' GROUP BY product_id) AS `pi` ON (`pi`.`product_id` = `p`.`id_product`)
INNER JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `p`.`id_product`)
JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `p`.`id_product`)
LEFT JOIN shop_products_tags AS `pt` ON (`pt`.`product_id` = `p`.`id_product`)
LEFT JOIN shop_taxes AS `st` ON (`st`.`id_tax` = `p`.`tax_id`)
LEFT JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
LEFT JOIN shop_products_tags_dict AS `ptd` ON (`ptd`.`id_tag_dict` = `pt`.`tag_dict_id`)
LEFT JOIN shop_related_products AS `srp` ON (`srp`.`related_product_id` = `p`.`id_product`)
WHERE p.active = 'Y' AND pd.product_name IS NOT NULL AND ptc.category_id IN (72) GROUP BY p.id_product_ps ) AS s
ORDER BY sum_quantity DESC, s.mainproduct DESC, s.product_name ASC ) as s ORDER BY sum_quantity DESC, mainproduct DESC, product_name ASC LIMIT 0 ,99999 | 0.029 | 9 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| Select * from( Select COUNT(*) AS count from( SELECT p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo, p.sum_quantity_mag1 AS sum_quantity FROM (shop_products AS `p`)
LEFT JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y' GROUP BY product_id) AS `pi` ON (`pi`.`product_id` = `p`.`id_product`)
INNER JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `p`.`id_product`)
JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `p`.`id_product`)
LEFT JOIN shop_products_tags AS `pt` ON (`pt`.`product_id` = `p`.`id_product`)
LEFT JOIN shop_taxes AS `st` ON (`st`.`id_tax` = `p`.`tax_id`)
LEFT JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
LEFT JOIN shop_products_tags_dict AS `ptd` ON (`ptd`.`id_tag_dict` = `pt`.`tag_dict_id`)
LEFT JOIN shop_related_products AS `srp` ON (`srp`.`related_product_id` = `p`.`id_product`)
WHERE p.active = 'Y' AND pd.product_name IS NOT NULL AND ptc.category_id IN (72) GROUP BY p.id_product_ps ) as s ) as s | 0.025 | 1 |
| SELECT s.*, COALESCE(s.sum_quantity, 0) AS sum_quantity, COALESCE(s.sum_quantity, 0) AS sum_available_now FROM (Select * from( SELECT sptv.variant_id, p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo, p.sum_quantity_mag1 AS sum_quantity, `magazyn`.`quantity` AS `available_now` FROM shop_products AS `p`
inner JOIN shop_product_to_variant AS `sptv` ON (`sptv`.`product_id` = `p`.`id_product` AND `sptv`.`variant_id` = `p`.`best_variant_id` AND `sptv`.`active` = 'Y')
left JOIN shop_products_images AS `pi` ON (`pi`.`product_id` = `p`.`id_product` AND `pi`.`mainimage` = 'Y')
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `p`.`id_product`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
LEFT JOIN magazyn_quantity AS `magazyn` ON (`magazyn`.`product_id` = `p`.`id_product` AND `magazyn`.`product_variant_id` = `sptv`.`variant_id` AND `magazyn`.`magazyn_id` = 1)
inner JOIN shop_products_to_categories AS `ptc` ON (`ptc`.`product_id` = `p`.`id_product`) WHERE p.active = 'Y' AND p.best_variant_id IS NOT NULL AND p.id_product IN (3354,3279,3263,3341,6544,6553,3269,6536,6548) GROUP BY p.id_product_ps ) as s order by available_now DESC, mainproduct DESC, product_name ASC) AS s order by sum_quantity DESC LIMIT 0 ,12 | 0.001 | 9 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (3354,3279,3263,3341,6544,6553,3269,6536,6548) | 0.000 | 73 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (3264,8987,3263,3266,3265,3276,3270,3275,3271,3274,3268,3273,3272,8988,3269,3267,3277,3281,8989,3280,3278,3279,3344,3336,3343,3342,3335,3334,3339,3333,3340,3332,8995,3337,3341,3338,3358,3349,3357,3348,3356,3347,3355,3353,3346,3352,3345,8996,3351,3350,3354,6535,9079,6534,6539,6536,6538,6537,6543,6542,6540,9080,6541,6544,6549,6545,6547,6548,6546,6550,6551,6552,6553) | 0.001 | 729 |
| SELECT *
FROM (`shop_products_attributes` AS `spa`)
LEFT JOIN `shop_attributes_values` AS `spv` ON (`spv`.`id_attribute_value` = `spa`.`attribute_value_id`)
LEFT JOIN `shop_attributes_values_description` AS `spvd` ON (`spvd`.`attribute_value_id` = `spa`.`attribute_value_id`)
WHERE `product_id` IN (8987,3263,3266,3265,3264,3263,8987,3266,3264,3265,3263,3266,8987,3264,3265,3263,3265,3264,8987,3266,3271,3276,3270,3275,3268,3269,3274,3273,8988,3272,3267,3271,3270,3276,3275,3274,3269,3267,3273,8988,3268,3272,3276,3270,3271,3275,3274,3268,3273,3267,3272,8988,3269,3269,3268,3267,8988,3276,3270,3275,3274,3273,3272,3271,3270,3269,3276,3275,3268,3274,3273,3267,8988,3272,3271,3276,3270,3269,3275,3274,3268,3267,3273,3271,8988,3272,3276,3270,3275,3274,3269,3268,3267,3272,3271,8988,3273,3270,3276,3269,3268,3275,3273,3267,3272,3271,8988,3274,3276,3270,3269,3274,3268,3273,3267,3272,3271,8988,3275,3270,3271,3275,3269,3274,3273,3268,3272,3267,8988,3276,3280,3281,3279,3278,8989,3277,3281,3277,3280,8989,3279,3278,3277,3281,8989,3280,3279,3278,3277,3281,3279,8989,3280,3278,3280,3277,3279,8989,3281,3278,3337,3344,3343,3336,3335,3342,3334,3341,3333,3340,3339,3338,8995,3332,3337,3344,3343,3335,3336,3334,3342,3341,3340,3339,3332,3338,8995,3333,3337,3343,3344,3335,3336,3342,3341,3333,3340,3332,3339,8995,3334,3338,3337,3344,3343,3336,3342,3334,3341,3333,3332,3340,3339,8995,3335,3338,3343,3344,3337,3342,3335,3340,3341,3334,3338,3333,3332,8995,3339,3336,3336,3335,3334,3333,3332,3344,3343,3342,3341,3340,3339,8995,3338,3337,3344,3343,3336,3335,3342,3334,3341,3340,3333,3332,8995,3339,3338,3337,3344,3336,3343,3342,3341,3335,3334,3340,3333,3332,3338,8995,3337,3339,3344,3343,3336,3335,3342,3334,3341,3333,3339,3332,8995,3338,3340,3337,3344,3336,3343,3342,3335,3334,3333,3340,3332,3339,3338,8995,3337,3341,3344,3336,3343,3335,3341,3334,3333,3340,3332,3339,3338,8995,3337,3342,3344,3336,3335,3342,3341,3334,3340,3333,3339,3332,8995,3338,3337,3343,3343,3336,3342,3341,3340,3335,3334,3333,3339,3338,3332,8995,3344,3337,3350,3358,3357,3349,3356,3348,3355,3347,3346,3354,3351,3353,3352,8996,3345,3350,3358,3357,3349,3348,3356,3347,3355,3351,3354,3353,3345,3352,8996,3346,3350,3358,3349,3357,3351,3348,3356,3355,3354,3346,3353,3345,3352,8996,3347,3350,3351,3358,3349,3357,3356,3355,3347,3354,3346,3353,3345,3352,8996,3348,3350,3351,3358,3357,3356,3348,3355,3347,3354,3346,3353,3345,3352,8996,3349,3349,3348,3347,3346,3345,8996,3350,3358,3357,3356,3355,3354,3353,3352,3351,3350,3349,3348,3358,3347,3357,3356,3346,3355,3354,3345,3353,8996,3352,3351,3358,3350,3357,3349,3356,3348,3355,3347,3354,3346,3353,3345,3351,8996,3352,3358,3350,3357,3356,3349,3355,3348,3354,3347,3346,3352,3345,3351,8996,3353,3358,3350,3357,3356,3349,3355,3348,3347,3353,3346,3345,3352,8996,3351,3354,3358,3350,3357,3356,3349,3348,3354,3347,3346,3353,3345,3352,8996,3351,3355,3358,3350,3357,3349,3355,3348,3347,3354,3346,3353,3345,3352,8996,3351,3356,3358,3350,3356,3349,3355,3348,3347,3354,3346,3353,3345,3352,8996,3351,3357,3357,3350,3356,3355,3354,3349,3348,3347,3353,3352,3346,3345,3351,8996,3358,6537,6536,9079,6539,6535,6538,6534,6537,9079,6536,6539,6534,6538,6535,6537,6535,9079,6534,6539,6536,6538,9079,6535,6539,6534,6537,6538,6536,9079,6539,6535,6534,6536,6537,6538,6535,9079,6536,6534,6538,6537,6539,6543,6544,6542,6541,9080,6540,6544,6540,6543,9080,6542,6541,6544,6540,6543,9080,6541,6542,6544,6540,6542,9080,6541,6543,6543,6540,6542,9080,6541,6544,6549,6547,6548,6546,6545,6545,6549,6546,6547,6548,6549,6546,6548,6545,6547,6549,6546,6547,6545,6548,6546,6548,6545,6547,6549,6553,6551,6550,6552,6550,6553,6551,6552,6553,6550,6551,6552,6551,6550,6552,6553,3263,3264,3265,3266,8987,3276,3270,3275,3269,3268,3274,3267,3273,3272,3271,8988,3277,3281,3280,3279,3278,8989,3344,3336,3343,3335,3342,3334,3341,3333,3332,3340,3338,3339,3337,8995,3350,3358,3357,3349,3348,3356,3347,3355,3346,3354,3345,3351,3352,3353,8996,6535,6536,6539,6534,6538,9079,6537,6544,6540,6543,6541,6542,9080)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 12 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 72 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 7 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 4 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`parameter_value2`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products_to_categories` AS `sptc`)
LEFT JOIN `shop_products` AS `sp` ON (`sp`.`id_product` = `sptc`.`product_id`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sptc`.`product_id`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
WHERE `spv`.`active` = 'Y'
AND `sptc`.`category_id` IN (72)
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.001 | 19 |
| select max(NULLIF(`do_99` *(1)*1, 0)) AS max99, max(NULLIF(`od_25` *(1)*1, 0)) AS max25, max(NULLIF(`od_50` *(1)*1, 0)) AS max50, max(NULLIF(`od_100` *(1)*1, 0)) AS max100, max(NULLIF(`od_250` *(1)*1, 0)) AS max250, max(NULLIF(`od_500` *(1)*1, 0)) AS max500, max(NULLIF(`od_1000` *(1)*1, 0)) AS max1000 from shop_products_prices where product_id in (3354,3279,3263,3341,6544,6553,3269,6536,6548) | 0.000 | 1 |
| select MIN(NULLIF(`do_99`*(1)*1, 0)) AS min99, MIN(NULLIF(`od_25`*(1)*1, 0)) AS min25, MIN(NULLIF(`od_50`*(1)*1, 0)) AS min50, MIN(NULLIF(`od_100`*(1)*1, 0)) AS min100, MIN(NULLIF(`od_250`*(1)*1, 0)) AS min250, MIN(NULLIF(`od_500`*(1)*1, 0)) AS min500, MIN(NULLIF(`od_1000`*(1)*1, 0)) AS min1000 from shop_products_prices where product_id in (3354,3279,3263,3341,6544,6553,3269,6536,6548) | 0.000 | 1 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`shop_configuration`) | 0.000 | 8 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-text'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_1'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_2'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_domain'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3354'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3354' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.001 | 14 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3346' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3356' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3347' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3348' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3353' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3350' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3355' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3349' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3354' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3358' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3345' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3357' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3279'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3279' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3279' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3277' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3280' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3281' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3278' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3263'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3263' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 4 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3265' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3263' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3264' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3266' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3269'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3269' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 10 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3276' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3267' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3268' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3272' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3274' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3273' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3271' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3275' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3269' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3270' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3341'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.001 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '3341' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.001 | 13 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3335' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3333' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3334' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3332' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3340' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3337' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3343' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3339' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3336' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3338' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3344' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '6544'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '6544' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6542' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6543' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6540' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6544' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6541' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '6553'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '6553' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 4 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6550' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6552' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6551' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '6536'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '6536' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6535' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6537' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6538' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6536' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6534' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6539' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '6548'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '6548' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 4 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6549' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6545' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6548' | 0.000 | 1 |
| SELECT `name`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
| SELECT `description`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'footer_text'
LIMIT 0, 1 | 0.000 | 1 |
| Total: 139 | 0.079 | 3357 |
(+48) 22 812 90 60
