| 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.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` = '110' | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '5' | 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` = 110 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (5,4)
ORDER BY `level` ASC | 0.000 | 2 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '110'
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 (110) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.051 | 1196 |
| 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 (93,2954,2954,2953,2953,4605,4592,4592,4592,4593,4593,4593,4591,4591,4591,5758,5758,5758,5757,5757,5757,5756,5756,5756,1086,1086,1086,1086,1086,1086,1086,1086,1086,1090,1090,1090,1090,1090,1090,1090,1090,1090,1087,1087,1087,1087,1087,1087,1087,1087,1087,1088,1088,1088,1088,1088,1088,1088,1088,1088,1083,1083,1083,1083,1083,1083,1083,1083,1083,1085,1085,1085,1085,1085,1085,1085,1085,1085,1089,1089,1089,1089,1089,1089,1089,1089,1089,1084,1084,1084,1084,1084,1084,1084,1084,1084,5547,2965,2965,2965,2965,2964,2964,2964,2964,2962,2962,2962,2962,2963,2963,2963,2963,1077,1077,1077,1077,1077,1077,1077,1079,1079,1079,1079,1079,1079,1079,1080,1080,1080,1080,1080,1080,1080,1082,1082,1082,1082,1082,1082,1082,1081,1081,1081,1081,1081,1081,1081,1078,1078,1078,1078,1078,1078,1078,5548,589,589,589,589,589,589,588,588,588,588,588,588,10099,10099,10099,10099,10099,10099,587,587,587,587,587,587,3003,3003,3003,3003,3003,3003,3003,3001,3001,3001,3001,3001,3001,3001,2999,2999,2999,2999,2999,2999,2999,3002,3002,3002,3002,3002,3002,3002,3000,3000,3000,3000,3000,3000,3000,2997,2997,2997,2997,2997,2997,2997,2998,2998,2998,2998,2998,2998,2998,5656,5656,5656,5656,5656,5654,5654,5654,5654,5654,5652,5652,5652,5652,5652,5655,5655,5655,5655,5655,5653,5653,5653,5653,5653,5549,5549,5549,5549,5549,5551,5551,5551,5551,5551,5550,5550,5550,5550,5550,4603,4603,4590,4590,4590,4589,4589,4589,4588,4588,4588,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,87,87,87,87,87,87,88,88,88,88,88,88,89,89,89,89,89,89,86,86,86,86,86,86,4595,4595,4595,4595,4595,4595,4595,4595,4595,4595,4596,4596,4596,4596,4596,4596,4596,4596,4596,4596,4599,4599,4599,4599,4599,4599,4599,4599,4599,4599,4594,4594,4594,4594,4594,4594,4594,4594,4594,4594,4598,4598,4598,4598,4598,4598,4598,4598,4598,4598,4597,4597,4597,4597,4597,4597,4597,4597,4597,4597,5598,5598,5598,5598,5598,5598,5598,5598,5598,5598,5597,5597,5597,5597,5597,5597,5597,5597,5597,5597,5599,5599,5599,5599,5599,5599,5599,5599,5599,5599,90,9231,9231,9231,9231,9231,9231,9231,2975,2975,2975,2975,2975,2975,2975,2974,2974,2974,2974,2974,2974,2974,2973,2973,2973,2973,2973,2973,2973,2976,2976,2976,2976,2976,2976,2976,2977,2977,2977,2977,2977,2977,2977,5544,5581,5581,5581,5581,5581,5581,5581,5585,5585,5585,5585,5585,5585,5585,5580,5580,5580,5580,5580,5580,5580,5582,5582,5582,5582,5582,5582,5582,5583,5583,5583,5583,5583,5583,5583,5584,5584,5584,5584,5584,5584,5584,2958,2958,2958,2958,2958,2958,2960,2960,2960,2960,2960,2960,2961,2961,2961,2961,2961,2961,2959,2959,2959,2959,2959,2959,2956,2956,2956,2956,2956,2956,2957,2957,2957,2957,2957,2957,2967,2967,2967,2967,2967,2967,2967,2969,2969,2969,2969,2969,2969,2969,2970,2970,2970,2970,2970,2970,2970,2972,2972,2972,2972,2972,2972,2972,2966,2966,2966,2966,2966,2966,2966,2968,2968,2968,2968,2968,2968,2968,2971,2971,2971,2971,2971,2971,2971,5727,5727,5728,5728,5523,5523,5523,5522,5522,5522,5524,5524,5524,4611,4611,4611,4611,4611,4611,4611,4613,4613,4613,4613,4613,4613,4613,4612,4612,4612,4612,4612,4612,4612,4614,4614,4614,4614,4614,4614,4614,4606,582,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,5730,5730,5730,5729,5729,5729,5731,5731,5731,4600,4600,4600,4600,4600,4601,4601,4601,4601,4601,4602,4602,4602,4602,4602,4610,4610,4610,4610,4610,4610,4607,4607,4607,4607,4607,4607,4609,4609,4609,4609,4609,4609,4608,4608,4608,4608,4608,4608,578,578,578,578,577,577,577,577,576,576,576,576,2952,5518,5518,5517,5517,5545,5545,5545,5545,5545,5546,5546,5546,5546,5546,5519,4618,4618,4618,4618,4618,4618,4616,4616,4616,4616,4616,4616,4615,4615,4615,4615,4615,4615,4617,4617,4617,4617,4617,4617,2955,5521,3660,5528,5528,5528,5528,5528,5528,5528,5528,5525,5525,5525,5525,5525,5525,5525,5525,5529,5529,5529,5529,5529,5529,5529,5529,5527,5527,5527,5527,5527,5527,5527,5527,5526,5526,5526,5526,5526,5526,5526,5526,3011,3011,3011,3011,3011,3012,3012,3012,3012,3012,3014,3014,3014,3014,3014,3013,3013,3013,3013,3013,3010,3010,3010,3010,3010,3021,3021,3021,3021,3021,3021,3021,3021,3021,3020,3020,3020,3020,3020,3020,3020,3020,3020,3019,3019,3019,3019,3019,3019,3019,3019,3019,3018,3018,3018,3018,3018,3018,3018,3018,3018,3023,3023,3023,3023,3023,3023,3023,3023,3023,3022,3022,3022,3022,3022,3022,3022,3022,3022,5520,3004,3004,3004,3004,3004,3004,3008,3008,3008,3008,3008,3008,3006,3006,3006,3006,3006,3006,3007,3007,3007,3007,3007,3007,3005,3005,3005,3005,3005,3005,3009,3009,3009,3009,3009,3009,84,84,85,85,3016,3016,3016,3017,3017,3017,3015,3015,3015,3029,3029,3029,3029,3029,3029,3029,3029,3029,3029,3027,3027,3027,3027,3027,3027,3027,3027,3027,3027,3024,3024,3024,3024,3024,3024,3024,3024,3024,3024,3030,3030,3030,3030,3030,3030,3030,3030,3030,3030,3028,3028,3028,3028,3028,3028,3028,3028,3028,3028,3026,3026,3026,3026,3026,3026,3026,3026,3026,3026,3025,3025,3025,3025,3025,3025,3025,3025,3025,3025) ) as s GROUP BY id_product_ps ) as ss | 0.034 | 52 |
| 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 (93,2954,2954,2953,2953,4605,4592,4592,4592,4593,4593,4593,4591,4591,4591,5758,5758,5758,5757,5757,5757,5756,5756,5756,1086,1086,1086,1086,1086,1086,1086,1086,1086,1090,1090,1090,1090,1090,1090,1090,1090,1090,1087,1087,1087,1087,1087,1087,1087,1087,1087,1088,1088,1088,1088,1088,1088,1088,1088,1088,1083,1083,1083,1083,1083,1083,1083,1083,1083,1085,1085,1085,1085,1085,1085,1085,1085,1085,1089,1089,1089,1089,1089,1089,1089,1089,1089,1084,1084,1084,1084,1084,1084,1084,1084,1084,5547,2965,2965,2965,2965,2964,2964,2964,2964,2962,2962,2962,2962,2963,2963,2963,2963,1077,1077,1077,1077,1077,1077,1077,1079,1079,1079,1079,1079,1079,1079,1080,1080,1080,1080,1080,1080,1080,1082,1082,1082,1082,1082,1082,1082,1081,1081,1081,1081,1081,1081,1081,1078,1078,1078,1078,1078,1078,1078,5548,589,589,589,589,589,589,588,588,588,588,588,588,10099,10099,10099,10099,10099,10099,587,587,587,587,587,587,3003,3003,3003,3003,3003,3003,3003,3001,3001,3001,3001,3001,3001,3001,2999,2999,2999,2999,2999,2999,2999,3002,3002,3002,3002,3002,3002,3002,3000,3000,3000,3000,3000,3000,3000,2997,2997,2997,2997,2997,2997,2997,2998,2998,2998,2998,2998,2998,2998,5656,5656,5656,5656,5656,5654,5654,5654,5654,5654,5652,5652,5652,5652,5652,5655,5655,5655,5655,5655,5653,5653,5653,5653,5653,5549,5549,5549,5549,5549,5551,5551,5551,5551,5551,5550,5550,5550,5550,5550,4603,4603,4590,4590,4590,4589,4589,4589,4588,4588,4588,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,87,87,87,87,87,87,88,88,88,88,88,88,89,89,89,89,89,89,86,86,86,86,86,86,4595,4595,4595,4595,4595,4595,4595,4595,4595,4595,4596,4596,4596,4596,4596,4596,4596,4596,4596,4596,4599,4599,4599,4599,4599,4599,4599,4599,4599,4599,4594,4594,4594,4594,4594,4594,4594,4594,4594,4594,4598,4598,4598,4598,4598,4598,4598,4598,4598,4598,4597,4597,4597,4597,4597,4597,4597,4597,4597,4597,5598,5598,5598,5598,5598,5598,5598,5598,5598,5598,5597,5597,5597,5597,5597,5597,5597,5597,5597,5597,5599,5599,5599,5599,5599,5599,5599,5599,5599,5599,90,9231,9231,9231,9231,9231,9231,9231,2975,2975,2975,2975,2975,2975,2975,2974,2974,2974,2974,2974,2974,2974,2973,2973,2973,2973,2973,2973,2973,2976,2976,2976,2976,2976,2976,2976,2977,2977,2977,2977,2977,2977,2977,5544,5581,5581,5581,5581,5581,5581,5581,5585,5585,5585,5585,5585,5585,5585,5580,5580,5580,5580,5580,5580,5580,5582,5582,5582,5582,5582,5582,5582,5583,5583,5583,5583,5583,5583,5583,5584,5584,5584,5584,5584,5584,5584,2958,2958,2958,2958,2958,2958,2960,2960,2960,2960,2960,2960,2961,2961,2961,2961,2961,2961,2959,2959,2959,2959,2959,2959,2956,2956,2956,2956,2956,2956,2957,2957,2957,2957,2957,2957,2967,2967,2967,2967,2967,2967,2967,2969,2969,2969,2969,2969,2969,2969,2970,2970,2970,2970,2970,2970,2970,2972,2972,2972,2972,2972,2972,2972,2966,2966,2966,2966,2966,2966,2966,2968,2968,2968,2968,2968,2968,2968,2971,2971,2971,2971,2971,2971,2971,5727,5727,5728,5728,5523,5523,5523,5522,5522,5522,5524,5524,5524,4611,4611,4611,4611,4611,4611,4611,4613,4613,4613,4613,4613,4613,4613,4612,4612,4612,4612,4612,4612,4612,4614,4614,4614,4614,4614,4614,4614,4606,582,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,5730,5730,5730,5729,5729,5729,5731,5731,5731,4600,4600,4600,4600,4600,4601,4601,4601,4601,4601,4602,4602,4602,4602,4602,4610,4610,4610,4610,4610,4610,4607,4607,4607,4607,4607,4607,4609,4609,4609,4609,4609,4609,4608,4608,4608,4608,4608,4608,578,578,578,578,577,577,577,577,576,576,576,576,2952,5518,5518,5517,5517,5545,5545,5545,5545,5545,5546,5546,5546,5546,5546,5519,4618,4618,4618,4618,4618,4618,4616,4616,4616,4616,4616,4616,4615,4615,4615,4615,4615,4615,4617,4617,4617,4617,4617,4617,2955,5521,3660,5528,5528,5528,5528,5528,5528,5528,5528,5525,5525,5525,5525,5525,5525,5525,5525,5529,5529,5529,5529,5529,5529,5529,5529,5527,5527,5527,5527,5527,5527,5527,5527,5526,5526,5526,5526,5526,5526,5526,5526,3011,3011,3011,3011,3011,3012,3012,3012,3012,3012,3014,3014,3014,3014,3014,3013,3013,3013,3013,3013,3010,3010,3010,3010,3010,3021,3021,3021,3021,3021,3021,3021,3021,3021,3020,3020,3020,3020,3020,3020,3020,3020,3020,3019,3019,3019,3019,3019,3019,3019,3019,3019,3018,3018,3018,3018,3018,3018,3018,3018,3018,3023,3023,3023,3023,3023,3023,3023,3023,3023,3022,3022,3022,3022,3022,3022,3022,3022,3022,5520,3004,3004,3004,3004,3004,3004,3008,3008,3008,3008,3008,3008,3006,3006,3006,3006,3006,3006,3007,3007,3007,3007,3007,3007,3005,3005,3005,3005,3005,3005,3009,3009,3009,3009,3009,3009,84,84,85,85,3016,3016,3016,3017,3017,3017,3015,3015,3015,3029,3029,3029,3029,3029,3029,3029,3029,3029,3029,3027,3027,3027,3027,3027,3027,3027,3027,3027,3027,3024,3024,3024,3024,3024,3024,3024,3024,3024,3024,3030,3030,3030,3030,3030,3030,3030,3030,3030,3030,3028,3028,3028,3028,3028,3028,3028,3028,3028,3028,3026,3026,3026,3026,3026,3026,3026,3026,3026,3026,3025,3025,3025,3025,3025,3025,3025,3025,3025,3025) ) 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.047 | 12 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (93,2954,2954,2953,2953,4605,4592,4592,4592,4593,4593,4593,4591,4591,4591,5758,5758,5758,5757,5757,5757,5756,5756,5756,1086,1086,1086,1086,1086,1086,1086,1086,1086,1090,1090,1090,1090,1090,1090,1090,1090,1090,1087,1087,1087,1087,1087,1087,1087,1087,1087,1088,1088,1088,1088,1088,1088,1088,1088,1088,1083,1083,1083,1083,1083,1083,1083,1083,1083,1085,1085,1085,1085,1085,1085,1085,1085,1085,1089,1089,1089,1089,1089,1089,1089,1089,1089,1084,1084,1084,1084,1084,1084,1084,1084,1084,5547,2965,2965,2965,2965,2964,2964,2964,2964,2962,2962,2962,2962,2963,2963,2963,2963,1077,1077,1077,1077,1077,1077,1077,1079,1079,1079,1079,1079,1079,1079,1080,1080,1080,1080,1080,1080,1080,1082,1082,1082,1082,1082,1082,1082,1081,1081,1081,1081,1081,1081,1081,1078,1078,1078,1078,1078,1078,1078,5548,589,589,589,589,589,589,588,588,588,588,588,588,10099,10099,10099,10099,10099,10099,587,587,587,587,587,587,3003,3003,3003,3003,3003,3003,3003,3001,3001,3001,3001,3001,3001,3001,2999,2999,2999,2999,2999,2999,2999,3002,3002,3002,3002,3002,3002,3002,3000,3000,3000,3000,3000,3000,3000,2997,2997,2997,2997,2997,2997,2997,2998,2998,2998,2998,2998,2998,2998,5656,5656,5656,5656,5656,5654,5654,5654,5654,5654,5652,5652,5652,5652,5652,5655,5655,5655,5655,5655,5653,5653,5653,5653,5653,5549,5549,5549,5549,5549,5551,5551,5551,5551,5551,5550,5550,5550,5550,5550,4603,4603,4590,4590,4590,4589,4589,4589,4588,4588,4588,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,87,87,87,87,87,87,88,88,88,88,88,88,89,89,89,89,89,89,86,86,86,86,86,86,4595,4595,4595,4595,4595,4595,4595,4595,4595,4595,4596,4596,4596,4596,4596,4596,4596,4596,4596,4596,4599,4599,4599,4599,4599,4599,4599,4599,4599,4599,4594,4594,4594,4594,4594,4594,4594,4594,4594,4594,4598,4598,4598,4598,4598,4598,4598,4598,4598,4598,4597,4597,4597,4597,4597,4597,4597,4597,4597,4597,5598,5598,5598,5598,5598,5598,5598,5598,5598,5598,5597,5597,5597,5597,5597,5597,5597,5597,5597,5597,5599,5599,5599,5599,5599,5599,5599,5599,5599,5599,90,9231,9231,9231,9231,9231,9231,9231,2975,2975,2975,2975,2975,2975,2975,2974,2974,2974,2974,2974,2974,2974,2973,2973,2973,2973,2973,2973,2973,2976,2976,2976,2976,2976,2976,2976,2977,2977,2977,2977,2977,2977,2977,5544,5581,5581,5581,5581,5581,5581,5581,5585,5585,5585,5585,5585,5585,5585,5580,5580,5580,5580,5580,5580,5580,5582,5582,5582,5582,5582,5582,5582,5583,5583,5583,5583,5583,5583,5583,5584,5584,5584,5584,5584,5584,5584,2958,2958,2958,2958,2958,2958,2960,2960,2960,2960,2960,2960,2961,2961,2961,2961,2961,2961,2959,2959,2959,2959,2959,2959,2956,2956,2956,2956,2956,2956,2957,2957,2957,2957,2957,2957,2967,2967,2967,2967,2967,2967,2967,2969,2969,2969,2969,2969,2969,2969,2970,2970,2970,2970,2970,2970,2970,2972,2972,2972,2972,2972,2972,2972,2966,2966,2966,2966,2966,2966,2966,2968,2968,2968,2968,2968,2968,2968,2971,2971,2971,2971,2971,2971,2971,5727,5727,5728,5728,5523,5523,5523,5522,5522,5522,5524,5524,5524,4611,4611,4611,4611,4611,4611,4611,4613,4613,4613,4613,4613,4613,4613,4612,4612,4612,4612,4612,4612,4612,4614,4614,4614,4614,4614,4614,4614,4606,582,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,5730,5730,5730,5729,5729,5729,5731,5731,5731,4600,4600,4600,4600,4600,4601,4601,4601,4601,4601,4602,4602,4602,4602,4602,4610,4610,4610,4610,4610,4610,4607,4607,4607,4607,4607,4607,4609,4609,4609,4609,4609,4609,4608,4608,4608,4608,4608,4608,578,578,578,578,577,577,577,577,576,576,576,576,2952,5518,5518,5517,5517,5545,5545,5545,5545,5545,5546,5546,5546,5546,5546,5519,4618,4618,4618,4618,4618,4618,4616,4616,4616,4616,4616,4616,4615,4615,4615,4615,4615,4615,4617,4617,4617,4617,4617,4617,2955,5521,3660,5528,5528,5528,5528,5528,5528,5528,5528,5525,5525,5525,5525,5525,5525,5525,5525,5529,5529,5529,5529,5529,5529,5529,5529,5527,5527,5527,5527,5527,5527,5527,5527,5526,5526,5526,5526,5526,5526,5526,5526,3011,3011,3011,3011,3011,3012,3012,3012,3012,3012,3014,3014,3014,3014,3014,3013,3013,3013,3013,3013,3010,3010,3010,3010,3010,3021,3021,3021,3021,3021,3021,3021,3021,3021,3020,3020,3020,3020,3020,3020,3020,3020,3020,3019,3019,3019,3019,3019,3019,3019,3019,3019,3018,3018,3018,3018,3018,3018,3018,3018,3018,3023,3023,3023,3023,3023,3023,3023,3023,3023,3022,3022,3022,3022,3022,3022,3022,3022,3022,5520,3004,3004,3004,3004,3004,3004,3008,3008,3008,3008,3008,3008,3006,3006,3006,3006,3006,3006,3007,3007,3007,3007,3007,3007,3005,3005,3005,3005,3005,3005,3009,3009,3009,3009,3009,3009,84,84,85,85,3016,3016,3016,3017,3017,3017,3015,3015,3015,3029,3029,3029,3029,3029,3029,3029,3029,3029,3029,3027,3027,3027,3027,3027,3027,3027,3027,3027,3027,3024,3024,3024,3024,3024,3024,3024,3024,3024,3024,3030,3030,3030,3030,3030,3030,3030,3030,3030,3030,3028,3028,3028,3028,3028,3028,3028,3028,3028,3028,3026,3026,3026,3026,3026,3026,3026,3026,3026,3026,3025,3025,3025,3025,3025,3025,3025,3025,3025,3025) | 0.002 | 1196 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (84,85,84,85,10076,88,9968,87,86,89,10076,88,9968,86,87,89,10076,87,9968,86,88,89,10076,87,9968,86,89,88,90,93,8809,577,578,576,8809,576,577,578,576,8809,577,578,582,8812,588,590,10099,587,589,8812,587,590,10099,589,588,587,8812,590,10099,588,589,8814,1079,1082,1078,1080,1077,1081,8814,1079,1080,1077,1082,1081,1078,1080,1078,1082,8814,1077,1081,1079,1078,1077,8814,1082,1080,1081,1079,8814,1078,1082,1080,1077,1079,1081,8814,1081,1078,1080,1077,1082,1079,8815,1086,1085,1090,1089,1084,1087,1083,1088,8815,1086,1090,1085,1083,1089,1088,1087,1084,8815,1086,1084,1090,1089,1088,1083,1085,1087,1087,1090,8815,1085,1089,1088,1084,1086,1083,1085,1084,1083,8815,1090,1089,1087,1088,1086,8815,1090,1085,1084,1089,1083,1087,1086,1088,8815,1090,1085,1084,1088,1087,1083,1089,1086,8815,1089,1085,1088,1084,1087,1083,1086,1090,2952,2954,2953,2953,2954,2955,2961,2957,2960,2958,2956,2959,2961,2960,2956,2958,2959,2957,2957,2961,2956,2960,2959,2958,2957,2961,2960,2956,2958,2959,2961,2957,2959,2956,2958,2960,2960,2959,2957,2956,2958,2961,2965,2963,2964,2962,2965,2962,2963,2964,2965,2962,2963,2964,2964,2962,2963,2965,2968,2972,2969,2971,2967,2970,2966,2968,2969,2972,2971,2966,2970,2967,2969,2971,2967,2972,2970,2966,2968,2967,2972,2966,2971,2970,2969,2968,2972,2971,2967,2966,2969,2970,2968,2972,2967,2970,2969,2966,2971,2968,2971,2970,2967,2969,2966,2968,2972,9231,10075,2975,2974,2976,2977,2973,9231,10075,2975,2973,2976,2977,2974,2976,2974,9231,2973,10075,2975,2977,2974,2973,9231,10075,2977,2976,2975,9231,2974,10075,2976,2973,2975,2977,2999,3003,3002,2998,3000,2997,3001,2999,3000,3003,2997,3002,3001,2998,3000,3002,3003,2998,3001,2997,2999,2998,3003,2997,3002,3001,3000,2999,3003,2998,3002,2997,3000,2999,3001,3003,2998,3001,2997,3000,3002,2999,3002,2998,3001,3000,2997,2999,3003,3009,3005,3006,3008,3007,3004,3009,3008,3004,3006,3007,3005,3005,3009,3004,3008,3007,3006,3009,3005,3008,3004,3007,3006,3005,3009,3007,3004,3008,3006,3008,3005,3007,3004,3006,3009,3011,3012,3014,3010,3013,3012,3010,3013,3014,3011,3010,3014,3012,3013,3011,3014,3012,3010,3011,3013,3013,3012,3010,3011,3014,3015,3017,3016,3015,3017,3016,3016,3015,3017,9969,9882,3021,3020,9881,3019,3022,3023,3018,9969,9882,3021,3020,9881,3018,3022,3023,3019,9969,9882,3021,3019,3022,9881,3018,3023,3020,3022,3020,9969,3019,9882,3018,9881,3023,3021,3020,3019,9969,9882,3018,9881,3023,3022,3021,9969,3020,9882,3019,9881,3022,3018,3023,3021,9970,9884,9883,3027,3026,3025,3030,3028,3024,3029,9970,3028,9884,3027,9883,3026,3030,3024,3029,3025,9970,3028,9884,3027,9883,3025,3030,3024,3029,3026,9970,3028,3026,9884,3025,9883,3030,3024,3029,3027,9970,3027,9884,3026,3025,9883,3024,3030,3029,3028,3027,9970,3026,9884,9883,3025,3030,3024,3028,3029,3027,9970,9884,9883,3026,3025,3029,3024,3028,3030,10074,3035,9885,3034,3039,3033,3038,3032,3036,3037,3031,10074,3035,9885,3034,3039,3033,3036,3038,3031,3037,3032,10074,9885,3035,3034,3036,3032,3039,3038,3031,3037,3033,10074,9885,3035,3033,3036,3039,3032,3038,3031,3037,3034,3036,3034,10074,3033,9885,3039,3032,3038,3031,3037,3035,3034,3033,10074,3032,9885,3031,3039,3038,3037,3036,3035,10074,9885,3034,3039,3033,3038,3032,3031,3036,3035,3037,10074,9885,3034,3039,3033,3037,3032,3036,3031,3038,3035,10074,3034,9885,3038,3033,3037,3032,3031,3036,3035,3039,3660,4589,4590,4588,4590,4589,4588,4589,4590,4588,4592,4591,4593,4593,4592,4591,4592,4593,4591,4598,9893,9892,4597,9891,4596,9890,4595,4599,4594,4598,9893,9892,4597,9891,4596,9890,4594,4599,4595,4598,9893,9892,4597,9891,4595,4594,9890,4599,4596,4598,9893,9892,4596,4595,9891,9890,4594,4599,4597,4597,9893,9892,4596,9891,4595,9890,4594,4599,4598,9893,4597,9892,4596,9891,4595,9890,4594,4598,4599,4601,9020,9894,4600,4602,9020,9894,4601,4602,4600,9894,9020,4601,4600,4602,4603,9895,4605,4606,9899,4609,4608,9897,4610,4607,9899,4609,4607,9897,4608,4610,9899,4608,4607,9897,4609,4610,9899,4608,4607,9897,4609,4610,9901,9900,4613,4612,9896,4614,4611,9901,9900,4613,4611,4614,9896,4612,4614,9901,4612,9900,4611,9896,4613,4612,9901,4611,9900,4614,9896,4613,9902,4617,9898,4616,4618,4615,9902,4617,4615,9898,4618,4616,9902,4616,9898,4615,4617,4618,4616,9902,4615,9898,4617,4618,5517,5518,5517,5518,5519,5520,5521,5524,5523,5522,5524,5523,5522,5523,5524,5522,9904,5527,9903,5526,9025,5529,5528,5525,9904,5527,9903,5525,9025,5529,5526,5528,9904,5526,9903,5525,9025,5529,5528,5527,5526,9904,9903,5525,9025,5529,5527,5528,9904,5526,5525,9903,9025,5528,5527,5529,9915,9815,9914,9814,9912,9911,5543,9910,5542,9909,5541,9908,5540,9907,5539,9818,5538,9027,9817,5537,9816,9915,9815,9914,9814,9912,9911,5543,9910,5542,9909,5541,9908,5540,9907,5539,5537,9818,9027,9817,9816,5538,9915,9815,9914,9814,9912,9911,5543,9910,5542,9909,5541,9908,5540,5538,9907,5537,9818,9027,9817,9816,5539,9915,9815,9914,9814,9912,9911,5543,9910,5542,9909,5541,5539,9908,5538,9907,9818,5537,9027,9817,9816,5540,9915,9815,9914,9814,9912,9911,5543,9910,5542,5540,9909,5539,9908,5538,9907,5537,9818,9027,9817,5541,9816,9915,9815,9914,9814,9912,9911,5543,9910,5541,5540,9909,9908,5539,9907,5538,9818,5537,9027,9817,5542,9816,9915,9815,9914,9814,9912,5542,9911,5541,9910,9909,5540,5539,9908,5538,9907,5537,9818,9027,9817,9816,5543,5544,9916,9913,5546,9813,5545,9916,5545,9913,9813,5546,5547,5548,9028,9820,5551,5549,5550,5549,9028,9820,5551,5550,9028,9820,5550,5549,5551,5581,5585,5582,9034,5583,5584,5580,5582,5584,5580,5585,9034,5583,5581,5580,5585,9034,5584,5582,5583,5581,5585,5584,5580,9034,5582,5581,5583,5585,5583,5580,9034,5582,5584,5581,5584,5583,5580,9034,5582,5581,5585,5600,5605,5604,5599,5603,5598,9035,5602,5601,5597,5600,5605,5604,5599,5603,5597,9035,5602,5598,5601,5600,5605,5604,5598,5597,5603,9035,5602,5601,5599,5653,5654,5656,5652,5655,5654,5652,5655,5656,5653,5652,5656,5654,5655,5653,5656,5652,5654,5653,5655,5655,5654,5652,5656,5653,5728,5727,5727,5728,5730,5729,5731,5730,5731,5729,5730,5729,5731,5757,5756,5758,5757,5758,5756,5757,5756,5758,10075,2974,2973,2975,2977,9231,2976,588,8812,587,590,589,10099) | 0.002 | 1724 |
| 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 (85,84,84,85,88,10076,87,9968,86,89,88,10076,9968,86,87,89,10076,87,86,9968,88,89,10076,87,9968,86,89,88,90,93,577,8809,578,576,576,8809,578,577,576,8809,578,577,582,588,8812,10099,590,589,587,587,8812,10099,590,589,588,587,8812,10099,590,589,588,588,8812,587,10099,589,590,1079,8814,1080,1078,1082,1081,1077,1080,8814,1079,1082,1081,1077,1078,1078,8814,1077,1079,1082,1081,1080,1079,1078,1082,8814,1077,1081,1080,1079,1082,8814,1078,1080,1077,1081,1079,8814,1081,1078,1077,1080,1082,1087,8815,1085,1090,1086,1084,1089,1088,1083,1087,8815,1085,1090,1086,1089,1088,1083,1084,1087,8815,1086,1090,1089,1084,1088,1083,1085,1085,8815,1084,1083,1086,1090,1089,1088,1087,1086,1090,8815,1089,1085,1084,1088,1087,1083,1090,1086,8815,1085,1089,1084,1087,1083,1088,1086,1090,8815,1085,1088,1084,1083,1087,1089,1086,8815,1089,1085,1084,1088,1083,1087,1090,2952,2953,2954,2953,2954,2955,2961,2957,2958,2960,2959,2956,2960,2961,2959,2958,2956,2957,2961,2957,2960,2956,2959,2958,2961,2960,2957,2956,2959,2958,2961,2957,2959,2956,2958,2960,2960,2957,2959,2956,2958,2961,2964,2965,2963,2962,2965,2962,2964,2963,2965,2962,2964,2963,2964,2962,2963,2965,2968,2969,2972,2967,2971,2970,2966,2968,2969,2972,2971,2970,2966,2967,2967,2966,2972,2968,2971,2970,2969,2968,2972,2967,2971,2966,2970,2969,2972,2968,2971,2967,2969,2966,2970,2972,2968,2967,2970,2966,2969,2971,2971,2968,2970,2969,2967,2966,2972,2974,9231,2975,10075,2976,2977,2973,2976,9231,2975,10075,2977,2973,2974,2974,9231,2973,10075,2975,2977,2976,2975,2974,2977,9231,2973,10075,2976,2975,9231,10075,2974,2976,2973,2977,2999,3000,3003,2998,3002,3001,2997,2999,3000,3003,3002,3001,2997,2998,2998,2997,3003,2999,3002,3001,3000,2999,3003,2998,3002,2997,3001,3000,3003,2999,3002,2998,3000,2997,3001,3003,2999,2998,3001,2997,3000,3002,3002,2999,3001,3000,2998,2997,3003,3009,3005,3006,3008,3007,3004,3008,3009,3006,3007,3004,3005,3009,3005,3004,3008,3006,3007,3009,3008,3005,3006,3004,3007,3009,3005,3007,3006,3004,3008,3008,3005,3007,3006,3004,3009,3012,3011,3014,3013,3010,3010,3011,3014,3013,3012,3011,3014,3010,3013,3012,3014,3011,3012,3010,3013,3013,3011,3012,3010,3014,3016,3015,3017,3017,3016,3015,3016,3015,3017,3020,9969,3021,9882,3019,9881,3022,3023,3018,3020,9969,3021,9882,3022,9881,3023,3018,3019,3022,9969,3021,9882,3019,9881,3023,3018,3020,9969,3020,9882,3019,9881,3018,3021,3023,3022,3021,3020,3019,9969,3023,9882,3018,9881,3022,3021,9969,3020,9882,9881,3019,3022,3018,3023,3027,9970,3028,9884,3026,9883,3025,3030,3029,3024,3028,9970,3027,9884,3026,9883,3030,3029,3024,3025,3028,9970,3027,9884,9883,3025,3030,3029,3024,3026,3028,9970,3026,9884,9883,3030,3025,3029,3024,3027,3027,9970,3026,9884,3025,9883,3030,3024,3029,3028,3027,9970,3030,9884,3026,3025,9883,3024,3028,3029,9970,3027,9884,9883,3026,3025,3029,3024,3030,3028,3035,10074,3034,9885,3039,3033,3036,3032,3038,3037,3031,3035,10074,3034,9885,3033,3039,3036,3038,3037,3031,3032,3034,10074,3035,9885,3036,3039,3038,3037,3032,3031,3033,3036,10074,3035,9885,3039,3033,3038,3032,3037,3031,3034,10074,3034,3033,9885,3032,3031,3035,3039,3038,3037,3036,3035,3034,3033,3039,10074,3032,9885,3038,3031,3037,3036,3039,3035,10074,9885,3034,3038,3033,3032,3036,3031,3037,3039,3035,10074,3034,9885,3033,3037,3032,3031,3036,3038,3035,10074,9885,3034,3038,3033,3032,3037,3031,3036,3039,3660,4588,4590,4589,4590,4588,4589,4588,4589,4590,4591,4593,4592,4591,4593,4592,4592,4591,4593,4598,9893,4597,9892,4596,9891,4595,9890,4599,4594,4598,9893,4597,9892,4596,9891,4594,9890,4599,4595,4598,9893,4597,9892,4595,9891,4594,9890,4599,4596,4598,9893,4596,9892,4595,9891,4594,9890,4599,4597,4597,9893,4596,9892,4595,9891,4594,9890,4599,4598,4597,9893,4596,9892,4595,9891,4594,9890,4598,4599,9020,9894,4600,4602,4601,4600,9020,9894,4602,4601,4600,9894,9020,4601,4602,4603,9895,4605,4606,4609,9899,4608,9897,4610,4607,4609,9899,4607,9897,4608,4610,4608,9899,4607,9897,4610,4609,4608,9899,4607,9897,4609,4610,4612,9901,4613,9900,4614,9896,4611,4614,9901,4613,9900,4611,9896,4612,4612,9901,4611,9900,4613,9896,4614,4613,4612,9901,4611,9900,4614,9896,4617,9902,4616,9898,4618,4615,4617,9902,9898,4618,4615,4616,4616,9902,4615,9898,4618,4617,4616,9902,4615,9898,4618,4617,5518,5517,5518,5517,5519,5520,5521,5523,5524,5522,5524,5523,5522,5522,5523,5524,5527,9904,5526,9903,5529,9025,5528,5525,5527,9904,9903,5529,5525,9025,5528,5526,5526,9904,5525,9903,5529,9025,5528,5527,5526,9904,9903,5529,5525,9025,5527,5528,9904,5526,9903,5525,9025,5528,5529,5527,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5541,9909,5540,9908,5539,9907,5538,9818,9027,9817,5537,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5541,9909,5540,9908,5539,9907,5537,9818,9027,9817,5538,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5541,9909,5540,9908,5538,9907,5537,9818,9027,9817,5539,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5541,9909,9908,5539,9907,5538,5537,9818,9027,9817,5540,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5540,9909,9908,5539,9907,5538,9818,5537,9027,9817,5541,9816,9915,9815,9914,9814,9912,5543,9911,5541,9910,5540,9909,5539,9908,5538,9907,5537,9818,9027,9817,5542,9816,9915,9815,9914,9814,9912,9911,5542,5541,9910,9909,5540,9908,5539,9907,5538,5537,9818,9027,9817,5543,5544,9813,9916,5546,9913,5545,9813,9916,5545,9913,5546,5547,5548,5550,9028,9820,5549,5551,9028,9820,5550,5551,5549,5549,9820,5550,9028,5551,5581,5582,5585,5584,5583,9034,5580,5580,9034,5581,5585,5584,5583,5582,5581,5585,5580,5584,9034,5583,5582,5585,5581,5584,5580,5582,9034,5583,5585,5581,5583,5580,9034,5582,5584,5584,5581,5583,5580,5582,9034,5585,5600,5605,5599,5604,5598,5603,9035,5602,5597,5601,5600,5605,5599,5604,5597,5603,9035,5602,5598,5601,5600,5605,5598,5604,5597,5603,9035,5602,5599,5601,5599,5598,5597,5605,5604,5603,5602,5601,5600,5605,5604,5603,5602,5600,5598,5597,5599,5601,5605,5604,5603,5601,5600,5598,5599,5597,5602,5605,5604,5602,5601,5600,5599,5597,5598,5603,5598,5605,5599,5603,5602,5601,5600,5597,5604,5598,5599,5597,5604,5603,5602,5601,5600,5605,5653,5654,5656,5655,5652,5652,5653,5656,5655,5654,5653,5656,5652,5655,5654,5656,5653,5654,5652,5655,5655,5653,5654,5652,5656,5728,5727,5727,5728,5729,5731,5730,5731,5729,5730,5730,5729,5731,5756,5758,5757,5756,5758,5757,5757,5756,5758,576,577,578,8809,587,588,10099,589,590,8812,1078,1082,1079,1077,1081,1080,8814,1085,1090,1086,1084,1089,1088,1083,1087,8815,4600,4601,4602,9020,5526,5525,5529,5527,5528,9025,9027,5543,5540,5541,5537,5539,5538,5542,5549,5550,5551,9028,5581,5585,5580,5584,5582,5583,9034,5605,5604,5603,5602,5601,5598,5600,5597,5599,9035,2974,10075,2975,2973,2977,2976,9231,9813,5545,5546,5539,5542,9027,9814,5541,5538,5543,5537,5540,9814,5539,5542,5543,5541,5538,5540,5537,9027,9815,9027,9816,9817,9815,9814,5540,5543,5537,5538,5539,5542,5541,9027,9817,5543,5540,5538,5537,5541,9816,9815,9814,5542,5539,9814,5543,5542,5541,5540,5539,5537,5538,9027,9817,9816,9815,9818,5549,5550,5551,9028,9820,3020,3019,3021,9881,3018,3023,3022,3020,3019,3021,3018,3023,9882,3022,9881,3028,3027,3025,3026,3030,3024,3029,9884,9883,3028,3027,3026,3025,3030,3024,3029,9883,9884,3034,3033,3035,3039,3032,3038,3031,3037,3036,9885,4598,4597,4596,4595,4594,9890,4599,4598,4597,4595,4596,4594,9892,9890,9891,4599,4598,4597,4596,4595,4594,9891,9890,9892,4599,4598,4597,4596,4595,4594,4599,9892,9891,9890,9893,4600,4601,4602,9020,9894,4603,9895,4612,4613,4611,9896,4614,4609,4607,4608,4610,9897,4617,4616,4615,4618,9898,4608,4609,4607,4610,9897,9899,4612,4611,4613,9901,9896,9900,4614,4612,4613,4611,9900,9896,9901,4614,4617,4616,4615,4618,9898,9902,9025,5527,5525,5526,5529,5528,9903,5527,5526,5525,5529,5528,9903,9025,9904,5543,5542,5541,5540,5538,5539,5537,9818,9817,9816,9815,9814,9027,9907,5543,5542,5541,5540,5539,5538,5537,9907,9818,9817,9816,9815,9814,9027,9908,5543,5542,5540,5541,5539,5538,5537,9908,9907,9818,9817,9816,9815,9814,9027,9909,5543,5542,5541,5540,5539,5538,5537,9911,9909,9908,9907,9818,9817,9816,9815,9814,9027,9910,5543,5542,5541,5540,5539,5538,5537,9910,9909,9908,9907,9818,9817,9816,9815,9814,9027,9911,5539,5542,5543,5541,5538,5537,5540,9911,9910,9909,9908,9907,9818,9817,9816,9815,9814,9027,9912,9813,9913,5546,5545,5539,5542,5538,5543,5541,5537,5540,9912,9911,9910,9909,9908,9907,9818,9817,9816,9815,9814,9027,9914,5538,5541,5539,5543,5542,5540,5537,9914,9912,9911,9910,9909,9908,9907,9818,9817,9816,9815,9814,9027,9915,5545,5546,9913,9813,9916,88,9968,87,86,89,3020,9882,9881,3021,9969,3019,3018,3023,3022,3028,9884,9883,3027,9970,3026,3025,3030,3024,3029,3034,3035,3033,3039,3032,3038,3031,3037,3036,9885,10074,9231,2974,2973,2975,10075,2977,2976,88,87,86,89,10076,9968,588,8812,587,590,589,10099)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.002 | 16 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 110 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 5 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 4 | 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` = '110'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.002 | 81 |
| 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 (93,2954,2954,2953,2953,4605,4592,4592,4592,4593,4593,4593,4591,4591,4591,5758,5758,5758,5757,5757,5757,5756,5756,5756,1086,1086,1086,1086,1086,1086,1086,1086,1086,1090,1090,1090,1090,1090,1090,1090,1090,1090,1087,1087,1087,1087,1087,1087,1087,1087,1087,1088,1088,1088,1088,1088,1088,1088,1088,1088,1083,1083,1083,1083,1083,1083,1083,1083,1083,1085,1085,1085,1085,1085,1085,1085,1085,1085,1089,1089,1089,1089,1089,1089,1089,1089,1089,1084,1084,1084,1084,1084,1084,1084,1084,1084,5547,2965,2965,2965,2965,2964,2964,2964,2964,2962,2962,2962,2962,2963,2963,2963,2963,1077,1077,1077,1077,1077,1077,1077,1079,1079,1079,1079,1079,1079,1079,1080,1080,1080,1080,1080,1080,1080,1082,1082,1082,1082,1082,1082,1082,1081,1081,1081,1081,1081,1081,1081,1078,1078,1078,1078,1078,1078,1078,5548,589,589,589,589,589,589,588,588,588,588,588,588,10099,10099,10099,10099,10099,10099,587,587,587,587,587,587,3003,3003,3003,3003,3003,3003,3003,3001,3001,3001,3001,3001,3001,3001,2999,2999,2999,2999,2999,2999,2999,3002,3002,3002,3002,3002,3002,3002,3000,3000,3000,3000,3000,3000,3000,2997,2997,2997,2997,2997,2997,2997,2998,2998,2998,2998,2998,2998,2998,5656,5656,5656,5656,5656,5654,5654,5654,5654,5654,5652,5652,5652,5652,5652,5655,5655,5655,5655,5655,5653,5653,5653,5653,5653,5549,5549,5549,5549,5549,5551,5551,5551,5551,5551,5550,5550,5550,5550,5550,4603,4603,4590,4590,4590,4589,4589,4589,4588,4588,4588,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,87,87,87,87,87,87,88,88,88,88,88,88,89,89,89,89,89,89,86,86,86,86,86,86,4595,4595,4595,4595,4595,4595,4595,4595,4595,4595,4596,4596,4596,4596,4596,4596,4596,4596,4596,4596,4599,4599,4599,4599,4599,4599,4599,4599,4599,4599,4594,4594,4594,4594,4594,4594,4594,4594,4594,4594,4598,4598,4598,4598,4598,4598,4598,4598,4598,4598,4597,4597,4597,4597,4597,4597,4597,4597,4597,4597,5598,5598,5598,5598,5598,5598,5598,5598,5598,5598,5597,5597,5597,5597,5597,5597,5597,5597,5597,5597,5599,5599,5599,5599,5599,5599,5599,5599,5599,5599,90,9231,9231,9231,9231,9231,9231,9231,2975,2975,2975,2975,2975,2975,2975,2974,2974,2974,2974,2974,2974,2974,2973,2973,2973,2973,2973,2973,2973,2976,2976,2976,2976,2976,2976,2976,2977,2977,2977,2977,2977,2977,2977,5544,5581,5581,5581,5581,5581,5581,5581,5585,5585,5585,5585,5585,5585,5585,5580,5580,5580,5580,5580,5580,5580,5582,5582,5582,5582,5582,5582,5582,5583,5583,5583,5583,5583,5583,5583,5584,5584,5584,5584,5584,5584,5584,2958,2958,2958,2958,2958,2958,2960,2960,2960,2960,2960,2960,2961,2961,2961,2961,2961,2961,2959,2959,2959,2959,2959,2959,2956,2956,2956,2956,2956,2956,2957,2957,2957,2957,2957,2957,2967,2967,2967,2967,2967,2967,2967,2969,2969,2969,2969,2969,2969,2969,2970,2970,2970,2970,2970,2970,2970,2972,2972,2972,2972,2972,2972,2972,2966,2966,2966,2966,2966,2966,2966,2968,2968,2968,2968,2968,2968,2968,2971,2971,2971,2971,2971,2971,2971,5727,5727,5728,5728,5523,5523,5523,5522,5522,5522,5524,5524,5524,4611,4611,4611,4611,4611,4611,4611,4613,4613,4613,4613,4613,4613,4613,4612,4612,4612,4612,4612,4612,4612,4614,4614,4614,4614,4614,4614,4614,4606,582,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,5730,5730,5730,5729,5729,5729,5731,5731,5731,4600,4600,4600,4600,4600,4601,4601,4601,4601,4601,4602,4602,4602,4602,4602,4610,4610,4610,4610,4610,4610,4607,4607,4607,4607,4607,4607,4609,4609,4609,4609,4609,4609,4608,4608,4608,4608,4608,4608,578,578,578,578,577,577,577,577,576,576,576,576,2952,5518,5518,5517,5517,5545,5545,5545,5545,5545,5546,5546,5546,5546,5546,5519,4618,4618,4618,4618,4618,4618,4616,4616,4616,4616,4616,4616,4615,4615,4615,4615,4615,4615,4617,4617,4617,4617,4617,4617,2955,5521,3660,5528,5528,5528,5528,5528,5528,5528,5528,5525,5525,5525,5525,5525,5525,5525,5525,5529,5529,5529,5529,5529,5529,5529,5529,5527,5527,5527,5527,5527,5527,5527,5527,5526,5526,5526,5526,5526,5526,5526,5526,3011,3011,3011,3011,3011,3012,3012,3012,3012,3012,3014,3014,3014,3014,3014,3013,3013,3013,3013,3013,3010,3010,3010,3010,3010,3021,3021,3021,3021,3021,3021,3021,3021,3021,3020,3020,3020,3020,3020,3020,3020,3020,3020,3019,3019,3019,3019,3019,3019,3019,3019,3019,3018,3018,3018,3018,3018,3018,3018,3018,3018,3023,3023,3023,3023,3023,3023,3023,3023,3023,3022,3022,3022,3022,3022,3022,3022,3022,3022,5520,3004,3004,3004,3004,3004,3004,3008,3008,3008,3008,3008,3008,3006,3006,3006,3006,3006,3006,3007,3007,3007,3007,3007,3007,3005,3005,3005,3005,3005,3005,3009,3009,3009,3009,3009,3009,84,84,85,85,3016,3016,3016,3017,3017,3017,3015,3015,3015,3029,3029,3029,3029,3029,3029,3029,3029,3029,3029,3027,3027,3027,3027,3027,3027,3027,3027,3027,3027,3024,3024,3024,3024,3024,3024,3024,3024,3024,3024,3030,3030,3030,3030,3030,3030,3030,3030,3030,3030,3028,3028,3028,3028,3028,3028,3028,3028,3028,3028,3026,3026,3026,3026,3026,3026,3026,3026,3026,3026,3025,3025,3025,3025,3025,3025,3025,3025,3025,3025) | 0.002 | 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 (93,2954,2954,2953,2953,4605,4592,4592,4592,4593,4593,4593,4591,4591,4591,5758,5758,5758,5757,5757,5757,5756,5756,5756,1086,1086,1086,1086,1086,1086,1086,1086,1086,1090,1090,1090,1090,1090,1090,1090,1090,1090,1087,1087,1087,1087,1087,1087,1087,1087,1087,1088,1088,1088,1088,1088,1088,1088,1088,1088,1083,1083,1083,1083,1083,1083,1083,1083,1083,1085,1085,1085,1085,1085,1085,1085,1085,1085,1089,1089,1089,1089,1089,1089,1089,1089,1089,1084,1084,1084,1084,1084,1084,1084,1084,1084,5547,2965,2965,2965,2965,2964,2964,2964,2964,2962,2962,2962,2962,2963,2963,2963,2963,1077,1077,1077,1077,1077,1077,1077,1079,1079,1079,1079,1079,1079,1079,1080,1080,1080,1080,1080,1080,1080,1082,1082,1082,1082,1082,1082,1082,1081,1081,1081,1081,1081,1081,1081,1078,1078,1078,1078,1078,1078,1078,5548,589,589,589,589,589,589,588,588,588,588,588,588,10099,10099,10099,10099,10099,10099,587,587,587,587,587,587,3003,3003,3003,3003,3003,3003,3003,3001,3001,3001,3001,3001,3001,3001,2999,2999,2999,2999,2999,2999,2999,3002,3002,3002,3002,3002,3002,3002,3000,3000,3000,3000,3000,3000,3000,2997,2997,2997,2997,2997,2997,2997,2998,2998,2998,2998,2998,2998,2998,5656,5656,5656,5656,5656,5654,5654,5654,5654,5654,5652,5652,5652,5652,5652,5655,5655,5655,5655,5655,5653,5653,5653,5653,5653,5549,5549,5549,5549,5549,5551,5551,5551,5551,5551,5550,5550,5550,5550,5550,4603,4603,4590,4590,4590,4589,4589,4589,4588,4588,4588,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5539,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5542,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5543,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5541,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5540,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5538,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,5537,87,87,87,87,87,87,88,88,88,88,88,88,89,89,89,89,89,89,86,86,86,86,86,86,4595,4595,4595,4595,4595,4595,4595,4595,4595,4595,4596,4596,4596,4596,4596,4596,4596,4596,4596,4596,4599,4599,4599,4599,4599,4599,4599,4599,4599,4599,4594,4594,4594,4594,4594,4594,4594,4594,4594,4594,4598,4598,4598,4598,4598,4598,4598,4598,4598,4598,4597,4597,4597,4597,4597,4597,4597,4597,4597,4597,5598,5598,5598,5598,5598,5598,5598,5598,5598,5598,5597,5597,5597,5597,5597,5597,5597,5597,5597,5597,5599,5599,5599,5599,5599,5599,5599,5599,5599,5599,90,9231,9231,9231,9231,9231,9231,9231,2975,2975,2975,2975,2975,2975,2975,2974,2974,2974,2974,2974,2974,2974,2973,2973,2973,2973,2973,2973,2973,2976,2976,2976,2976,2976,2976,2976,2977,2977,2977,2977,2977,2977,2977,5544,5581,5581,5581,5581,5581,5581,5581,5585,5585,5585,5585,5585,5585,5585,5580,5580,5580,5580,5580,5580,5580,5582,5582,5582,5582,5582,5582,5582,5583,5583,5583,5583,5583,5583,5583,5584,5584,5584,5584,5584,5584,5584,2958,2958,2958,2958,2958,2958,2960,2960,2960,2960,2960,2960,2961,2961,2961,2961,2961,2961,2959,2959,2959,2959,2959,2959,2956,2956,2956,2956,2956,2956,2957,2957,2957,2957,2957,2957,2967,2967,2967,2967,2967,2967,2967,2969,2969,2969,2969,2969,2969,2969,2970,2970,2970,2970,2970,2970,2970,2972,2972,2972,2972,2972,2972,2972,2966,2966,2966,2966,2966,2966,2966,2968,2968,2968,2968,2968,2968,2968,2971,2971,2971,2971,2971,2971,2971,5727,5727,5728,5728,5523,5523,5523,5522,5522,5522,5524,5524,5524,4611,4611,4611,4611,4611,4611,4611,4613,4613,4613,4613,4613,4613,4613,4612,4612,4612,4612,4612,4612,4612,4614,4614,4614,4614,4614,4614,4614,4606,582,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3033,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3036,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3034,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3039,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3031,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3032,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3035,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3037,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,3038,5730,5730,5730,5729,5729,5729,5731,5731,5731,4600,4600,4600,4600,4600,4601,4601,4601,4601,4601,4602,4602,4602,4602,4602,4610,4610,4610,4610,4610,4610,4607,4607,4607,4607,4607,4607,4609,4609,4609,4609,4609,4609,4608,4608,4608,4608,4608,4608,578,578,578,578,577,577,577,577,576,576,576,576,2952,5518,5518,5517,5517,5545,5545,5545,5545,5545,5546,5546,5546,5546,5546,5519,4618,4618,4618,4618,4618,4618,4616,4616,4616,4616,4616,4616,4615,4615,4615,4615,4615,4615,4617,4617,4617,4617,4617,4617,2955,5521,3660,5528,5528,5528,5528,5528,5528,5528,5528,5525,5525,5525,5525,5525,5525,5525,5525,5529,5529,5529,5529,5529,5529,5529,5529,5527,5527,5527,5527,5527,5527,5527,5527,5526,5526,5526,5526,5526,5526,5526,5526,3011,3011,3011,3011,3011,3012,3012,3012,3012,3012,3014,3014,3014,3014,3014,3013,3013,3013,3013,3013,3010,3010,3010,3010,3010,3021,3021,3021,3021,3021,3021,3021,3021,3021,3020,3020,3020,3020,3020,3020,3020,3020,3020,3019,3019,3019,3019,3019,3019,3019,3019,3019,3018,3018,3018,3018,3018,3018,3018,3018,3018,3023,3023,3023,3023,3023,3023,3023,3023,3023,3022,3022,3022,3022,3022,3022,3022,3022,3022,5520,3004,3004,3004,3004,3004,3004,3008,3008,3008,3008,3008,3008,3006,3006,3006,3006,3006,3006,3007,3007,3007,3007,3007,3007,3005,3005,3005,3005,3005,3005,3009,3009,3009,3009,3009,3009,84,84,85,85,3016,3016,3016,3017,3017,3017,3015,3015,3015,3029,3029,3029,3029,3029,3029,3029,3029,3029,3029,3027,3027,3027,3027,3027,3027,3027,3027,3027,3027,3024,3024,3024,3024,3024,3024,3024,3024,3024,3024,3030,3030,3030,3030,3030,3030,3030,3030,3030,3030,3028,3028,3028,3028,3028,3028,3028,3028,3028,3028,3026,3026,3026,3026,3026,3026,3026,3026,3026,3026,3025,3025,3025,3025,3025,3025,3025,3025,3025,3025) | 0.002 | 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 `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` = '5580' | 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` = '5581'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 6 |
| 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` = '5525' | 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` = '9904'
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` = '5537' | 0.000 | 21 |
| 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` = '9915'
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` = '84' | 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` = '84'
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` = '582' | 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` = '582'
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` = '2997' | 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` = '2999'
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` = '3031' | 0.000 | 11 |
| 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` = '10074'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 9 |
| 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` = '3024' | 0.000 | 10 |
| 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` = '9970'
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` = '5545' | 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` = '9916'
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` = '5517' | 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` = '5517'
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` = '5729' | 0.000 | 3 |
| 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` = '5730'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 3 |
| 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` = '4603' | 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` = '4603'
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: 86 | 0.158 | 6552 |
(+48) 22 812 90 60
