| 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.002 | 75 |
| 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` >= '2025-06-15'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
| SELECT *
FROM (`configuration`) | 0.000 | 65 |
| SELECT *
FROM (`configuration`) | 0.000 | 65 |
| 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.001 | 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.004 | 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` = '81' | 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` = 81 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '81'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| Select * from( Select * from( SELECT p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo 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 category_id IN (81) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.052 | 1272 |
| Select * from ( Select COUNT(*) AS count from ( SELECT sptv.variant_id,p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo , (CASE WHEN LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) = 99999999 THEN 0.00 ELSE LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) END) AS `min_price`, `magazyn`.`quantity` AS `available_now` FROM (shop_product_to_variant AS `sptv`)
left JOIN shop_products AS `p` ON (`sptv`.`product_id` = `p`.`id_product`)
left JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y') AS `pi` ON (`pi`.`product_id` = `sptv`.`product_id`)
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `sptv`.`product_id`)
left JOIN shop_products_parameters AS `spp` ON (`spp`.`product_id`=`sptv`.`product_id`)
left JOIN shop_parameters AS `sp` ON (`spp`.`parameter_id` = `sp`.`id_parameter`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
left JOIN shop_attributes AS `sa` ON (`sa`.`id_attribute`=`sptv`.`attr_id`)
LEFT JOIN shop_products_prices AS `prices` ON (`prices`.`product_id` = `p`.`id_product` AND `prices`.`variant_id` = `sptv`.`variant_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 ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `sptv`.`product_id`) WHERE p.active = 'Y' and sptv.active='Y' AND p.id_product IN (3493,3493,3493,3493,3493,3494,3494,3494,3494,3494,3492,3492,3492,3492,3492,3496,3496,3496,3496,3496,3495,3495,3495,3495,3495,4369,4369,4368,4368,3921,3921,3921,3921,3924,3924,3924,3924,3923,3923,3923,3923,3922,3922,3922,3922,4392,4392,4392,4392,4392,4393,4393,4393,4393,4393,4394,4394,4394,4394,4394,4395,4395,4395,4395,4395,4396,4396,4396,4396,4396,8154,6381,6381,6381,6381,6383,6383,6383,6383,6384,6384,6384,6384,6382,6382,6382,6382,6356,3736,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,4206,4206,4206,4206,4206,4206,4205,4205,4205,4205,4205,4205,4207,4207,4207,4207,4207,4207,4208,4208,4208,4208,4208,4208,4209,4209,4209,4209,4209,4209,4210,4210,4210,4210,4210,4210,7996,6349,6349,6349,6349,6349,6349,6349,6351,6351,6351,6351,6351,6351,6351,6352,6352,6352,6352,6352,6352,6352,6353,6353,6353,6353,6353,6353,6353,6354,6354,6354,6354,6354,6354,6354,6355,6355,6355,6355,6355,6355,6355,6350,6350,6350,6350,6350,6350,6350,4529,4529,4529,4529,4531,4531,4531,4531,4530,4530,4530,4530,4532,4532,4532,4532,3515,3515,3515,3515,3515,3515,3515,3515,3514,3514,3514,3514,3514,3514,3514,3514,3516,3516,3516,3516,3516,3516,3516,3516,3517,3517,3517,3517,3517,3517,3517,3517,3518,3518,3518,3518,3518,3518,3518,3518,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,6363,6369,6369,6369,6370,6370,6370,6368,6368,6368,5259,5259,5259,5259,5259,5260,5260,5260,5260,5260,5262,5262,5262,5262,5262,5261,5261,5261,5261,5261,5263,5263,5263,5263,5263,4144,4144,4144,4144,4146,4146,4146,4146,4147,4147,4147,4147,4145,4145,4145,4145,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,6364,8158,8160,8155,5090,4235,4235,4235,4235,4235,4235,4235,4232,4232,4232,4232,4232,4232,4232,4231,4231,4231,4231,4231,4231,4231,4234,4234,4234,4234,4234,4234,4234,4237,4237,4237,4237,4237,4237,4237,4236,4236,4236,4236,4236,4236,4236,4233,4233,4233,4233,4233,4233,4233,6939,6939,6939,6939,6939,6942,6942,6942,6942,6942,6940,6940,6940,6940,6940,6938,6938,6938,6938,6938,6941,6941,6941,6941,6941,8742,6392,4659,4659,4659,4659,4659,4659,4658,4658,4658,4658,4658,4658,4654,4654,4654,4654,4654,4654,4655,4655,4655,4655,4655,4655,4656,4656,4656,4656,4656,4656,4657,4657,4657,4657,4657,4657,5889,5889,5889,5889,5889,5890,5890,5890,5890,5890,5891,5891,5891,5891,5891,5892,5892,5892,5892,5892,5893,5893,5893,5893,5893,1074,1074,1074,1074,1074,1074,1074,1075,1075,1075,1075,1075,1075,1075,1071,1071,1071,1071,1071,1071,1071,1076,1076,1076,1076,1076,1076,1076,1072,1072,1072,1072,1072,1072,1072,1073,1073,1073,1073,1073,1073,1073,4373,9129,8156,8740,4689,4689,4689,4689,4691,4691,4691,4691,4690,4690,4690,4690,4688,4688,4688,4688,3883,3883,3883,3883,3883,3883,3883,3883,3889,3889,3889,3889,3889,3889,3889,3889,3888,3888,3888,3888,3888,3888,3888,3888,3887,3887,3887,3887,3887,3887,3887,3887,3882,3882,3882,3882,3882,3882,3882,3882,3884,3884,3884,3884,3884,3884,3884,3884,3886,3886,3886,3886,3886,3886,3886,3886,3885,3885,3885,3885,3885,3885,3885,3885,8757,535,8739,9327,9327,9327,9327,9327,9327,9330,9330,9330,9330,9330,9330,9331,9331,9331,9331,9331,9331,9328,9328,9328,9328,9328,9328,9329,9329,9329,9329,9329,9329,9332,9332,9332,9332,9332,9332,8723,8157,6921,6921,6921,6921,6921,6922,6922,6922,6922,6922,6923,6923,6923,6923,6923,6925,6925,6925,6925,6925,6924,6924,6924,6924,6924,7171,7171,7171,7171,7171,7171,7171,7173,7173,7173,7173,7173,7173,7173,7175,7175,7175,7175,7175,7175,7175,7170,7170,7170,7170,7170,7170,7170,7172,7172,7172,7172,7172,7172,7172,7174,7174,7174,7174,7174,7174,7174,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,18,18,18,18,18,18,18,18,18,18,18,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,3510,3510,3510,3510,3512,3512,3512,3512,3509,3509,3509,3509,3511,3511,3511,3511,5257,5257,5257,5257,5255,5255,5255,5255,5256,5256,5256,5256,5258,5258,5258,5258,4486,4486,4486,4486,4487,4487,4487,4487,4488,4488,4488,4488,4485,4485,4485,4485,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,5593,5593,5593,5593,5593,5594,5594,5594,5594,5594,5591,5591,5591,5591,5591,5592,5592,5592,5592,5592,8738,541,541,541,541,541,541,541,541,541,541,543,543,543,543,543,543,543,543,543,543,545,545,545,545,545,545,545,545,545,545,542,542,542,542,542,542,542,542,542,542,544,544,544,544,544,544,544,544,544,544,538,538,538,538,538,538,537,537,537,537,537,537,536,536,536,536,536,536,539,539,539,539,539,539,540,540,540,540,540,540,6358,6358,6358,6358,6358,6360,6360,6360,6360,6360,6361,6361,6361,6361,6361,6359,6359,6359,6359,6359,6362,6362,6362,6362,6362,8159) ) as s GROUP BY id_product_ps ) as ss | 0.014 | 56 |
| Select * from( Select * from( SELECT sptv.variant_id,p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo , (CASE WHEN LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) = 99999999 THEN 0.00 ELSE LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) END) AS `min_price`, `magazyn`.`quantity` AS `available_now` FROM (shop_product_to_variant AS `sptv`)
left JOIN shop_products AS `p` ON (`sptv`.`product_id` = `p`.`id_product`)
left JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y') AS `pi` ON (`pi`.`product_id` = `sptv`.`product_id`)
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `sptv`.`product_id`)
left JOIN shop_products_parameters AS `spp` ON (`spp`.`product_id`=`sptv`.`product_id`)
left JOIN shop_parameters AS `sp` ON (`spp`.`parameter_id` = `sp`.`id_parameter`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
left JOIN shop_attributes AS `sa` ON (`sa`.`id_attribute`=`sptv`.`attr_id`)
LEFT JOIN shop_products_prices AS `prices` ON (`prices`.`product_id` = `p`.`id_product` AND `prices`.`variant_id` = `sptv`.`variant_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 ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `sptv`.`product_id`) WHERE p.active = 'Y' and sptv.active='Y' AND p.id_product IN (3493,3493,3493,3493,3493,3494,3494,3494,3494,3494,3492,3492,3492,3492,3492,3496,3496,3496,3496,3496,3495,3495,3495,3495,3495,4369,4369,4368,4368,3921,3921,3921,3921,3924,3924,3924,3924,3923,3923,3923,3923,3922,3922,3922,3922,4392,4392,4392,4392,4392,4393,4393,4393,4393,4393,4394,4394,4394,4394,4394,4395,4395,4395,4395,4395,4396,4396,4396,4396,4396,8154,6381,6381,6381,6381,6383,6383,6383,6383,6384,6384,6384,6384,6382,6382,6382,6382,6356,3736,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,4206,4206,4206,4206,4206,4206,4205,4205,4205,4205,4205,4205,4207,4207,4207,4207,4207,4207,4208,4208,4208,4208,4208,4208,4209,4209,4209,4209,4209,4209,4210,4210,4210,4210,4210,4210,7996,6349,6349,6349,6349,6349,6349,6349,6351,6351,6351,6351,6351,6351,6351,6352,6352,6352,6352,6352,6352,6352,6353,6353,6353,6353,6353,6353,6353,6354,6354,6354,6354,6354,6354,6354,6355,6355,6355,6355,6355,6355,6355,6350,6350,6350,6350,6350,6350,6350,4529,4529,4529,4529,4531,4531,4531,4531,4530,4530,4530,4530,4532,4532,4532,4532,3515,3515,3515,3515,3515,3515,3515,3515,3514,3514,3514,3514,3514,3514,3514,3514,3516,3516,3516,3516,3516,3516,3516,3516,3517,3517,3517,3517,3517,3517,3517,3517,3518,3518,3518,3518,3518,3518,3518,3518,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,6363,6369,6369,6369,6370,6370,6370,6368,6368,6368,5259,5259,5259,5259,5259,5260,5260,5260,5260,5260,5262,5262,5262,5262,5262,5261,5261,5261,5261,5261,5263,5263,5263,5263,5263,4144,4144,4144,4144,4146,4146,4146,4146,4147,4147,4147,4147,4145,4145,4145,4145,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,6364,8158,8160,8155,5090,4235,4235,4235,4235,4235,4235,4235,4232,4232,4232,4232,4232,4232,4232,4231,4231,4231,4231,4231,4231,4231,4234,4234,4234,4234,4234,4234,4234,4237,4237,4237,4237,4237,4237,4237,4236,4236,4236,4236,4236,4236,4236,4233,4233,4233,4233,4233,4233,4233,6939,6939,6939,6939,6939,6942,6942,6942,6942,6942,6940,6940,6940,6940,6940,6938,6938,6938,6938,6938,6941,6941,6941,6941,6941,8742,6392,4659,4659,4659,4659,4659,4659,4658,4658,4658,4658,4658,4658,4654,4654,4654,4654,4654,4654,4655,4655,4655,4655,4655,4655,4656,4656,4656,4656,4656,4656,4657,4657,4657,4657,4657,4657,5889,5889,5889,5889,5889,5890,5890,5890,5890,5890,5891,5891,5891,5891,5891,5892,5892,5892,5892,5892,5893,5893,5893,5893,5893,1074,1074,1074,1074,1074,1074,1074,1075,1075,1075,1075,1075,1075,1075,1071,1071,1071,1071,1071,1071,1071,1076,1076,1076,1076,1076,1076,1076,1072,1072,1072,1072,1072,1072,1072,1073,1073,1073,1073,1073,1073,1073,4373,9129,8156,8740,4689,4689,4689,4689,4691,4691,4691,4691,4690,4690,4690,4690,4688,4688,4688,4688,3883,3883,3883,3883,3883,3883,3883,3883,3889,3889,3889,3889,3889,3889,3889,3889,3888,3888,3888,3888,3888,3888,3888,3888,3887,3887,3887,3887,3887,3887,3887,3887,3882,3882,3882,3882,3882,3882,3882,3882,3884,3884,3884,3884,3884,3884,3884,3884,3886,3886,3886,3886,3886,3886,3886,3886,3885,3885,3885,3885,3885,3885,3885,3885,8757,535,8739,9327,9327,9327,9327,9327,9327,9330,9330,9330,9330,9330,9330,9331,9331,9331,9331,9331,9331,9328,9328,9328,9328,9328,9328,9329,9329,9329,9329,9329,9329,9332,9332,9332,9332,9332,9332,8723,8157,6921,6921,6921,6921,6921,6922,6922,6922,6922,6922,6923,6923,6923,6923,6923,6925,6925,6925,6925,6925,6924,6924,6924,6924,6924,7171,7171,7171,7171,7171,7171,7171,7173,7173,7173,7173,7173,7173,7173,7175,7175,7175,7175,7175,7175,7175,7170,7170,7170,7170,7170,7170,7170,7172,7172,7172,7172,7172,7172,7172,7174,7174,7174,7174,7174,7174,7174,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,18,18,18,18,18,18,18,18,18,18,18,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,3510,3510,3510,3510,3512,3512,3512,3512,3509,3509,3509,3509,3511,3511,3511,3511,5257,5257,5257,5257,5255,5255,5255,5255,5256,5256,5256,5256,5258,5258,5258,5258,4486,4486,4486,4486,4487,4487,4487,4487,4488,4488,4488,4488,4485,4485,4485,4485,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,5593,5593,5593,5593,5593,5594,5594,5594,5594,5594,5591,5591,5591,5591,5591,5592,5592,5592,5592,5592,8738,541,541,541,541,541,541,541,541,541,541,543,543,543,543,543,543,543,543,543,543,545,545,545,545,545,545,545,545,545,545,542,542,542,542,542,542,542,542,542,542,544,544,544,544,544,544,544,544,544,544,538,538,538,538,538,538,537,537,537,537,537,537,536,536,536,536,536,536,539,539,539,539,539,539,540,540,540,540,540,540,6358,6358,6358,6358,6358,6360,6360,6360,6360,6360,6361,6361,6361,6361,6361,6359,6359,6359,6359,6359,6362,6362,6362,6362,6362,8159) ) as s order by available_now DESC, mainproduct DESC, product_name ASC ) as ss GROUP BY id_product_ps order by available_now DESC LIMIT 0 ,12 | 0.019 | 12 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (3493,3493,3493,3493,3493,3494,3494,3494,3494,3494,3492,3492,3492,3492,3492,3496,3496,3496,3496,3496,3495,3495,3495,3495,3495,4369,4369,4368,4368,3921,3921,3921,3921,3924,3924,3924,3924,3923,3923,3923,3923,3922,3922,3922,3922,4392,4392,4392,4392,4392,4393,4393,4393,4393,4393,4394,4394,4394,4394,4394,4395,4395,4395,4395,4395,4396,4396,4396,4396,4396,8154,6381,6381,6381,6381,6383,6383,6383,6383,6384,6384,6384,6384,6382,6382,6382,6382,6356,3736,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,4206,4206,4206,4206,4206,4206,4205,4205,4205,4205,4205,4205,4207,4207,4207,4207,4207,4207,4208,4208,4208,4208,4208,4208,4209,4209,4209,4209,4209,4209,4210,4210,4210,4210,4210,4210,7996,6349,6349,6349,6349,6349,6349,6349,6351,6351,6351,6351,6351,6351,6351,6352,6352,6352,6352,6352,6352,6352,6353,6353,6353,6353,6353,6353,6353,6354,6354,6354,6354,6354,6354,6354,6355,6355,6355,6355,6355,6355,6355,6350,6350,6350,6350,6350,6350,6350,4529,4529,4529,4529,4531,4531,4531,4531,4530,4530,4530,4530,4532,4532,4532,4532,3515,3515,3515,3515,3515,3515,3515,3515,3514,3514,3514,3514,3514,3514,3514,3514,3516,3516,3516,3516,3516,3516,3516,3516,3517,3517,3517,3517,3517,3517,3517,3517,3518,3518,3518,3518,3518,3518,3518,3518,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,6363,6369,6369,6369,6370,6370,6370,6368,6368,6368,5259,5259,5259,5259,5259,5260,5260,5260,5260,5260,5262,5262,5262,5262,5262,5261,5261,5261,5261,5261,5263,5263,5263,5263,5263,4144,4144,4144,4144,4146,4146,4146,4146,4147,4147,4147,4147,4145,4145,4145,4145,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,6364,8158,8160,8155,5090,4235,4235,4235,4235,4235,4235,4235,4232,4232,4232,4232,4232,4232,4232,4231,4231,4231,4231,4231,4231,4231,4234,4234,4234,4234,4234,4234,4234,4237,4237,4237,4237,4237,4237,4237,4236,4236,4236,4236,4236,4236,4236,4233,4233,4233,4233,4233,4233,4233,6939,6939,6939,6939,6939,6942,6942,6942,6942,6942,6940,6940,6940,6940,6940,6938,6938,6938,6938,6938,6941,6941,6941,6941,6941,8742,6392,4659,4659,4659,4659,4659,4659,4658,4658,4658,4658,4658,4658,4654,4654,4654,4654,4654,4654,4655,4655,4655,4655,4655,4655,4656,4656,4656,4656,4656,4656,4657,4657,4657,4657,4657,4657,5889,5889,5889,5889,5889,5890,5890,5890,5890,5890,5891,5891,5891,5891,5891,5892,5892,5892,5892,5892,5893,5893,5893,5893,5893,1074,1074,1074,1074,1074,1074,1074,1075,1075,1075,1075,1075,1075,1075,1071,1071,1071,1071,1071,1071,1071,1076,1076,1076,1076,1076,1076,1076,1072,1072,1072,1072,1072,1072,1072,1073,1073,1073,1073,1073,1073,1073,4373,9129,8156,8740,4689,4689,4689,4689,4691,4691,4691,4691,4690,4690,4690,4690,4688,4688,4688,4688,3883,3883,3883,3883,3883,3883,3883,3883,3889,3889,3889,3889,3889,3889,3889,3889,3888,3888,3888,3888,3888,3888,3888,3888,3887,3887,3887,3887,3887,3887,3887,3887,3882,3882,3882,3882,3882,3882,3882,3882,3884,3884,3884,3884,3884,3884,3884,3884,3886,3886,3886,3886,3886,3886,3886,3886,3885,3885,3885,3885,3885,3885,3885,3885,8757,535,8739,9327,9327,9327,9327,9327,9327,9330,9330,9330,9330,9330,9330,9331,9331,9331,9331,9331,9331,9328,9328,9328,9328,9328,9328,9329,9329,9329,9329,9329,9329,9332,9332,9332,9332,9332,9332,8723,8157,6921,6921,6921,6921,6921,6922,6922,6922,6922,6922,6923,6923,6923,6923,6923,6925,6925,6925,6925,6925,6924,6924,6924,6924,6924,7171,7171,7171,7171,7171,7171,7171,7173,7173,7173,7173,7173,7173,7173,7175,7175,7175,7175,7175,7175,7175,7170,7170,7170,7170,7170,7170,7170,7172,7172,7172,7172,7172,7172,7172,7174,7174,7174,7174,7174,7174,7174,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,18,18,18,18,18,18,18,18,18,18,18,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,3510,3510,3510,3510,3512,3512,3512,3512,3509,3509,3509,3509,3511,3511,3511,3511,5257,5257,5257,5257,5255,5255,5255,5255,5256,5256,5256,5256,5258,5258,5258,5258,4486,4486,4486,4486,4487,4487,4487,4487,4488,4488,4488,4488,4485,4485,4485,4485,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,5593,5593,5593,5593,5593,5594,5594,5594,5594,5594,5591,5591,5591,5591,5591,5592,5592,5592,5592,5592,8738,541,541,541,541,541,541,541,541,541,541,543,543,543,543,543,543,543,543,543,543,545,545,545,545,545,545,545,545,545,545,542,542,542,542,542,542,542,542,542,542,544,544,544,544,544,544,544,544,544,544,538,538,538,538,538,538,537,537,537,537,537,537,536,536,536,536,536,536,539,539,539,539,539,539,540,540,540,540,540,540,6358,6358,6358,6358,6358,6360,6360,6360,6360,6360,6361,6361,6361,6361,6361,6359,6359,6359,6359,6359,6362,6362,6362,6362,6362,8159) | 0.002 | 1272 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (2871,2877,2876,2870,2875,2869,2872,8977,2874,2873,18,535,540,539,8803,536,537,538,536,540,8803,539,537,538,540,536,8803,539,537,538,540,536,8803,538,537,539,539,536,538,8803,537,540,9856,545,9855,544,9854,543,10080,542,541,8804,9856,545,9855,544,9854,543,541,10080,542,8804,9856,545,9855,544,542,9854,541,10080,8804,543,9856,545,9855,543,542,9854,541,10080,544,8804,544,9856,9855,543,542,9854,541,10080,545,8804,8813,1073,1076,1072,1074,1075,1071,8813,1073,1074,1076,1071,1075,1072,1074,1076,1072,8813,1071,1075,1073,1072,1071,8813,1076,1075,1074,1073,8813,1076,1072,1071,1074,1073,1075,8813,1075,1072,1074,1071,1076,1073,2871,2877,2872,2870,2876,8977,2874,2875,18,2873,2869,2871,2872,2877,2876,2869,2875,8977,2874,18,2873,2870,2872,2870,2876,2877,2869,2875,2874,8977,18,2873,2871,2870,2869,2877,8977,2876,2875,18,2874,2873,2872,2871,2877,2876,2870,2869,2875,8977,2874,18,2872,2873,2871,2877,2876,2870,2875,2869,8977,2873,2872,18,2871,2874,2877,2870,2876,2869,2874,2873,8977,2872,18,2875,2871,2877,2870,2875,2874,2869,2873,8977,2872,18,2876,2871,2876,2875,2870,2874,2869,2873,8977,2872,18,2871,2877,3493,3494,3496,3495,3492,3494,3495,3492,3496,3493,3492,3496,3494,3495,3493,3496,3492,3494,3495,3493,3495,3494,3492,3493,3496,3512,3510,3511,3509,3509,3512,3510,3511,3509,3512,3510,3511,3511,3510,3509,3512,3520,3515,3519,3514,3518,3516,3513,3517,3520,3515,3519,3516,3513,3518,3517,3514,3520,3519,3518,3514,3516,3513,3517,3515,3515,3520,3514,3519,3513,3518,3516,3517,3515,3520,3519,3514,3518,3513,3516,3517,3515,3520,3519,3514,3517,3513,3516,3518,3515,3520,3518,3517,3514,3513,3516,3519,3519,3518,3515,3517,3514,3513,3516,3520,3736,3889,3884,3888,3883,3887,3885,3886,3882,3889,3884,3888,3885,3882,3887,3886,3883,3889,3888,3887,3883,3885,3886,3882,3884,3884,3889,3883,3888,3882,3887,3885,3886,3889,3884,3888,3883,3887,3882,3885,3886,3889,3884,3888,3883,3886,3882,3885,3887,3884,3889,3887,3886,3883,3882,3885,3888,3888,3887,3884,3886,3883,3885,3882,3889,3924,3922,3921,3923,3924,3921,3923,3922,3921,3924,3922,3923,3923,3922,3921,3924,4147,4145,4144,4146,4147,4144,4146,4145,4147,4144,4145,4146,4146,4145,4144,4147,4210,4206,4209,4207,4208,4205,4210,4209,4205,4207,4208,4206,4206,4210,4205,4209,4208,4207,4210,4206,4209,4205,4207,4208,4210,4206,4208,4205,4207,4209,4209,4208,4206,4205,4207,4210,4233,4237,4236,4232,4234,4235,4231,4233,4234,4237,4236,4231,4235,4232,4234,4236,4232,4237,4235,4231,4233,4232,4237,4231,4236,4235,4234,4233,4237,4232,4236,4231,4234,4235,4233,4237,4235,4232,4234,4231,4233,4236,4236,4235,4232,4234,4231,4237,4233,4368,4369,4368,4369,4373,4393,4394,4396,4395,4392,4394,4392,4395,4396,4393,4392,4396,4395,4394,4393,4396,4392,4394,4395,4393,4395,4394,4392,4393,4396,4488,4486,4485,4487,4485,4488,4486,4487,4485,4488,4486,4487,4487,4486,4485,4488,4532,4530,4529,4531,4529,4532,4530,4531,4529,4532,4530,4531,4531,4530,4529,4532,4659,4655,4658,4656,4654,4657,4659,4658,4654,4656,4657,4655,4655,4659,4654,4658,4656,4657,4659,4655,4658,4654,4656,4657,4655,4659,4657,4654,4656,4658,4658,4655,4657,4656,4654,4659,4691,4689,4688,4690,4688,4691,4690,4689,4688,4691,4689,4690,4690,4689,4688,4691,5090,5258,5256,5255,5257,5255,5258,5256,5257,5255,5258,5256,5257,5257,5255,5256,5258,5260,5261,5263,5262,5259,5261,5259,5262,5263,5260,5259,5263,5262,5261,5260,5263,5261,5259,5262,5260,5262,5261,5259,5263,5260,9933,5592,5593,5591,5594,5593,9933,5594,5591,5592,5591,9933,5593,5594,5592,9933,5591,5593,5592,5594,9936,5617,5623,5616,5622,5615,5621,5620,9037,5618,5614,5619,9936,5617,5623,5616,5622,5618,5614,5621,5620,9037,5619,5615,9936,5617,5623,5618,5615,5622,5621,5614,5620,9037,5619,5616,9936,5618,5623,5616,5622,5615,5621,5620,5614,9037,5619,5617,9936,5617,5616,5615,5623,5614,5622,5621,9037,5620,5618,5619,5617,9936,5623,5616,5622,5615,5621,5614,9037,5620,5618,5619,9936,5617,5623,5616,5622,5615,5621,5614,9037,5619,5618,5620,9936,5617,5623,5616,5622,5615,5620,5619,5614,9037,5621,5618,9936,5617,5623,5616,5621,5615,5620,5614,5619,9037,5618,5622,5617,9936,5622,5616,5621,5615,5620,5614,5619,9037,5618,5623,5888,5881,5887,5880,5886,5879,5885,5878,5884,5877,5882,5883,5876,5881,5888,5887,5880,5886,5879,5885,5878,5882,5876,5884,5883,5877,5881,5888,5887,5880,5882,5879,5886,5885,5877,5884,5876,5883,5878,5881,5888,5882,5880,5887,5878,5886,5885,5877,5884,5876,5883,5879,5881,5882,5888,5887,5879,5886,5878,5885,5877,5884,5876,5883,5880,5882,5887,5880,5888,5879,5886,5885,5878,5884,5883,5877,5876,5881,5880,5879,5888,5878,5877,5887,5886,5876,5885,5884,5882,5883,5881,5888,5880,5887,5886,5879,5878,5885,5877,5884,5882,5876,5881,5883,5888,5880,5887,5879,5886,5878,5885,5877,5883,5882,5876,5881,5884,5888,5880,5887,5879,5886,5884,5878,5883,5877,5882,5876,5885,5881,5888,5887,5880,5879,5885,5878,5884,5883,5877,5882,5876,5881,5886,5888,5880,5886,5885,5879,5884,5878,5883,5877,5882,5876,5887,5881,5887,5880,5886,5885,5884,5879,5883,5878,5882,5877,5876,5881,5888,5890,5891,5893,5889,5892,5891,5892,5889,5893,5890,5889,5893,5892,5891,5890,5893,5891,5889,5890,5892,5892,5891,5889,5890,5893,6351,6355,6354,6350,6352,6353,6349,6351,6352,6355,6349,6354,6353,6350,6352,6354,6350,6349,6355,6353,6351,6350,6355,6349,6354,6353,6352,6351,6355,6354,6350,6349,6352,6353,6351,6355,6350,6353,6352,6349,6354,6351,6354,6353,6350,6352,6349,6355,6351,6356,6359,6360,6362,6361,6358,6360,6358,6361,6362,6359,6358,6362,6360,6361,6359,6362,6358,6360,6359,6361,6361,6360,6358,6362,6359,6363,6364,6369,6368,6370,6369,6370,6368,6369,6368,6370,6384,6382,6381,6383,6381,6384,6383,6382,6381,6384,6382,6383,6383,6382,6381,6384,6391,6389,6390,6388,6391,6388,6389,6390,6388,6391,6389,6390,6390,6389,6388,6391,6392,6922,6923,6925,6921,6924,6923,6924,6921,6925,6922,6921,6925,6923,6924,6922,6925,6923,6921,6922,6924,6924,6923,6921,6922,6925,6939,6940,6942,6938,6941,6940,6938,6941,6942,6939,6938,6942,6940,6941,6939,6942,6940,6938,6939,6941,6941,6940,6938,6939,6942,7171,7175,7172,9107,7173,7174,7170,7172,7174,7170,7175,9107,7173,7171,7170,7175,9107,7174,7172,7173,7171,7175,7170,7174,9107,7172,7171,7173,7175,7170,7173,9107,7172,7171,7174,7174,7170,7173,9107,7172,7175,7171,7996,8154,8155,8156,8157,8158,8159,8160,8723,8738,8739,8740,8742,8757,9129,9332,9328,9331,9329,9330,9327,9332,9331,9327,9329,9330,9328,9328,9332,9327,9331,9329,9330,9328,9332,9331,9327,9329,9330,9332,9328,9330,9327,9329,9331,9331,9328,9330,9327,9329,9332) | 0.002 | 1371 |
| 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 (2871,2877,2870,2876,2869,2875,2872,2874,8977,2873,18,535,539,540,538,537,8803,536,540,536,539,8803,538,537,540,536,539,8803,538,537,540,536,8803,538,539,537,539,538,536,8803,537,540,545,9856,544,9855,543,9854,542,10080,541,8804,545,9856,544,9855,543,9854,541,10080,542,8804,545,9856,544,9855,542,9854,541,10080,543,8804,545,9856,543,9855,542,9854,541,10080,544,8804,544,9856,543,9855,542,9854,541,10080,545,8804,1073,8813,1074,1072,1076,1075,1071,1074,8813,1073,1076,1075,1071,1072,1072,8813,1071,1073,1076,1075,1074,1073,1072,1076,8813,1071,1075,1074,1076,1073,8813,1072,1074,1071,1075,1073,8813,1075,1072,1071,1074,1076,2871,2877,2872,2870,2876,2875,2874,8977,2873,18,2869,2871,2872,2877,2876,2875,2869,2874,8977,2873,18,2870,2870,2869,8977,18,2877,2871,2876,2875,2874,2873,2872,2871,2870,2877,2869,2876,8977,2875,2874,18,2873,2872,2877,2871,2876,2875,2870,2874,2869,8977,2872,18,2873,2877,2871,2876,2870,2875,2869,2873,8977,2872,18,2874,2877,2871,2876,2870,2874,2869,2873,8977,18,2872,2875,2877,2871,2875,2870,2874,2869,2873,8977,18,2872,2876,2876,2871,2875,2874,2870,2869,2873,8977,2872,18,2877,3493,3494,3496,3495,3492,3492,3493,3496,3495,3494,3493,3496,3492,3495,3494,3496,3493,3494,3492,3495,3495,3493,3494,3492,3496,3511,3512,3510,3509,3512,3511,3509,3510,3512,3509,3510,3511,3511,3509,3510,3512,3520,3519,3515,3516,3514,3518,3517,3513,3520,3515,3519,3518,3516,3517,3513,3514,3519,3520,3518,3516,3517,3514,3513,3515,3520,3515,3514,3519,3518,3513,3517,3516,3520,3519,3515,3518,3514,3513,3517,3516,3520,3519,3515,3514,3517,3513,3516,3518,3520,3515,3518,3514,3517,3513,3519,3516,3519,3515,3518,3517,3514,3513,3516,3520,3736,3889,3888,3884,3885,3883,3887,3886,3882,3889,3884,3888,3887,3885,3886,3882,3883,3888,3889,3887,3885,3886,3883,3882,3884,3889,3884,3888,3883,3887,3882,3886,3885,3889,3888,3884,3887,3883,3882,3885,3886,3889,3888,3884,3886,3883,3882,3887,3885,3889,3884,3887,3883,3886,3882,3885,3888,3888,3887,3884,3886,3883,3882,3889,3885,3923,3924,3922,3921,3924,3921,3923,3922,3924,3921,3922,3923,3923,3921,3922,3924,4146,4147,4145,4144,4147,4144,4146,4145,4147,4144,4146,4145,4146,4144,4145,4147,4210,4206,4207,4209,4208,4205,4209,4210,4208,4207,4205,4206,4210,4206,4209,4205,4208,4207,4210,4209,4206,4205,4208,4207,4210,4206,4208,4205,4207,4209,4209,4208,4206,4205,4207,4210,4233,4234,4237,4232,4236,4235,4231,4233,4234,4237,4236,4235,4231,4232,4232,4231,4237,4233,4236,4235,4234,4233,4237,4232,4236,4231,4235,4234,4237,4233,4236,4232,4234,4231,4235,4237,4233,4235,4232,4231,4234,4236,4236,4233,4235,4234,4232,4231,4237,4369,4368,4368,4369,4373,4393,4394,4396,4395,4392,4392,4393,4396,4395,4394,4393,4396,4392,4395,4394,4396,4393,4394,4392,4395,4395,4393,4394,4392,4396,4487,4488,4486,4485,4488,4485,4487,4486,4488,4485,4487,4486,4487,4485,4488,4486,4531,4532,4530,4529,4532,4531,4529,4530,4532,4529,4531,4530,4531,4529,4532,4530,4659,4655,4656,4658,4657,4654,4658,4659,4657,4656,4654,4655,4659,4655,4658,4654,4657,4656,4659,4658,4655,4654,4657,4656,4659,4655,4657,4654,4658,4656,4658,4657,4655,4654,4656,4659,4690,4691,4689,4688,4691,4688,4690,4689,4691,4688,4689,4690,4690,4688,4689,4691,5090,5257,5258,5256,5255,5258,5257,5255,5256,5258,5255,5257,5256,5257,5255,5256,5258,5260,5261,5263,5262,5259,5259,5260,5263,5262,5261,5260,5263,5259,5262,5261,5263,5260,5261,5259,5262,5262,5260,5261,5259,5263,5593,9933,5592,5594,5591,5591,9933,5592,5594,5593,5592,5591,5594,5593,9933,5592,9933,5593,5591,5594,5623,9936,5617,5622,5616,5615,5618,5621,5620,5619,9037,5614,5623,9936,5617,5616,5618,5622,5621,5620,5614,5619,9037,5615,5617,9936,5618,5623,5622,5621,5615,5620,5614,5619,9037,5616,5618,9936,5623,5622,5616,5621,5620,5615,5619,5614,9037,5617,5617,9936,5616,5623,5615,5622,5621,5614,5620,9037,5619,5618,5623,9936,5617,5622,5616,5621,5615,5614,5620,9037,5619,5618,5623,5617,9936,5622,5616,5621,5615,5614,5619,9037,5620,5618,5623,5617,9936,5622,5616,5615,5620,5614,5619,9037,5621,5618,5623,5617,9936,5616,5621,5615,5620,5614,5619,9037,5622,5618,9936,5617,5622,5616,5621,5615,5620,5614,5619,9037,5618,5623,5881,5888,5887,5880,5886,5879,5878,5885,5882,5877,5884,5883,5876,5881,5888,5880,5887,5879,5886,5882,5878,5885,5884,5883,5876,5877,5881,5888,5880,5887,5882,5879,5886,5885,5884,5877,5883,5876,5878,5881,5882,5888,5880,5887,5886,5885,5878,5884,5877,5883,5876,5879,5881,5882,5888,5887,5886,5879,5885,5878,5884,5877,5883,5876,5880,5880,5879,5878,5877,5876,5888,5881,5887,5886,5885,5884,5883,5882,5881,5880,5879,5888,5878,5887,5886,5877,5885,5884,5876,5883,5882,5888,5881,5887,5886,5880,5885,5879,5884,5878,5877,5882,5876,5883,5888,5881,5887,5886,5880,5885,5879,5878,5883,5877,5876,5882,5884,5888,5881,5887,5886,5880,5879,5884,5878,5877,5883,5876,5882,5885,5888,5881,5887,5880,5879,5885,5884,5878,5877,5883,5876,5882,5886,5888,5881,5880,5886,5885,5879,5878,5884,5877,5883,5876,5882,5887,5887,5881,5886,5885,5884,5880,5879,5883,5878,5877,5882,5876,5888,5890,5891,5893,5892,5889,5889,5890,5893,5892,5891,5890,5893,5889,5892,5891,5893,5890,5891,5889,5892,5892,5890,5891,5889,5893,6351,6352,6355,6350,6354,6353,6349,6351,6352,6355,6354,6353,6349,6350,6350,6349,6355,6351,6354,6353,6352,6351,6355,6350,6354,6349,6353,6352,6355,6351,6354,6350,6352,6349,6353,6355,6351,6353,6350,6349,6352,6354,6354,6353,6351,6352,6350,6349,6355,6356,6359,6360,6362,6361,6358,6358,6359,6362,6361,6360,6359,6362,6358,6361,6360,6362,6359,6360,6358,6361,6361,6359,6360,6358,6362,6363,6364,6368,6370,6369,6370,6368,6369,6369,6368,6370,6383,6384,6382,6381,6384,6381,6383,6382,6384,6381,6382,6383,6383,6381,6382,6384,6390,6391,6389,6388,6391,6388,6390,6389,6391,6388,6389,6390,6390,6388,6391,6389,6392,6922,6923,6925,6924,6921,6921,6922,6925,6924,6923,6922,6925,6921,6924,6923,6925,6922,6923,6921,6924,6924,6922,6923,6921,6925,6939,6940,6942,6941,6938,6938,6939,6942,6941,6940,6939,6942,6938,6941,6940,6942,6939,6940,6938,6941,6941,6939,6940,6938,6942,7171,7172,7175,7174,7173,9107,7170,7170,9107,7171,7175,7174,7173,7172,7171,7175,7170,7174,9107,7173,7172,7175,7171,7174,7170,9107,7172,7173,7175,7171,7173,7170,7172,9107,7174,7174,7171,7173,7170,7172,9107,7175,7996,8154,8155,8156,8157,8158,8159,8160,8723,8738,8739,8740,8742,8757,540,536,539,538,537,8803,8804,545,543,544,542,541,1072,1076,1073,1071,1075,1074,8813,2871,2877,2870,2869,2876,2874,2872,2875,2873,18,8977,5623,5617,5616,5622,5615,5621,5614,5620,5618,5619,9037,7171,7175,7170,7172,7174,7173,9107,9129,9332,9328,9329,9331,9330,9327,9331,9332,9330,9329,9327,9328,9332,9328,9331,9327,9330,9329,9332,9331,9328,9327,9330,9329,9332,9328,9330,9327,9331,9329,9331,9330,9328,9327,9329,9332,545,8804,9854,544,542,543,541,545,544,543,542,541,9854,8804,9855,544,545,543,542,541,9855,9854,8804,9856,5591,5592,5594,9933,5593,5618,5617,5623,9936,5622,5616,5621,5615,5620,5614,9037,5619,545,9856,9855,9854,8804,10080,544,543,541,542)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 14 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 81 | 0.000 | 1 |
| 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 `sptc`.`category_id` = '81'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.002 | 47 |
| select max(NULLIF(`do_99` *(1)*1, 0)) AS max99, 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 (3493,3493,3493,3493,3493,3494,3494,3494,3494,3494,3492,3492,3492,3492,3492,3496,3496,3496,3496,3496,3495,3495,3495,3495,3495,4369,4369,4368,4368,3921,3921,3921,3921,3924,3924,3924,3924,3923,3923,3923,3923,3922,3922,3922,3922,4392,4392,4392,4392,4392,4393,4393,4393,4393,4393,4394,4394,4394,4394,4394,4395,4395,4395,4395,4395,4396,4396,4396,4396,4396,8154,6381,6381,6381,6381,6383,6383,6383,6383,6384,6384,6384,6384,6382,6382,6382,6382,6356,3736,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,4206,4206,4206,4206,4206,4206,4205,4205,4205,4205,4205,4205,4207,4207,4207,4207,4207,4207,4208,4208,4208,4208,4208,4208,4209,4209,4209,4209,4209,4209,4210,4210,4210,4210,4210,4210,7996,6349,6349,6349,6349,6349,6349,6349,6351,6351,6351,6351,6351,6351,6351,6352,6352,6352,6352,6352,6352,6352,6353,6353,6353,6353,6353,6353,6353,6354,6354,6354,6354,6354,6354,6354,6355,6355,6355,6355,6355,6355,6355,6350,6350,6350,6350,6350,6350,6350,4529,4529,4529,4529,4531,4531,4531,4531,4530,4530,4530,4530,4532,4532,4532,4532,3515,3515,3515,3515,3515,3515,3515,3515,3514,3514,3514,3514,3514,3514,3514,3514,3516,3516,3516,3516,3516,3516,3516,3516,3517,3517,3517,3517,3517,3517,3517,3517,3518,3518,3518,3518,3518,3518,3518,3518,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,6363,6369,6369,6369,6370,6370,6370,6368,6368,6368,5259,5259,5259,5259,5259,5260,5260,5260,5260,5260,5262,5262,5262,5262,5262,5261,5261,5261,5261,5261,5263,5263,5263,5263,5263,4144,4144,4144,4144,4146,4146,4146,4146,4147,4147,4147,4147,4145,4145,4145,4145,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,6364,8158,8160,8155,5090,4235,4235,4235,4235,4235,4235,4235,4232,4232,4232,4232,4232,4232,4232,4231,4231,4231,4231,4231,4231,4231,4234,4234,4234,4234,4234,4234,4234,4237,4237,4237,4237,4237,4237,4237,4236,4236,4236,4236,4236,4236,4236,4233,4233,4233,4233,4233,4233,4233,6939,6939,6939,6939,6939,6942,6942,6942,6942,6942,6940,6940,6940,6940,6940,6938,6938,6938,6938,6938,6941,6941,6941,6941,6941,8742,6392,4659,4659,4659,4659,4659,4659,4658,4658,4658,4658,4658,4658,4654,4654,4654,4654,4654,4654,4655,4655,4655,4655,4655,4655,4656,4656,4656,4656,4656,4656,4657,4657,4657,4657,4657,4657,5889,5889,5889,5889,5889,5890,5890,5890,5890,5890,5891,5891,5891,5891,5891,5892,5892,5892,5892,5892,5893,5893,5893,5893,5893,1074,1074,1074,1074,1074,1074,1074,1075,1075,1075,1075,1075,1075,1075,1071,1071,1071,1071,1071,1071,1071,1076,1076,1076,1076,1076,1076,1076,1072,1072,1072,1072,1072,1072,1072,1073,1073,1073,1073,1073,1073,1073,4373,9129,8156,8740,4689,4689,4689,4689,4691,4691,4691,4691,4690,4690,4690,4690,4688,4688,4688,4688,3883,3883,3883,3883,3883,3883,3883,3883,3889,3889,3889,3889,3889,3889,3889,3889,3888,3888,3888,3888,3888,3888,3888,3888,3887,3887,3887,3887,3887,3887,3887,3887,3882,3882,3882,3882,3882,3882,3882,3882,3884,3884,3884,3884,3884,3884,3884,3884,3886,3886,3886,3886,3886,3886,3886,3886,3885,3885,3885,3885,3885,3885,3885,3885,8757,535,8739,9327,9327,9327,9327,9327,9327,9330,9330,9330,9330,9330,9330,9331,9331,9331,9331,9331,9331,9328,9328,9328,9328,9328,9328,9329,9329,9329,9329,9329,9329,9332,9332,9332,9332,9332,9332,8723,8157,6921,6921,6921,6921,6921,6922,6922,6922,6922,6922,6923,6923,6923,6923,6923,6925,6925,6925,6925,6925,6924,6924,6924,6924,6924,7171,7171,7171,7171,7171,7171,7171,7173,7173,7173,7173,7173,7173,7173,7175,7175,7175,7175,7175,7175,7175,7170,7170,7170,7170,7170,7170,7170,7172,7172,7172,7172,7172,7172,7172,7174,7174,7174,7174,7174,7174,7174,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,18,18,18,18,18,18,18,18,18,18,18,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,3510,3510,3510,3510,3512,3512,3512,3512,3509,3509,3509,3509,3511,3511,3511,3511,5257,5257,5257,5257,5255,5255,5255,5255,5256,5256,5256,5256,5258,5258,5258,5258,4486,4486,4486,4486,4487,4487,4487,4487,4488,4488,4488,4488,4485,4485,4485,4485,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,5593,5593,5593,5593,5593,5594,5594,5594,5594,5594,5591,5591,5591,5591,5591,5592,5592,5592,5592,5592,8738,541,541,541,541,541,541,541,541,541,541,543,543,543,543,543,543,543,543,543,543,545,545,545,545,545,545,545,545,545,545,542,542,542,542,542,542,542,542,542,542,544,544,544,544,544,544,544,544,544,544,538,538,538,538,538,538,537,537,537,537,537,537,536,536,536,536,536,536,539,539,539,539,539,539,540,540,540,540,540,540,6358,6358,6358,6358,6358,6360,6360,6360,6360,6360,6361,6361,6361,6361,6361,6359,6359,6359,6359,6359,6362,6362,6362,6362,6362,8159) | 0.001 | 1 |
| select MIN(NULLIF(`do_99`*(1)*1, 0)) AS min99, 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 (3493,3493,3493,3493,3493,3494,3494,3494,3494,3494,3492,3492,3492,3492,3492,3496,3496,3496,3496,3496,3495,3495,3495,3495,3495,4369,4369,4368,4368,3921,3921,3921,3921,3924,3924,3924,3924,3923,3923,3923,3923,3922,3922,3922,3922,4392,4392,4392,4392,4392,4393,4393,4393,4393,4393,4394,4394,4394,4394,4394,4395,4395,4395,4395,4395,4396,4396,4396,4396,4396,8154,6381,6381,6381,6381,6383,6383,6383,6383,6384,6384,6384,6384,6382,6382,6382,6382,6356,3736,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5617,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5622,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5614,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5620,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5615,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5616,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5621,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5619,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5623,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,5618,4206,4206,4206,4206,4206,4206,4205,4205,4205,4205,4205,4205,4207,4207,4207,4207,4207,4207,4208,4208,4208,4208,4208,4208,4209,4209,4209,4209,4209,4209,4210,4210,4210,4210,4210,4210,7996,6349,6349,6349,6349,6349,6349,6349,6351,6351,6351,6351,6351,6351,6351,6352,6352,6352,6352,6352,6352,6352,6353,6353,6353,6353,6353,6353,6353,6354,6354,6354,6354,6354,6354,6354,6355,6355,6355,6355,6355,6355,6355,6350,6350,6350,6350,6350,6350,6350,4529,4529,4529,4529,4531,4531,4531,4531,4530,4530,4530,4530,4532,4532,4532,4532,3515,3515,3515,3515,3515,3515,3515,3515,3514,3514,3514,3514,3514,3514,3514,3514,3516,3516,3516,3516,3516,3516,3516,3516,3517,3517,3517,3517,3517,3517,3517,3517,3518,3518,3518,3518,3518,3518,3518,3518,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,6363,6369,6369,6369,6370,6370,6370,6368,6368,6368,5259,5259,5259,5259,5259,5260,5260,5260,5260,5260,5262,5262,5262,5262,5262,5261,5261,5261,5261,5261,5263,5263,5263,5263,5263,4144,4144,4144,4144,4146,4146,4146,4146,4147,4147,4147,4147,4145,4145,4145,4145,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5876,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5877,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5878,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5879,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5881,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5882,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5883,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5885,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5887,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5888,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5886,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5884,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,5880,6364,8158,8160,8155,5090,4235,4235,4235,4235,4235,4235,4235,4232,4232,4232,4232,4232,4232,4232,4231,4231,4231,4231,4231,4231,4231,4234,4234,4234,4234,4234,4234,4234,4237,4237,4237,4237,4237,4237,4237,4236,4236,4236,4236,4236,4236,4236,4233,4233,4233,4233,4233,4233,4233,6939,6939,6939,6939,6939,6942,6942,6942,6942,6942,6940,6940,6940,6940,6940,6938,6938,6938,6938,6938,6941,6941,6941,6941,6941,8742,6392,4659,4659,4659,4659,4659,4659,4658,4658,4658,4658,4658,4658,4654,4654,4654,4654,4654,4654,4655,4655,4655,4655,4655,4655,4656,4656,4656,4656,4656,4656,4657,4657,4657,4657,4657,4657,5889,5889,5889,5889,5889,5890,5890,5890,5890,5890,5891,5891,5891,5891,5891,5892,5892,5892,5892,5892,5893,5893,5893,5893,5893,1074,1074,1074,1074,1074,1074,1074,1075,1075,1075,1075,1075,1075,1075,1071,1071,1071,1071,1071,1071,1071,1076,1076,1076,1076,1076,1076,1076,1072,1072,1072,1072,1072,1072,1072,1073,1073,1073,1073,1073,1073,1073,4373,9129,8156,8740,4689,4689,4689,4689,4691,4691,4691,4691,4690,4690,4690,4690,4688,4688,4688,4688,3883,3883,3883,3883,3883,3883,3883,3883,3889,3889,3889,3889,3889,3889,3889,3889,3888,3888,3888,3888,3888,3888,3888,3888,3887,3887,3887,3887,3887,3887,3887,3887,3882,3882,3882,3882,3882,3882,3882,3882,3884,3884,3884,3884,3884,3884,3884,3884,3886,3886,3886,3886,3886,3886,3886,3886,3885,3885,3885,3885,3885,3885,3885,3885,8757,535,8739,9327,9327,9327,9327,9327,9327,9330,9330,9330,9330,9330,9330,9331,9331,9331,9331,9331,9331,9328,9328,9328,9328,9328,9328,9329,9329,9329,9329,9329,9329,9332,9332,9332,9332,9332,9332,8723,8157,6921,6921,6921,6921,6921,6922,6922,6922,6922,6922,6923,6923,6923,6923,6923,6925,6925,6925,6925,6925,6924,6924,6924,6924,6924,7171,7171,7171,7171,7171,7171,7171,7173,7173,7173,7173,7173,7173,7173,7175,7175,7175,7175,7175,7175,7175,7170,7170,7170,7170,7170,7170,7170,7172,7172,7172,7172,7172,7172,7172,7174,7174,7174,7174,7174,7174,7174,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2874,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2869,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2872,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2870,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2875,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2873,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,2876,18,18,18,18,18,18,18,18,18,18,18,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2871,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,2877,3510,3510,3510,3510,3512,3512,3512,3512,3509,3509,3509,3509,3511,3511,3511,3511,5257,5257,5257,5257,5255,5255,5255,5255,5256,5256,5256,5256,5258,5258,5258,5258,4486,4486,4486,4486,4487,4487,4487,4487,4488,4488,4488,4488,4485,4485,4485,4485,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,5593,5593,5593,5593,5593,5594,5594,5594,5594,5594,5591,5591,5591,5591,5591,5592,5592,5592,5592,5592,8738,541,541,541,541,541,541,541,541,541,541,543,543,543,543,543,543,543,543,543,543,545,545,545,545,545,545,545,545,545,545,542,542,542,542,542,542,542,542,542,542,544,544,544,544,544,544,544,544,544,544,538,538,538,538,538,538,537,537,537,537,537,537,536,536,536,536,536,536,539,539,539,539,539,539,540,540,540,540,540,540,6358,6358,6358,6358,6358,6360,6360,6360,6360,6360,6361,6361,6361,6361,6361,6359,6359,6359,6359,6359,6362,6362,6362,6362,6362,8159) | 0.001 | 1 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| 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 *
FROM (`missing_labels`)
WHERE `label_key` = 'attribute.attrib_cat-81'
AND `module` = 'attribute'
AND `language` = 'pl_PL'
AND `url` = '/kategoria/produkty-do-ochrony-osobistej/81' | 0.000 | 1 |
| UPDATE `missing_labels` SET `count` = 6 WHERE `label_key` = 'attribute.attrib_cat-81' AND `module` = 'attribute' AND `language` = 'pl_PL' AND `url` = '/kategoria/produkty-do-ochrony-osobistej/81' | 0.001 | 1 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '3513' | 0.000 | 8 |
| 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`
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`)
WHERE `srp`.`product_id` = '3520'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 8 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '3509' | 0.000 | 4 |
| 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`
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`)
WHERE `srp`.`product_id` = '3512'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 4 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '4231' | 0.000 | 7 |
| 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`
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`)
WHERE `srp`.`product_id` = '4233'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 7 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '6364' | 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`
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`)
WHERE `srp`.`product_id` = '6364'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '6363' | 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`
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`)
WHERE `srp`.`product_id` = '6363'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '8757' | 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`
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`)
WHERE `srp`.`product_id` = '8757'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '4368' | 0.000 | 2 |
| 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`
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`)
WHERE `srp`.`product_id` = '4368'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 2 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '5889' | 0.000 | 5 |
| 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`
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`)
WHERE `srp`.`product_id` = '5890'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 5 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '8156' | 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`
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`)
WHERE `srp`.`product_id` = '8156'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '536' | 0.000 | 6 |
| 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`
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`)
WHERE `srp`.`product_id` = '540'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 5 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '9129' | 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`
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`)
WHERE `srp`.`product_id` = '9129'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 0 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '8160' | 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`
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`)
WHERE `srp`.`product_id` = '8160'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 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 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'rodo_pdf_link'
LIMIT 0, 1 | 0.000 | 1 |
| Total: 83 | 0.110 | 6258 |
(+48) 22 812 90 60
