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` = '48' | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '9' | 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` = 48 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (9,4)
ORDER BY `level` ASC | 0.000 | 2 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '48'
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 (48) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.101 | 1080 |
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 (3286,3286,3287,3287,5841,5841,5841,5841,5841,5841,5841,9296,9296,9296,9296,9296,9296,9296,5840,5840,5840,5840,5840,5840,5840,9294,9294,9294,9294,9294,9294,9294,5838,5838,5838,5838,5838,5838,5838,5839,5839,5839,5839,5839,5839,5839,9295,9295,9295,9295,9295,9295,9295,5843,5843,5843,5843,5843,5843,5843,9300,9300,9300,9300,9300,9300,9300,9299,9299,9299,9299,9299,9299,9299,5844,5844,5844,5844,5844,5844,5844,9297,9297,9297,9297,9297,9297,9297,9298,9298,9298,9298,9298,9298,9298,5842,5842,5842,5842,5842,5842,5842,2896,2896,2896,2896,2896,2896,2896,2895,2895,2895,2895,2895,2895,2895,2892,2892,2892,2892,2892,2892,2892,2897,2897,2897,2897,2897,2897,2897,2894,2894,2894,2894,2894,2894,2894,2893,2893,2893,2893,2893,2893,2893,3961,3961,3961,3961,3961,3962,3962,3962,3962,3962,3963,3963,3963,3963,3963,9260,9260,9260,9260,9260,3960,3960,3960,3960,3960,6610,6610,6610,6610,6610,6610,6610,6614,6614,6614,6614,6614,6614,6614,6612,6612,6612,6612,6612,6612,6612,6615,6615,6615,6615,6615,6615,6615,6613,6613,6613,6613,6613,6613,6613,6611,6611,6611,6611,6611,6611,6611,6617,6617,6617,6617,6617,6617,6620,6620,6620,6620,6620,6620,6616,6616,6616,6616,6616,6616,6619,6619,6619,6619,6619,6619,6618,6618,6618,6618,6618,6618,3735,3967,3967,3967,3967,3967,9261,9261,9261,9261,9261,3964,3964,3964,3964,3964,3965,3965,3965,3965,3965,3966,3966,3966,3966,3966,2891,2891,2891,2891,2891,2890,2890,2890,2890,2890,2888,2888,2888,2888,2888,2889,2889,2889,2889,2889,5852,5852,5852,5852,5852,5852,5852,5855,5855,5855,5855,5855,5855,5855,5857,5857,5857,5857,5857,5857,5857,5854,5854,5854,5854,5854,5854,5854,5853,5853,5853,5853,5853,5853,5853,5856,5856,5856,5856,5856,5856,5856,5861,5861,5861,5861,5861,5861,5861,5863,5863,5863,5863,5863,5863,5863,5862,5862,5862,5862,5862,5862,5862,5859,5859,5859,5859,5859,5859,5859,5858,5858,5858,5858,5858,5858,5858,5860,5860,5860,5860,5860,5860,5860,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,3451,3451,3451,3451,3451,3451,3451,3453,3453,3453,3453,3453,3453,3453,3452,3452,3452,3452,3452,3452,3452,3456,3456,3456,3456,3456,3456,3456,3455,3455,3455,3455,3455,3455,3455,3454,3454,3454,3454,3454,3454,3454,3458,3458,3458,3458,3458,3457,3457,3457,3457,3457,3461,3461,3461,3461,3461,3460,3460,3460,3460,3460,3459,3459,3459,3459,3459,5870,5870,5870,5868,5868,5868,5869,5869,5869,6251,6252,6252,2900,2900,2900,2900,2900,2901,2901,2901,2901,2901,2899,2899,2899,2899,2899,2898,2898,2898,2898,2898,4024,4024,4024,4024,4024,4024,4024,4025,4025,4025,4025,4025,4025,4025,4026,4026,4026,4026,4026,4026,4026,4023,4023,4023,4023,4023,4023,4023,4028,4028,4028,4028,4028,4028,4028,4027,4027,4027,4027,4027,4027,4027,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6644,6644,6644,6644,6644,6644,6644,6644,6644,6641,6641,6641,6641,6641,6641,6641,6641,6641,6643,6643,6643,6643,6643,6643,6643,6643,6643,6638,6638,6638,6638,6638,6638,6638,6638,6638,6640,6640,6640,6640,6640,6640,6640,6640,6640,6639,6639,6639,6639,6639,6639,6639,6639,6639,6642,6642,6642,6642,6642,6642,6642,6642,6642,5867,5867,5867,5867,5867,5865,5865,5865,5865,5865,6621,6621,6621,6621,6621,6621,6621,6621,6621,6626,6626,6626,6626,6626,6626,6626,6626,6626,6623,6623,6623,6623,6623,6623,6623,6623,6623,6627,6627,6627,6627,6627,6627,6627,6627,6627,6628,6628,6628,6628,6628,6628,6628,6628,6628,6624,6624,6624,6624,6624,6624,6624,6624,6624,6625,6625,6625,6625,6625,6625,6625,6625,6625,6622,6622,6622,6622,6622,6622,6622,6622,6622,6605,6605,6605,6605,6605,6605,6605,6608,6608,6608,6608,6608,6608,6608,6607,6607,6607,6607,6607,6607,6607,6606,6606,6606,6606,6606,6606,6606,6604,6604,6604,6604,6604,6604,6604,6609,6609,6609,6609,6609,6609,6609,3288,3288,3288,3288,3288,3289,3289,3289,3289,3289,3291,3291,3291,3291,3291,3290,3290,3290,3290,3290,3295,3295,3295,3295,3295,3292,3292,3292,3292,3292,3293,3293,3293,3293,3293,3294,3294,3294,3294,3294) ) as s GROUP BY id_product_ps ) as ss | 0.035 | 28 |
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 (3286,3286,3287,3287,5841,5841,5841,5841,5841,5841,5841,9296,9296,9296,9296,9296,9296,9296,5840,5840,5840,5840,5840,5840,5840,9294,9294,9294,9294,9294,9294,9294,5838,5838,5838,5838,5838,5838,5838,5839,5839,5839,5839,5839,5839,5839,9295,9295,9295,9295,9295,9295,9295,5843,5843,5843,5843,5843,5843,5843,9300,9300,9300,9300,9300,9300,9300,9299,9299,9299,9299,9299,9299,9299,5844,5844,5844,5844,5844,5844,5844,9297,9297,9297,9297,9297,9297,9297,9298,9298,9298,9298,9298,9298,9298,5842,5842,5842,5842,5842,5842,5842,2896,2896,2896,2896,2896,2896,2896,2895,2895,2895,2895,2895,2895,2895,2892,2892,2892,2892,2892,2892,2892,2897,2897,2897,2897,2897,2897,2897,2894,2894,2894,2894,2894,2894,2894,2893,2893,2893,2893,2893,2893,2893,3961,3961,3961,3961,3961,3962,3962,3962,3962,3962,3963,3963,3963,3963,3963,9260,9260,9260,9260,9260,3960,3960,3960,3960,3960,6610,6610,6610,6610,6610,6610,6610,6614,6614,6614,6614,6614,6614,6614,6612,6612,6612,6612,6612,6612,6612,6615,6615,6615,6615,6615,6615,6615,6613,6613,6613,6613,6613,6613,6613,6611,6611,6611,6611,6611,6611,6611,6617,6617,6617,6617,6617,6617,6620,6620,6620,6620,6620,6620,6616,6616,6616,6616,6616,6616,6619,6619,6619,6619,6619,6619,6618,6618,6618,6618,6618,6618,3735,3967,3967,3967,3967,3967,9261,9261,9261,9261,9261,3964,3964,3964,3964,3964,3965,3965,3965,3965,3965,3966,3966,3966,3966,3966,2891,2891,2891,2891,2891,2890,2890,2890,2890,2890,2888,2888,2888,2888,2888,2889,2889,2889,2889,2889,5852,5852,5852,5852,5852,5852,5852,5855,5855,5855,5855,5855,5855,5855,5857,5857,5857,5857,5857,5857,5857,5854,5854,5854,5854,5854,5854,5854,5853,5853,5853,5853,5853,5853,5853,5856,5856,5856,5856,5856,5856,5856,5861,5861,5861,5861,5861,5861,5861,5863,5863,5863,5863,5863,5863,5863,5862,5862,5862,5862,5862,5862,5862,5859,5859,5859,5859,5859,5859,5859,5858,5858,5858,5858,5858,5858,5858,5860,5860,5860,5860,5860,5860,5860,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,3451,3451,3451,3451,3451,3451,3451,3453,3453,3453,3453,3453,3453,3453,3452,3452,3452,3452,3452,3452,3452,3456,3456,3456,3456,3456,3456,3456,3455,3455,3455,3455,3455,3455,3455,3454,3454,3454,3454,3454,3454,3454,3458,3458,3458,3458,3458,3457,3457,3457,3457,3457,3461,3461,3461,3461,3461,3460,3460,3460,3460,3460,3459,3459,3459,3459,3459,5870,5870,5870,5868,5868,5868,5869,5869,5869,6251,6252,6252,2900,2900,2900,2900,2900,2901,2901,2901,2901,2901,2899,2899,2899,2899,2899,2898,2898,2898,2898,2898,4024,4024,4024,4024,4024,4024,4024,4025,4025,4025,4025,4025,4025,4025,4026,4026,4026,4026,4026,4026,4026,4023,4023,4023,4023,4023,4023,4023,4028,4028,4028,4028,4028,4028,4028,4027,4027,4027,4027,4027,4027,4027,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6644,6644,6644,6644,6644,6644,6644,6644,6644,6641,6641,6641,6641,6641,6641,6641,6641,6641,6643,6643,6643,6643,6643,6643,6643,6643,6643,6638,6638,6638,6638,6638,6638,6638,6638,6638,6640,6640,6640,6640,6640,6640,6640,6640,6640,6639,6639,6639,6639,6639,6639,6639,6639,6639,6642,6642,6642,6642,6642,6642,6642,6642,6642,5867,5867,5867,5867,5867,5865,5865,5865,5865,5865,6621,6621,6621,6621,6621,6621,6621,6621,6621,6626,6626,6626,6626,6626,6626,6626,6626,6626,6623,6623,6623,6623,6623,6623,6623,6623,6623,6627,6627,6627,6627,6627,6627,6627,6627,6627,6628,6628,6628,6628,6628,6628,6628,6628,6628,6624,6624,6624,6624,6624,6624,6624,6624,6624,6625,6625,6625,6625,6625,6625,6625,6625,6625,6622,6622,6622,6622,6622,6622,6622,6622,6622,6605,6605,6605,6605,6605,6605,6605,6608,6608,6608,6608,6608,6608,6608,6607,6607,6607,6607,6607,6607,6607,6606,6606,6606,6606,6606,6606,6606,6604,6604,6604,6604,6604,6604,6604,6609,6609,6609,6609,6609,6609,6609,3288,3288,3288,3288,3288,3289,3289,3289,3289,3289,3291,3291,3291,3291,3291,3290,3290,3290,3290,3290,3295,3295,3295,3295,3295,3292,3292,3292,3292,3292,3293,3293,3293,3293,3293,3294,3294,3294,3294,3294) ) 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 12 ,12 | 0.041 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (3286,3286,3287,3287,5841,5841,5841,5841,5841,5841,5841,9296,9296,9296,9296,9296,9296,9296,5840,5840,5840,5840,5840,5840,5840,9294,9294,9294,9294,9294,9294,9294,5838,5838,5838,5838,5838,5838,5838,5839,5839,5839,5839,5839,5839,5839,9295,9295,9295,9295,9295,9295,9295,5843,5843,5843,5843,5843,5843,5843,9300,9300,9300,9300,9300,9300,9300,9299,9299,9299,9299,9299,9299,9299,5844,5844,5844,5844,5844,5844,5844,9297,9297,9297,9297,9297,9297,9297,9298,9298,9298,9298,9298,9298,9298,5842,5842,5842,5842,5842,5842,5842,2896,2896,2896,2896,2896,2896,2896,2895,2895,2895,2895,2895,2895,2895,2892,2892,2892,2892,2892,2892,2892,2897,2897,2897,2897,2897,2897,2897,2894,2894,2894,2894,2894,2894,2894,2893,2893,2893,2893,2893,2893,2893,3961,3961,3961,3961,3961,3962,3962,3962,3962,3962,3963,3963,3963,3963,3963,9260,9260,9260,9260,9260,3960,3960,3960,3960,3960,6610,6610,6610,6610,6610,6610,6610,6614,6614,6614,6614,6614,6614,6614,6612,6612,6612,6612,6612,6612,6612,6615,6615,6615,6615,6615,6615,6615,6613,6613,6613,6613,6613,6613,6613,6611,6611,6611,6611,6611,6611,6611,6617,6617,6617,6617,6617,6617,6620,6620,6620,6620,6620,6620,6616,6616,6616,6616,6616,6616,6619,6619,6619,6619,6619,6619,6618,6618,6618,6618,6618,6618,3735,3967,3967,3967,3967,3967,9261,9261,9261,9261,9261,3964,3964,3964,3964,3964,3965,3965,3965,3965,3965,3966,3966,3966,3966,3966,2891,2891,2891,2891,2891,2890,2890,2890,2890,2890,2888,2888,2888,2888,2888,2889,2889,2889,2889,2889,5852,5852,5852,5852,5852,5852,5852,5855,5855,5855,5855,5855,5855,5855,5857,5857,5857,5857,5857,5857,5857,5854,5854,5854,5854,5854,5854,5854,5853,5853,5853,5853,5853,5853,5853,5856,5856,5856,5856,5856,5856,5856,5861,5861,5861,5861,5861,5861,5861,5863,5863,5863,5863,5863,5863,5863,5862,5862,5862,5862,5862,5862,5862,5859,5859,5859,5859,5859,5859,5859,5858,5858,5858,5858,5858,5858,5858,5860,5860,5860,5860,5860,5860,5860,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,3451,3451,3451,3451,3451,3451,3451,3453,3453,3453,3453,3453,3453,3453,3452,3452,3452,3452,3452,3452,3452,3456,3456,3456,3456,3456,3456,3456,3455,3455,3455,3455,3455,3455,3455,3454,3454,3454,3454,3454,3454,3454,3458,3458,3458,3458,3458,3457,3457,3457,3457,3457,3461,3461,3461,3461,3461,3460,3460,3460,3460,3460,3459,3459,3459,3459,3459,5870,5870,5870,5868,5868,5868,5869,5869,5869,6251,6252,6252,2900,2900,2900,2900,2900,2901,2901,2901,2901,2901,2899,2899,2899,2899,2899,2898,2898,2898,2898,2898,4024,4024,4024,4024,4024,4024,4024,4025,4025,4025,4025,4025,4025,4025,4026,4026,4026,4026,4026,4026,4026,4023,4023,4023,4023,4023,4023,4023,4028,4028,4028,4028,4028,4028,4028,4027,4027,4027,4027,4027,4027,4027,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6644,6644,6644,6644,6644,6644,6644,6644,6644,6641,6641,6641,6641,6641,6641,6641,6641,6641,6643,6643,6643,6643,6643,6643,6643,6643,6643,6638,6638,6638,6638,6638,6638,6638,6638,6638,6640,6640,6640,6640,6640,6640,6640,6640,6640,6639,6639,6639,6639,6639,6639,6639,6639,6639,6642,6642,6642,6642,6642,6642,6642,6642,6642,5867,5867,5867,5867,5867,5865,5865,5865,5865,5865,6621,6621,6621,6621,6621,6621,6621,6621,6621,6626,6626,6626,6626,6626,6626,6626,6626,6626,6623,6623,6623,6623,6623,6623,6623,6623,6623,6627,6627,6627,6627,6627,6627,6627,6627,6627,6628,6628,6628,6628,6628,6628,6628,6628,6628,6624,6624,6624,6624,6624,6624,6624,6624,6624,6625,6625,6625,6625,6625,6625,6625,6625,6625,6622,6622,6622,6622,6622,6622,6622,6622,6622,6605,6605,6605,6605,6605,6605,6605,6608,6608,6608,6608,6608,6608,6608,6607,6607,6607,6607,6607,6607,6607,6606,6606,6606,6606,6606,6606,6606,6604,6604,6604,6604,6604,6604,6604,6609,6609,6609,6609,6609,6609,6609,3288,3288,3288,3288,3288,3289,3289,3289,3289,3289,3291,3291,3291,3291,3291,3290,3290,3290,3290,3290,3295,3295,3295,3295,3295,3292,3292,3292,3292,3292,3293,3293,3293,3293,3293,3294,3294,3294,3294,3294) | 0.003 | 1080 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (2889,8979,2890,2891,2888,8979,2891,2889,2890,2888,2891,8979,2889,2888,2890,2890,8979,2889,2891,2888,2897,2893,8980,2895,2892,2894,2896,2894,2896,2892,2895,8980,2897,2893,2892,2897,8980,2896,2895,2894,2893,2897,2896,2892,8980,2894,2895,2893,2897,2892,2895,8980,2894,2893,2896,2892,2896,2893,2895,8980,2894,2897,2899,8981,2901,2900,2898,8981,2901,2900,2899,2898,2901,8981,2899,2898,2900,2900,8981,2899,2898,2901,3287,3286,3286,3287,3291,8991,3290,3289,3288,3288,8991,3291,3289,3290,3291,8991,3288,3289,3290,3288,3289,8991,3290,3291,3293,8992,3295,3294,3292,8992,3295,3293,3294,3292,3295,8992,3293,3294,3292,3294,3293,8992,3295,3292,3452,3456,3453,9004,3451,3454,3455,3453,3451,3455,3456,9004,3454,3452,3451,3456,9004,3455,3454,3453,3452,3456,3455,3451,9004,3453,3452,3454,3456,3454,3451,9004,3453,3455,3452,3455,3451,3454,9004,3453,3456,3452,3458,3459,3461,3457,3460,3459,3457,3460,3461,3458,3457,3461,3459,3460,3458,3461,3457,3459,3458,3460,3460,3459,3457,3461,3458,3735,9260,3961,3962,3963,3960,3962,3963,3960,9260,3961,3960,9260,3963,3962,3961,9260,3962,3960,3963,3961,9261,3967,3965,3966,3964,3966,3964,9261,3965,3967,3964,9261,3966,3967,3965,9261,3964,3966,3967,3965,9889,4025,4028,4024,4026,4023,4027,9889,4026,4025,4023,4028,4027,4024,4026,4028,4024,9889,4023,4027,4025,4024,4023,9889,4028,4026,4027,4025,9889,4028,4024,4023,4026,4025,4027,9889,4024,4027,4026,4023,4025,4028,9296,5840,9295,9294,5839,5838,5841,9296,5840,9295,9294,5838,5841,5839,9296,5841,9295,5839,9294,5838,5840,5839,5838,9296,9295,5841,9294,5840,9300,5844,9299,9298,5843,5842,9297,9300,5844,9299,5842,9298,5843,9297,9300,9299,5843,5842,9298,9297,5844,5853,5857,5856,9044,5855,5852,5854,5857,5852,5854,5856,5855,9044,5853,5857,5852,5856,9044,5855,5853,5854,5857,5852,5856,9044,5853,5854,5855,5857,5855,5853,5852,9044,5856,5854,5856,5855,5852,9044,5854,5857,5853,5859,5863,5860,9045,5861,5862,5858,5860,5862,5858,5863,9045,5861,5859,5858,5863,9045,5862,5860,5861,5859,5863,5858,5862,9045,5860,5861,5859,5863,5858,5861,5860,9045,5862,5859,5862,5861,5858,9045,5860,5863,5859,9046,5867,5865,5866,5864,5865,9046,5864,5867,5866,5870,5868,5869,5868,5870,5869,5869,5870,5868,6251,6252,9071,6294,6287,6293,6286,6292,6285,6291,6290,9076,6288,6284,6289,6294,6287,6293,6286,6292,6288,6284,6291,6290,9076,6289,6285,6294,6287,6293,6292,6285,6288,6291,6284,6290,9076,6289,6286,6294,6293,6286,6292,6288,6291,6285,6284,6290,9076,6289,6287,6287,6286,6294,6285,6293,6292,6284,6291,9076,6290,6288,6289,6294,6287,6293,6286,6292,6285,6291,6284,9076,6290,6288,6289,6287,6294,6293,6286,6292,6285,6291,6284,9076,6289,6288,6290,6287,6294,6293,6286,6292,6285,6290,6289,6284,9076,6288,6291,6294,6287,6293,6286,6291,6290,6285,6284,6289,9076,6288,6292,6287,6294,6292,6291,6286,6290,6285,6289,6284,9076,6288,6293,6293,6287,6292,6291,6286,6290,6285,6289,6284,9076,6288,6294,6298,6304,6303,6297,6302,6296,6299,9077,6295,6300,6301,6298,6304,6303,6297,6299,6302,6295,6301,9077,6300,6296,6298,6299,6304,6296,6303,6302,6295,6301,9077,6300,6297,6299,6297,6303,6304,6302,6296,6301,6295,6300,9077,6298,6297,6296,6304,6295,6303,6302,9077,6301,6299,6300,6298,6304,6303,6297,6296,6302,6295,6301,9077,6299,6298,6300,6304,6303,6297,6296,6302,6295,6300,9077,6299,6301,6298,6304,6297,6303,6296,6301,6300,6295,9077,6299,6302,6298,6304,6297,6302,6296,6301,6300,6295,9077,6299,6298,6303,6303,6302,6297,6301,6300,6296,6295,9077,6299,6298,6304,6605,6609,6606,9083,6604,6607,6608,6606,6604,6608,6609,9083,6607,6605,6604,6609,9083,6608,6607,6606,6605,6609,6604,6608,9083,6606,6607,6605,6609,6604,6607,6606,9083,6608,6605,6608,6607,6604,6606,9083,6609,6605,6615,6611,6614,9084,6613,6610,6612,6610,6615,9084,6614,6613,6611,6612,6611,6610,6615,9084,6614,6613,6612,6615,6614,6610,9084,6612,6613,6611,6615,6613,6610,6611,9084,6612,6614,6614,6613,6610,6611,9084,6615,6612,6620,6619,9085,6617,6618,6616,6616,6620,9085,6619,6618,6617,6620,6616,9085,6619,6617,6618,6616,6620,9085,6618,6617,6619,6619,6618,6616,9085,6620,6617,6623,6628,6627,6622,6624,9086,6625,6621,6626,6623,6624,6628,6621,6627,6626,9086,6625,6622,6624,6627,6622,6621,6628,6626,6625,9086,6623,6622,6628,6621,6627,9086,6626,6625,6624,6623,6628,6622,6627,6621,6626,9086,6624,6625,6623,6628,6627,6622,6621,6625,6624,9086,6623,6626,6628,6622,6626,6625,6621,9086,6624,6627,6623,6627,6626,6622,6625,6621,9086,6624,6628,6623,6637,6631,6636,6635,6630,6634,9087,6633,6629,6632,9972,6631,6632,6637,6636,6635,6629,6634,9087,6633,9972,6630,6632,6636,6630,6637,6635,6634,6629,9087,9972,6633,6631,6630,6629,9972,6637,6636,6635,9087,6634,6633,6632,6631,6637,6636,6630,6635,6629,9972,6633,9087,6632,6631,6634,6637,6630,6636,6629,6633,9972,6634,9087,6632,6631,6635,6637,6630,6635,6629,6633,9972,9087,6634,6632,6636,6631,6636,6635,6630,6633,6629,9972,9087,6632,6634,6631,6637,9721,6640,6644,6639,6641,9088,6642,6638,6643,9721,6640,6641,6638,6644,6643,9088,6642,6639,6641,6644,6639,9721,6638,6643,9088,6642,6640,6639,6638,9721,6644,9088,6643,6642,6641,6640,9721,6644,6639,6643,6638,9088,6641,6640,6642,9721,6639,6644,6642,6638,9088,6641,6640,6643,9721,6639,6643,6642,6638,9088,6641,6640,6644,3960,3963,3961,9260,3962,3964,3967,3965,3966,9261,9296,5840,9295,5838,5839,5841,9294,9296,5840,5839,9294,5838,9295,5841,9295,5839,9294,5840,5838,9296,5841,5843,5842,5844,9300,9299,9298,9297,9300,5844,9299,5842,5843,9297,9298,9300,5843,5844,9298,9297,5842,9299,9299,9298,5843,5844,9297,5842,9300,6637,6631,6636,6630,6635,6634,6629,9087,6633,6632,9972) | 0.003 | 1243 |
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 (8979,2888,2891,2890,2889,2888,2891,8979,2890,2889,2891,2888,8979,2889,2890,2890,2888,8979,2889,2891,2893,2897,2894,2896,2895,8980,2892,2892,2897,8980,2893,2896,2895,2894,2893,2897,2892,2896,8980,2895,2894,2893,2897,2896,2892,8980,2894,2895,2893,2897,2895,2892,2894,8980,2896,2892,2896,2893,2895,8980,2894,2897,8981,2898,2901,2900,2899,2898,2901,8981,2900,2899,2901,2898,2899,8981,2900,2900,2898,2899,8981,2901,3287,3286,3286,3287,3289,3291,8991,3290,3288,3291,8991,3289,3290,3288,3288,3291,8991,3289,3290,3288,3290,8991,3289,3291,8992,3292,3295,3294,3293,3292,3295,8992,3294,3293,3295,3292,8992,3293,3294,3294,3292,8992,3295,3293,3452,3453,3456,3455,3454,9004,3451,3451,9004,3452,3456,3455,3454,3453,3452,3456,3451,3455,9004,3454,3453,3456,3452,3455,3451,9004,3453,3454,3456,3452,3454,3451,3453,9004,3455,3455,3452,3454,3451,3453,9004,3456,3458,3459,3461,3460,3457,3457,3458,3461,3460,3459,3458,3461,3457,3460,3459,3461,3458,3459,3457,3460,3460,3458,3459,3457,3461,3735,3962,9260,3961,3963,3960,3960,9260,3961,3963,3962,3961,3963,3960,9260,3962,3961,9260,3962,3960,3963,3966,9261,3965,3967,3964,3964,9261,3965,3967,3966,3965,3964,9261,3966,3967,3964,9261,3965,3966,3967,4025,9889,4024,4026,4028,4027,4023,4026,9889,4025,4028,4027,4023,4024,4024,9889,4023,4025,4028,4027,4026,4025,4024,4028,9889,4023,4027,4026,4028,4025,9889,4024,4026,4023,4027,4025,9889,4027,4024,4023,4026,4028,5841,9296,5840,9295,5839,9294,5838,5841,9296,5840,9295,5838,9294,5839,5839,9296,9295,5838,9294,5841,5840,5840,9296,5839,5838,5841,9295,9294,9297,9300,5844,9299,5843,9298,5842,9297,9300,5844,9299,9298,5842,5843,9297,9300,5843,9299,5842,9298,5844,5853,5854,5857,5856,5855,9044,5852,5852,5856,5857,5855,9044,5854,5853,5853,5857,5852,5856,5855,9044,5854,5857,5856,5853,5852,5854,9044,5855,5857,5853,5852,5855,5854,9044,5856,5856,5854,5853,5855,5852,9044,5857,5859,5860,5863,5862,5861,9045,5858,5858,9045,5859,5863,5862,5861,5860,5859,5863,5858,5862,9045,5861,5860,5863,5859,5862,5858,9045,5860,5861,5863,5859,5861,5858,5860,9045,5862,5862,5859,5861,5858,9045,5860,5863,9046,5864,5867,5866,5865,5864,5867,9046,5866,5865,5864,5867,9046,5865,5866,5866,5864,5865,9046,5867,5869,5870,5868,5870,5868,5869,5868,5869,5870,6251,6252,9071,6294,6287,6293,6292,6286,6285,6288,6291,6290,6289,9076,6284,6294,6287,6293,6286,6288,6292,6291,6290,6289,6284,9076,6285,6294,6287,6292,6293,6291,6288,6285,6290,6284,6289,9076,6286,6293,6294,6292,6288,6291,6290,6286,6289,6285,6284,9076,6287,6287,6294,6286,6293,6285,6292,6291,6284,6290,9076,6289,6288,6294,6293,6287,6292,6286,6291,6285,6284,6290,9076,6288,6289,6294,6293,6287,6292,6286,6291,6285,6284,9076,6289,6290,6288,6294,6293,6287,6292,6286,6285,6290,6284,6289,9076,6288,6291,6294,6287,6293,6286,6291,6285,6290,6284,6289,9076,6288,6292,6294,6287,6292,6291,6286,6290,6285,6284,6289,9076,6288,6293,6293,6287,6292,6291,6286,6290,6285,6289,6284,9076,6294,6288,6298,6304,6297,6303,6296,6302,6299,6301,6300,9077,6295,6298,6299,6304,6297,6303,6302,6301,6295,6300,9077,6296,6298,6299,6304,6303,6302,6296,6301,6295,6300,9077,6297,6297,6296,6295,9077,6298,6304,6303,6302,6301,6300,6299,6298,6297,6304,6296,6303,6302,6295,6301,9077,6300,6299,6304,6298,6303,6297,6302,6296,6301,6295,9077,6299,6300,6304,6298,6303,6302,6297,6296,6300,6295,9077,6299,6301,6304,6298,6303,6297,6301,6296,6295,6300,9077,6299,6302,6304,6298,6297,6302,6296,6301,6295,6300,9077,6299,6303,6303,6298,6302,6301,6300,6297,6296,6295,9077,6299,6304,6605,6606,6609,6608,6607,9083,6604,6604,9083,6605,6609,6608,6607,6606,6605,6609,6604,6608,9083,6607,6606,6609,6605,6608,6604,9083,6606,6607,6609,6605,6607,6604,9083,6606,6608,6608,6605,6607,6604,6606,9083,6609,6611,6612,6615,6614,9084,6613,6610,6612,6610,6615,9084,6614,6611,6613,6615,6610,6614,9084,6613,6612,6611,6615,6614,6610,6611,6612,9084,6613,6615,6610,6611,6613,6612,9084,6614,6614,6610,6613,6611,6612,9084,6615,6619,6620,6618,6617,9085,6616,6620,6616,6619,9085,6618,6617,6620,6616,6619,9085,6617,6618,6620,6616,6618,9085,6619,6617,6619,6616,6618,9085,6620,6617,6623,6628,6624,6622,6627,6626,6625,9086,6621,6623,6624,6628,6627,6626,6621,6625,9086,6622,6622,6621,9086,6623,6628,6627,6626,6625,6624,6623,6622,6628,6627,6621,6626,9086,6625,6624,6628,6623,6627,6622,6626,6621,6624,9086,6625,6628,6623,6627,6622,6625,6621,9086,6624,6626,6628,6623,6626,6622,6621,6625,9086,6624,6627,6627,6623,6626,6625,6622,6621,6624,9086,6628,6632,6637,6636,6631,6635,6630,6634,9972,9087,6633,6629,6631,6632,6637,6636,6635,6629,6634,9972,9087,6633,6630,6630,6629,9972,9087,6637,6636,6635,6634,6631,6633,6632,6631,6630,6637,6636,6635,6629,9972,6634,9087,6632,6633,6637,6636,6630,6635,6629,9972,6634,6631,9087,6633,6632,6631,6637,6636,6630,6629,9972,6635,6633,6632,9087,6634,6637,6631,6636,6629,6630,6634,9972,6633,9087,6632,6635,6637,6631,6629,6635,6630,6634,9972,6633,9087,6632,6636,6636,6629,6631,6635,6634,6630,9972,9087,6633,6632,6637,6640,9721,6639,6644,6641,6643,6642,9088,6638,6641,9721,6640,6644,6643,6638,6642,9088,6639,6639,9721,6638,9088,6640,6644,6643,6642,6641,6640,6639,6644,9721,6638,6643,9088,6642,6641,6644,6640,9721,6639,6643,6638,6641,9088,6642,6644,6640,9721,6639,6642,6638,6641,9088,6643,6640,9721,6643,6639,6638,6642,9088,6641,6644,2888,2889,2891,2890,8979,2893,2897,2892,2896,2895,2894,8980,2898,2901,2899,2900,8981,3288,3289,3290,3291,8991,3292,3293,3295,3294,8992,3452,3456,3451,3453,3454,3455,9004,5857,5852,5856,5855,5854,5853,9044,5859,5863,5858,5860,5861,5862,9045,5864,5865,5867,5866,9046,9071,6252,6294,6287,6293,6286,6292,6285,6291,6284,6290,6289,6288,9076,6298,6304,6303,6297,6296,6302,6295,6299,6301,6300,9077,9083,6605,6609,6604,6608,6606,6607,9084,6615,6611,6610,6612,6614,6613,9085,6620,6616,6619,6618,6617,6623,6628,6622,6627,6621,6624,6626,6625,9086,6637,6631,6636,6630,6629,6635,9972,6632,6634,6633,9087,6640,6644,6639,6638,6641,6642,6643,9088,3960,3963,3961,3962,9260,3964,3967,3965,3966,9261,9296,5840,9295,5839,5838,5841,9294,9296,5840,5839,5838,9294,5841,9295,5840,5839,9295,9294,5841,5838,9296,9300,9299,5843,9298,9297,5842,5844,9300,5844,9299,5842,5843,9297,9298,9300,5844,5843,9298,5842,9297,9299,5844,5843,9299,5842,9298,9297,9300,6639,6644,6640,6638,6643,6642,6641,9088,9721,4024,4028,4025,4023,4027,9889,4026,6637,6632,6631,6636,6630,6635,6634,6629,6633,9087,9972)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.003 | 14 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 48 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 9 | 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` = '48'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.003 | 33 |
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 (3286,3286,3287,3287,5841,5841,5841,5841,5841,5841,5841,9296,9296,9296,9296,9296,9296,9296,5840,5840,5840,5840,5840,5840,5840,9294,9294,9294,9294,9294,9294,9294,5838,5838,5838,5838,5838,5838,5838,5839,5839,5839,5839,5839,5839,5839,9295,9295,9295,9295,9295,9295,9295,5843,5843,5843,5843,5843,5843,5843,9300,9300,9300,9300,9300,9300,9300,9299,9299,9299,9299,9299,9299,9299,5844,5844,5844,5844,5844,5844,5844,9297,9297,9297,9297,9297,9297,9297,9298,9298,9298,9298,9298,9298,9298,5842,5842,5842,5842,5842,5842,5842,2896,2896,2896,2896,2896,2896,2896,2895,2895,2895,2895,2895,2895,2895,2892,2892,2892,2892,2892,2892,2892,2897,2897,2897,2897,2897,2897,2897,2894,2894,2894,2894,2894,2894,2894,2893,2893,2893,2893,2893,2893,2893,3961,3961,3961,3961,3961,3962,3962,3962,3962,3962,3963,3963,3963,3963,3963,9260,9260,9260,9260,9260,3960,3960,3960,3960,3960,6610,6610,6610,6610,6610,6610,6610,6614,6614,6614,6614,6614,6614,6614,6612,6612,6612,6612,6612,6612,6612,6615,6615,6615,6615,6615,6615,6615,6613,6613,6613,6613,6613,6613,6613,6611,6611,6611,6611,6611,6611,6611,6617,6617,6617,6617,6617,6617,6620,6620,6620,6620,6620,6620,6616,6616,6616,6616,6616,6616,6619,6619,6619,6619,6619,6619,6618,6618,6618,6618,6618,6618,3735,3967,3967,3967,3967,3967,9261,9261,9261,9261,9261,3964,3964,3964,3964,3964,3965,3965,3965,3965,3965,3966,3966,3966,3966,3966,2891,2891,2891,2891,2891,2890,2890,2890,2890,2890,2888,2888,2888,2888,2888,2889,2889,2889,2889,2889,5852,5852,5852,5852,5852,5852,5852,5855,5855,5855,5855,5855,5855,5855,5857,5857,5857,5857,5857,5857,5857,5854,5854,5854,5854,5854,5854,5854,5853,5853,5853,5853,5853,5853,5853,5856,5856,5856,5856,5856,5856,5856,5861,5861,5861,5861,5861,5861,5861,5863,5863,5863,5863,5863,5863,5863,5862,5862,5862,5862,5862,5862,5862,5859,5859,5859,5859,5859,5859,5859,5858,5858,5858,5858,5858,5858,5858,5860,5860,5860,5860,5860,5860,5860,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,3451,3451,3451,3451,3451,3451,3451,3453,3453,3453,3453,3453,3453,3453,3452,3452,3452,3452,3452,3452,3452,3456,3456,3456,3456,3456,3456,3456,3455,3455,3455,3455,3455,3455,3455,3454,3454,3454,3454,3454,3454,3454,3458,3458,3458,3458,3458,3457,3457,3457,3457,3457,3461,3461,3461,3461,3461,3460,3460,3460,3460,3460,3459,3459,3459,3459,3459,5870,5870,5870,5868,5868,5868,5869,5869,5869,6251,6252,6252,2900,2900,2900,2900,2900,2901,2901,2901,2901,2901,2899,2899,2899,2899,2899,2898,2898,2898,2898,2898,4024,4024,4024,4024,4024,4024,4024,4025,4025,4025,4025,4025,4025,4025,4026,4026,4026,4026,4026,4026,4026,4023,4023,4023,4023,4023,4023,4023,4028,4028,4028,4028,4028,4028,4028,4027,4027,4027,4027,4027,4027,4027,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6644,6644,6644,6644,6644,6644,6644,6644,6644,6641,6641,6641,6641,6641,6641,6641,6641,6641,6643,6643,6643,6643,6643,6643,6643,6643,6643,6638,6638,6638,6638,6638,6638,6638,6638,6638,6640,6640,6640,6640,6640,6640,6640,6640,6640,6639,6639,6639,6639,6639,6639,6639,6639,6639,6642,6642,6642,6642,6642,6642,6642,6642,6642,5867,5867,5867,5867,5867,5865,5865,5865,5865,5865,6621,6621,6621,6621,6621,6621,6621,6621,6621,6626,6626,6626,6626,6626,6626,6626,6626,6626,6623,6623,6623,6623,6623,6623,6623,6623,6623,6627,6627,6627,6627,6627,6627,6627,6627,6627,6628,6628,6628,6628,6628,6628,6628,6628,6628,6624,6624,6624,6624,6624,6624,6624,6624,6624,6625,6625,6625,6625,6625,6625,6625,6625,6625,6622,6622,6622,6622,6622,6622,6622,6622,6622,6605,6605,6605,6605,6605,6605,6605,6608,6608,6608,6608,6608,6608,6608,6607,6607,6607,6607,6607,6607,6607,6606,6606,6606,6606,6606,6606,6606,6604,6604,6604,6604,6604,6604,6604,6609,6609,6609,6609,6609,6609,6609,3288,3288,3288,3288,3288,3289,3289,3289,3289,3289,3291,3291,3291,3291,3291,3290,3290,3290,3290,3290,3295,3295,3295,3295,3295,3292,3292,3292,3292,3292,3293,3293,3293,3293,3293,3294,3294,3294,3294,3294) | 0.003 | 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 (3286,3286,3287,3287,5841,5841,5841,5841,5841,5841,5841,9296,9296,9296,9296,9296,9296,9296,5840,5840,5840,5840,5840,5840,5840,9294,9294,9294,9294,9294,9294,9294,5838,5838,5838,5838,5838,5838,5838,5839,5839,5839,5839,5839,5839,5839,9295,9295,9295,9295,9295,9295,9295,5843,5843,5843,5843,5843,5843,5843,9300,9300,9300,9300,9300,9300,9300,9299,9299,9299,9299,9299,9299,9299,5844,5844,5844,5844,5844,5844,5844,9297,9297,9297,9297,9297,9297,9297,9298,9298,9298,9298,9298,9298,9298,5842,5842,5842,5842,5842,5842,5842,2896,2896,2896,2896,2896,2896,2896,2895,2895,2895,2895,2895,2895,2895,2892,2892,2892,2892,2892,2892,2892,2897,2897,2897,2897,2897,2897,2897,2894,2894,2894,2894,2894,2894,2894,2893,2893,2893,2893,2893,2893,2893,3961,3961,3961,3961,3961,3962,3962,3962,3962,3962,3963,3963,3963,3963,3963,9260,9260,9260,9260,9260,3960,3960,3960,3960,3960,6610,6610,6610,6610,6610,6610,6610,6614,6614,6614,6614,6614,6614,6614,6612,6612,6612,6612,6612,6612,6612,6615,6615,6615,6615,6615,6615,6615,6613,6613,6613,6613,6613,6613,6613,6611,6611,6611,6611,6611,6611,6611,6617,6617,6617,6617,6617,6617,6620,6620,6620,6620,6620,6620,6616,6616,6616,6616,6616,6616,6619,6619,6619,6619,6619,6619,6618,6618,6618,6618,6618,6618,3735,3967,3967,3967,3967,3967,9261,9261,9261,9261,9261,3964,3964,3964,3964,3964,3965,3965,3965,3965,3965,3966,3966,3966,3966,3966,2891,2891,2891,2891,2891,2890,2890,2890,2890,2890,2888,2888,2888,2888,2888,2889,2889,2889,2889,2889,5852,5852,5852,5852,5852,5852,5852,5855,5855,5855,5855,5855,5855,5855,5857,5857,5857,5857,5857,5857,5857,5854,5854,5854,5854,5854,5854,5854,5853,5853,5853,5853,5853,5853,5853,5856,5856,5856,5856,5856,5856,5856,5861,5861,5861,5861,5861,5861,5861,5863,5863,5863,5863,5863,5863,5863,5862,5862,5862,5862,5862,5862,5862,5859,5859,5859,5859,5859,5859,5859,5858,5858,5858,5858,5858,5858,5858,5860,5860,5860,5860,5860,5860,5860,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6284,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6286,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6287,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6290,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6294,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6285,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6291,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6293,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6289,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6292,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6288,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6303,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6298,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6300,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6299,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6296,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6302,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6301,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6297,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6304,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,6295,3451,3451,3451,3451,3451,3451,3451,3453,3453,3453,3453,3453,3453,3453,3452,3452,3452,3452,3452,3452,3452,3456,3456,3456,3456,3456,3456,3456,3455,3455,3455,3455,3455,3455,3455,3454,3454,3454,3454,3454,3454,3454,3458,3458,3458,3458,3458,3457,3457,3457,3457,3457,3461,3461,3461,3461,3461,3460,3460,3460,3460,3460,3459,3459,3459,3459,3459,5870,5870,5870,5868,5868,5868,5869,5869,5869,6251,6252,6252,2900,2900,2900,2900,2900,2901,2901,2901,2901,2901,2899,2899,2899,2899,2899,2898,2898,2898,2898,2898,4024,4024,4024,4024,4024,4024,4024,4025,4025,4025,4025,4025,4025,4025,4026,4026,4026,4026,4026,4026,4026,4023,4023,4023,4023,4023,4023,4023,4028,4028,4028,4028,4028,4028,4028,4027,4027,4027,4027,4027,4027,4027,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6637,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,6631,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,9972,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6630,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6629,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6636,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6635,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6632,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6634,6644,6644,6644,6644,6644,6644,6644,6644,6644,6641,6641,6641,6641,6641,6641,6641,6641,6641,6643,6643,6643,6643,6643,6643,6643,6643,6643,6638,6638,6638,6638,6638,6638,6638,6638,6638,6640,6640,6640,6640,6640,6640,6640,6640,6640,6639,6639,6639,6639,6639,6639,6639,6639,6639,6642,6642,6642,6642,6642,6642,6642,6642,6642,5867,5867,5867,5867,5867,5865,5865,5865,5865,5865,6621,6621,6621,6621,6621,6621,6621,6621,6621,6626,6626,6626,6626,6626,6626,6626,6626,6626,6623,6623,6623,6623,6623,6623,6623,6623,6623,6627,6627,6627,6627,6627,6627,6627,6627,6627,6628,6628,6628,6628,6628,6628,6628,6628,6628,6624,6624,6624,6624,6624,6624,6624,6624,6624,6625,6625,6625,6625,6625,6625,6625,6625,6625,6622,6622,6622,6622,6622,6622,6622,6622,6622,6605,6605,6605,6605,6605,6605,6605,6608,6608,6608,6608,6608,6608,6608,6607,6607,6607,6607,6607,6607,6607,6606,6606,6606,6606,6606,6606,6606,6604,6604,6604,6604,6604,6604,6604,6609,6609,6609,6609,6609,6609,6609,3288,3288,3288,3288,3288,3289,3289,3289,3289,3289,3291,3291,3291,3291,3291,3290,3290,3290,3290,3290,3295,3295,3295,3295,3295,3292,3292,3292,3292,3292,3293,3293,3293,3293,3293,3294,3294,3294,3294,3294) | 0.003 | 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` = '6252' | 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` = '6252'
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` = '6284' | 0.000 | 12 |
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` = '6294'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 11 |
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` = '4023' | 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` = '9889'
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` = '3451' | 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` = '3452'
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` = '3457' | 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` = '3458'
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` = '2888' | 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` = '2889'
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` = '2898' | 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` = '2899'
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` = '5838' | 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` = '9296'
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` = '5842' | 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` = '9300'
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` = '5852' | 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` = '5853'
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` = '5858' | 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` = '5859'
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` = '5865' | 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` = '9046'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 4 |
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.209 | 5777 |