Queries | Time | Rows |
SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.001 | 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.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` = '6' | 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` = 6 | 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` = '6'
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 (6) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.047 | 1284 |
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 (1588,1588,1588,1587,1587,1587,1589,1589,1589,7176,7176,7176,7176,7176,7176,7176,7178,7178,7178,7178,7178,7178,7178,7180,7180,7180,7180,7180,7180,7180,7181,7181,7181,7181,7181,7181,7181,7177,7177,7177,7177,7177,7177,7177,7179,7179,7179,7179,7179,7179,7179,7182,7182,7182,7182,7182,7182,7182,793,793,793,793,794,794,794,794,795,795,795,795,796,796,796,796,5082,5082,5082,5080,5080,5080,5081,5081,5081,7151,7151,7151,7151,7148,7148,7148,7148,7149,7149,7149,7149,7150,7150,7150,7150,1415,1415,1415,1415,1414,1414,1414,1414,1417,1417,1417,1417,1416,1416,1416,1416,1463,1463,1463,1462,1462,1462,1461,1461,1461,3261,3261,3261,3261,3261,3261,3259,3259,3259,3259,3259,3259,3257,3257,3257,3257,3257,3257,3258,3258,3258,3258,3258,3258,3260,3260,3260,3260,3260,3260,3262,3262,3262,3262,3262,3262,1874,1874,1874,1876,1876,1876,1875,1875,1875,7165,7165,7165,7165,7165,7166,7166,7166,7166,7166,7167,7167,7167,7167,7167,7168,7168,7168,7168,7168,7169,7169,7169,7169,7169,1453,1453,1453,1453,1452,1452,1452,1452,1454,1454,1454,1454,1451,1451,1451,1451,3517,3517,3517,3517,3517,3517,3517,3517,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,3514,3514,3514,3514,3514,3514,3514,3514,3515,3515,3515,3515,3515,3515,3515,3515,3516,3516,3516,3516,3516,3516,3516,3516,3518,3518,3518,3518,3518,3518,3518,3518,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,5236,5236,5236,5236,5236,5237,5237,5237,5237,5237,5233,5233,5233,5233,5233,5234,5234,5234,5234,5234,5235,5235,5235,5235,5235,5074,5074,5074,5075,5075,5075,5076,5076,5076,6916,6916,6916,6916,6916,6916,6916,6916,6919,6919,6919,6919,6919,6919,6919,6919,6918,6918,6918,6918,6918,6918,6918,6918,6917,6917,6917,6917,6917,6917,6917,6917,6915,6915,6915,6915,6915,6915,6915,6915,6914,6914,6914,6914,6914,6914,6914,6914,6920,6920,6920,6920,6920,6920,6920,6920,6913,6913,6913,6913,6913,6913,6913,6913,8341,806,806,806,807,807,807,808,808,808,1343,2936,5238,3662,3662,3662,3662,3662,3662,3663,3663,3663,3663,3663,3663,3661,3661,3661,3661,3661,3661,3664,3664,3664,3664,3664,3664,3666,3666,3666,3666,3666,3666,3665,3665,3665,3665,3665,3665,787,787,787,787,787,787,788,788,788,788,788,788,789,789,789,789,789,789,790,790,790,790,790,790,791,791,791,791,791,791,792,792,792,792,792,792,495,495,495,497,497,497,496,496,496,1426,1426,1426,1426,1426,1426,1426,1426,1426,1426,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1423,1423,1423,1423,1423,1423,1423,1423,1423,1423,1429,1429,1429,1429,1429,1429,1429,1429,1429,1429,1422,1422,1422,1422,1422,1422,1422,1422,1422,1422,1424,1424,1424,1424,1424,1424,1424,1424,1424,1424,1427,1427,1427,1427,1427,1427,1427,1427,1427,1427,1421,1421,1421,1421,1421,1421,1421,1421,1421,1421,1420,1420,1420,1420,1420,1420,1420,1420,1420,1420,1428,1428,1428,1428,1428,1428,1428,1428,1428,1428,3252,3252,3252,3252,3252,3254,3254,3254,3254,3254,3253,3253,3253,3253,3253,3255,3255,3255,3255,3255,3256,3256,3256,3256,3256,8566,1708,1708,1708,1709,1709,1709,1710,1710,1710,5239,5239,5239,5239,5239,5240,5240,5240,5240,5240,5241,5241,5241,5241,5241,1849,1849,1849,1849,1849,1846,1846,1846,1846,1846,1848,1848,1848,1848,1848,1847,1847,1847,1847,1847,1845,1845,1845,1845,1845,1486,1486,1486,1486,1486,1486,1488,1488,1488,1488,1488,1488,1489,1489,1489,1489,1489,1489,1490,1490,1490,1490,1490,1490,1491,1491,1491,1491,1491,1491,1487,1487,1487,1487,1487,1487,1862,1862,1862,1862,1862,1862,1862,1862,1865,1865,1865,1865,1865,1865,1865,1865,1858,1858,1858,1858,1858,1858,1858,1858,1860,1860,1860,1860,1860,1860,1860,1860,1861,1861,1861,1861,1861,1861,1861,1861,1863,1863,1863,1863,1863,1863,1863,1863,1864,1864,1864,1864,1864,1864,1864,1864,1859,1859,1859,1859,1859,1859,1859,1859,3242,3242,3242,3242,3242,3242,3241,3241,3241,3241,3241,3241,3245,3245,3245,3245,3245,3245,3243,3243,3243,3243,3243,3243,3240,3240,3240,3240,3240,3240,3244,3244,3244,3244,3244,3244,7170,7170,7170,7170,7170,7170,7170,7171,7171,7171,7171,7171,7171,7171,7172,7172,7172,7172,7172,7172,7172,7173,7173,7173,7173,7173,7173,7173,7174,7174,7174,7174,7174,7174,7174,7175,7175,7175,7175,7175,7175,7175,3512,3512,3512,3512,3510,3510,3510,3510,3509,3509,3509,3509,3511,3511,3511,3511,3231,3232,8095,2939,2939,2939,2939,2939,2939,2939,2939,2939,2937,2937,2937,2937,2937,2937,2937,2937,2937,2944,2944,2944,2944,2944,2944,2944,2944,2944,2941,2941,2941,2941,2941,2941,2941,2941,2941,2938,2938,2938,2938,2938,2938,2938,2938,2938,2940,2940,2940,2940,2940,2940,2940,2940,2940,2943,2943,2943,2943,2943,2943,2943,2943,2943,2942,2942,2942,2942,2942,2942,2942,2942,2942,3246,3246,3246,3246,3246,3246,3247,3247,3247,3247,3247,3247,3248,3248,3248,3248,3248,3248,3249,3249,3249,3249,3249,3249,3250,3250,3250,3250,3250,3250,3251,3251,3251,3251,3251,3251,5095,1456,1456,1456,1456,1456,1456,1457,1457,1457,1457,1457,1457,1458,1458,1458,1458,1458,1458,1459,1459,1459,1459,1459,1459,1455,1455,1455,1455,1455,1455,1460,1460,1460,1460,1460,1460,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,5077,5077,5077,5079,5079,5079,5078,5078,5078,7155,7155,7155,7156,7156,7156,7157,7157,7157,5215,5215,5215,5215,5215,5215,5215,5221,5221,5221,5221,5221,5221,5221,5219,5219,5219,5219,5219,5219,5219,5216,5216,5216,5216,5216,5216,5216,5217,5217,5217,5217,5217,5217,5217,5218,5218,5218,5218,5218,5218,5218,5220,5220,5220,5220,5220,5220,5220,7154,7154,7154,7152,7152,7152,7153,7153,7153,3670,3670,3670,3670,3670,3670,3672,3672,3672,3672,3672,3672,3668,3668,3668,3668,3668,3668,3669,3669,3669,3669,3669,3669,3671,3671,3671,3671,3671,3671,3667,3667,3667,3667,3667,3667,2934,2934,2935,2935) ) as s GROUP BY id_product_ps ) as ss | 0.009 | 49 |
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 (1588,1588,1588,1587,1587,1587,1589,1589,1589,7176,7176,7176,7176,7176,7176,7176,7178,7178,7178,7178,7178,7178,7178,7180,7180,7180,7180,7180,7180,7180,7181,7181,7181,7181,7181,7181,7181,7177,7177,7177,7177,7177,7177,7177,7179,7179,7179,7179,7179,7179,7179,7182,7182,7182,7182,7182,7182,7182,793,793,793,793,794,794,794,794,795,795,795,795,796,796,796,796,5082,5082,5082,5080,5080,5080,5081,5081,5081,7151,7151,7151,7151,7148,7148,7148,7148,7149,7149,7149,7149,7150,7150,7150,7150,1415,1415,1415,1415,1414,1414,1414,1414,1417,1417,1417,1417,1416,1416,1416,1416,1463,1463,1463,1462,1462,1462,1461,1461,1461,3261,3261,3261,3261,3261,3261,3259,3259,3259,3259,3259,3259,3257,3257,3257,3257,3257,3257,3258,3258,3258,3258,3258,3258,3260,3260,3260,3260,3260,3260,3262,3262,3262,3262,3262,3262,1874,1874,1874,1876,1876,1876,1875,1875,1875,7165,7165,7165,7165,7165,7166,7166,7166,7166,7166,7167,7167,7167,7167,7167,7168,7168,7168,7168,7168,7169,7169,7169,7169,7169,1453,1453,1453,1453,1452,1452,1452,1452,1454,1454,1454,1454,1451,1451,1451,1451,3517,3517,3517,3517,3517,3517,3517,3517,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,3514,3514,3514,3514,3514,3514,3514,3514,3515,3515,3515,3515,3515,3515,3515,3515,3516,3516,3516,3516,3516,3516,3516,3516,3518,3518,3518,3518,3518,3518,3518,3518,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,5236,5236,5236,5236,5236,5237,5237,5237,5237,5237,5233,5233,5233,5233,5233,5234,5234,5234,5234,5234,5235,5235,5235,5235,5235,5074,5074,5074,5075,5075,5075,5076,5076,5076,6916,6916,6916,6916,6916,6916,6916,6916,6919,6919,6919,6919,6919,6919,6919,6919,6918,6918,6918,6918,6918,6918,6918,6918,6917,6917,6917,6917,6917,6917,6917,6917,6915,6915,6915,6915,6915,6915,6915,6915,6914,6914,6914,6914,6914,6914,6914,6914,6920,6920,6920,6920,6920,6920,6920,6920,6913,6913,6913,6913,6913,6913,6913,6913,8341,806,806,806,807,807,807,808,808,808,1343,2936,5238,3662,3662,3662,3662,3662,3662,3663,3663,3663,3663,3663,3663,3661,3661,3661,3661,3661,3661,3664,3664,3664,3664,3664,3664,3666,3666,3666,3666,3666,3666,3665,3665,3665,3665,3665,3665,787,787,787,787,787,787,788,788,788,788,788,788,789,789,789,789,789,789,790,790,790,790,790,790,791,791,791,791,791,791,792,792,792,792,792,792,495,495,495,497,497,497,496,496,496,1426,1426,1426,1426,1426,1426,1426,1426,1426,1426,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1423,1423,1423,1423,1423,1423,1423,1423,1423,1423,1429,1429,1429,1429,1429,1429,1429,1429,1429,1429,1422,1422,1422,1422,1422,1422,1422,1422,1422,1422,1424,1424,1424,1424,1424,1424,1424,1424,1424,1424,1427,1427,1427,1427,1427,1427,1427,1427,1427,1427,1421,1421,1421,1421,1421,1421,1421,1421,1421,1421,1420,1420,1420,1420,1420,1420,1420,1420,1420,1420,1428,1428,1428,1428,1428,1428,1428,1428,1428,1428,3252,3252,3252,3252,3252,3254,3254,3254,3254,3254,3253,3253,3253,3253,3253,3255,3255,3255,3255,3255,3256,3256,3256,3256,3256,8566,1708,1708,1708,1709,1709,1709,1710,1710,1710,5239,5239,5239,5239,5239,5240,5240,5240,5240,5240,5241,5241,5241,5241,5241,1849,1849,1849,1849,1849,1846,1846,1846,1846,1846,1848,1848,1848,1848,1848,1847,1847,1847,1847,1847,1845,1845,1845,1845,1845,1486,1486,1486,1486,1486,1486,1488,1488,1488,1488,1488,1488,1489,1489,1489,1489,1489,1489,1490,1490,1490,1490,1490,1490,1491,1491,1491,1491,1491,1491,1487,1487,1487,1487,1487,1487,1862,1862,1862,1862,1862,1862,1862,1862,1865,1865,1865,1865,1865,1865,1865,1865,1858,1858,1858,1858,1858,1858,1858,1858,1860,1860,1860,1860,1860,1860,1860,1860,1861,1861,1861,1861,1861,1861,1861,1861,1863,1863,1863,1863,1863,1863,1863,1863,1864,1864,1864,1864,1864,1864,1864,1864,1859,1859,1859,1859,1859,1859,1859,1859,3242,3242,3242,3242,3242,3242,3241,3241,3241,3241,3241,3241,3245,3245,3245,3245,3245,3245,3243,3243,3243,3243,3243,3243,3240,3240,3240,3240,3240,3240,3244,3244,3244,3244,3244,3244,7170,7170,7170,7170,7170,7170,7170,7171,7171,7171,7171,7171,7171,7171,7172,7172,7172,7172,7172,7172,7172,7173,7173,7173,7173,7173,7173,7173,7174,7174,7174,7174,7174,7174,7174,7175,7175,7175,7175,7175,7175,7175,3512,3512,3512,3512,3510,3510,3510,3510,3509,3509,3509,3509,3511,3511,3511,3511,3231,3232,8095,2939,2939,2939,2939,2939,2939,2939,2939,2939,2937,2937,2937,2937,2937,2937,2937,2937,2937,2944,2944,2944,2944,2944,2944,2944,2944,2944,2941,2941,2941,2941,2941,2941,2941,2941,2941,2938,2938,2938,2938,2938,2938,2938,2938,2938,2940,2940,2940,2940,2940,2940,2940,2940,2940,2943,2943,2943,2943,2943,2943,2943,2943,2943,2942,2942,2942,2942,2942,2942,2942,2942,2942,3246,3246,3246,3246,3246,3246,3247,3247,3247,3247,3247,3247,3248,3248,3248,3248,3248,3248,3249,3249,3249,3249,3249,3249,3250,3250,3250,3250,3250,3250,3251,3251,3251,3251,3251,3251,5095,1456,1456,1456,1456,1456,1456,1457,1457,1457,1457,1457,1457,1458,1458,1458,1458,1458,1458,1459,1459,1459,1459,1459,1459,1455,1455,1455,1455,1455,1455,1460,1460,1460,1460,1460,1460,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,5077,5077,5077,5079,5079,5079,5078,5078,5078,7155,7155,7155,7156,7156,7156,7157,7157,7157,5215,5215,5215,5215,5215,5215,5215,5221,5221,5221,5221,5221,5221,5221,5219,5219,5219,5219,5219,5219,5219,5216,5216,5216,5216,5216,5216,5216,5217,5217,5217,5217,5217,5217,5217,5218,5218,5218,5218,5218,5218,5218,5220,5220,5220,5220,5220,5220,5220,7154,7154,7154,7152,7152,7152,7153,7153,7153,3670,3670,3670,3670,3670,3670,3672,3672,3672,3672,3672,3672,3668,3668,3668,3668,3668,3668,3669,3669,3669,3669,3669,3669,3671,3671,3671,3671,3671,3671,3667,3667,3667,3667,3667,3667,2934,2934,2935,2935) ) 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.012 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (1588,1588,1588,1587,1587,1587,1589,1589,1589,7176,7176,7176,7176,7176,7176,7176,7178,7178,7178,7178,7178,7178,7178,7180,7180,7180,7180,7180,7180,7180,7181,7181,7181,7181,7181,7181,7181,7177,7177,7177,7177,7177,7177,7177,7179,7179,7179,7179,7179,7179,7179,7182,7182,7182,7182,7182,7182,7182,793,793,793,793,794,794,794,794,795,795,795,795,796,796,796,796,5082,5082,5082,5080,5080,5080,5081,5081,5081,7151,7151,7151,7151,7148,7148,7148,7148,7149,7149,7149,7149,7150,7150,7150,7150,1415,1415,1415,1415,1414,1414,1414,1414,1417,1417,1417,1417,1416,1416,1416,1416,1463,1463,1463,1462,1462,1462,1461,1461,1461,3261,3261,3261,3261,3261,3261,3259,3259,3259,3259,3259,3259,3257,3257,3257,3257,3257,3257,3258,3258,3258,3258,3258,3258,3260,3260,3260,3260,3260,3260,3262,3262,3262,3262,3262,3262,1874,1874,1874,1876,1876,1876,1875,1875,1875,7165,7165,7165,7165,7165,7166,7166,7166,7166,7166,7167,7167,7167,7167,7167,7168,7168,7168,7168,7168,7169,7169,7169,7169,7169,1453,1453,1453,1453,1452,1452,1452,1452,1454,1454,1454,1454,1451,1451,1451,1451,3517,3517,3517,3517,3517,3517,3517,3517,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,3514,3514,3514,3514,3514,3514,3514,3514,3515,3515,3515,3515,3515,3515,3515,3515,3516,3516,3516,3516,3516,3516,3516,3516,3518,3518,3518,3518,3518,3518,3518,3518,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,5236,5236,5236,5236,5236,5237,5237,5237,5237,5237,5233,5233,5233,5233,5233,5234,5234,5234,5234,5234,5235,5235,5235,5235,5235,5074,5074,5074,5075,5075,5075,5076,5076,5076,6916,6916,6916,6916,6916,6916,6916,6916,6919,6919,6919,6919,6919,6919,6919,6919,6918,6918,6918,6918,6918,6918,6918,6918,6917,6917,6917,6917,6917,6917,6917,6917,6915,6915,6915,6915,6915,6915,6915,6915,6914,6914,6914,6914,6914,6914,6914,6914,6920,6920,6920,6920,6920,6920,6920,6920,6913,6913,6913,6913,6913,6913,6913,6913,8341,806,806,806,807,807,807,808,808,808,1343,2936,5238,3662,3662,3662,3662,3662,3662,3663,3663,3663,3663,3663,3663,3661,3661,3661,3661,3661,3661,3664,3664,3664,3664,3664,3664,3666,3666,3666,3666,3666,3666,3665,3665,3665,3665,3665,3665,787,787,787,787,787,787,788,788,788,788,788,788,789,789,789,789,789,789,790,790,790,790,790,790,791,791,791,791,791,791,792,792,792,792,792,792,495,495,495,497,497,497,496,496,496,1426,1426,1426,1426,1426,1426,1426,1426,1426,1426,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1423,1423,1423,1423,1423,1423,1423,1423,1423,1423,1429,1429,1429,1429,1429,1429,1429,1429,1429,1429,1422,1422,1422,1422,1422,1422,1422,1422,1422,1422,1424,1424,1424,1424,1424,1424,1424,1424,1424,1424,1427,1427,1427,1427,1427,1427,1427,1427,1427,1427,1421,1421,1421,1421,1421,1421,1421,1421,1421,1421,1420,1420,1420,1420,1420,1420,1420,1420,1420,1420,1428,1428,1428,1428,1428,1428,1428,1428,1428,1428,3252,3252,3252,3252,3252,3254,3254,3254,3254,3254,3253,3253,3253,3253,3253,3255,3255,3255,3255,3255,3256,3256,3256,3256,3256,8566,1708,1708,1708,1709,1709,1709,1710,1710,1710,5239,5239,5239,5239,5239,5240,5240,5240,5240,5240,5241,5241,5241,5241,5241,1849,1849,1849,1849,1849,1846,1846,1846,1846,1846,1848,1848,1848,1848,1848,1847,1847,1847,1847,1847,1845,1845,1845,1845,1845,1486,1486,1486,1486,1486,1486,1488,1488,1488,1488,1488,1488,1489,1489,1489,1489,1489,1489,1490,1490,1490,1490,1490,1490,1491,1491,1491,1491,1491,1491,1487,1487,1487,1487,1487,1487,1862,1862,1862,1862,1862,1862,1862,1862,1865,1865,1865,1865,1865,1865,1865,1865,1858,1858,1858,1858,1858,1858,1858,1858,1860,1860,1860,1860,1860,1860,1860,1860,1861,1861,1861,1861,1861,1861,1861,1861,1863,1863,1863,1863,1863,1863,1863,1863,1864,1864,1864,1864,1864,1864,1864,1864,1859,1859,1859,1859,1859,1859,1859,1859,3242,3242,3242,3242,3242,3242,3241,3241,3241,3241,3241,3241,3245,3245,3245,3245,3245,3245,3243,3243,3243,3243,3243,3243,3240,3240,3240,3240,3240,3240,3244,3244,3244,3244,3244,3244,7170,7170,7170,7170,7170,7170,7170,7171,7171,7171,7171,7171,7171,7171,7172,7172,7172,7172,7172,7172,7172,7173,7173,7173,7173,7173,7173,7173,7174,7174,7174,7174,7174,7174,7174,7175,7175,7175,7175,7175,7175,7175,3512,3512,3512,3512,3510,3510,3510,3510,3509,3509,3509,3509,3511,3511,3511,3511,3231,3232,8095,2939,2939,2939,2939,2939,2939,2939,2939,2939,2937,2937,2937,2937,2937,2937,2937,2937,2937,2944,2944,2944,2944,2944,2944,2944,2944,2944,2941,2941,2941,2941,2941,2941,2941,2941,2941,2938,2938,2938,2938,2938,2938,2938,2938,2938,2940,2940,2940,2940,2940,2940,2940,2940,2940,2943,2943,2943,2943,2943,2943,2943,2943,2943,2942,2942,2942,2942,2942,2942,2942,2942,2942,3246,3246,3246,3246,3246,3246,3247,3247,3247,3247,3247,3247,3248,3248,3248,3248,3248,3248,3249,3249,3249,3249,3249,3249,3250,3250,3250,3250,3250,3250,3251,3251,3251,3251,3251,3251,5095,1456,1456,1456,1456,1456,1456,1457,1457,1457,1457,1457,1457,1458,1458,1458,1458,1458,1458,1459,1459,1459,1459,1459,1459,1455,1455,1455,1455,1455,1455,1460,1460,1460,1460,1460,1460,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,5077,5077,5077,5079,5079,5079,5078,5078,5078,7155,7155,7155,7156,7156,7156,7157,7157,7157,5215,5215,5215,5215,5215,5215,5215,5221,5221,5221,5221,5221,5221,5221,5219,5219,5219,5219,5219,5219,5219,5216,5216,5216,5216,5216,5216,5216,5217,5217,5217,5217,5217,5217,5217,5218,5218,5218,5218,5218,5218,5218,5220,5220,5220,5220,5220,5220,5220,7154,7154,7154,7152,7152,7152,7153,7153,7153,3670,3670,3670,3670,3670,3670,3672,3672,3672,3672,3672,3672,3668,3668,3668,3668,3668,3668,3669,3669,3669,3669,3669,3669,3671,3671,3671,3671,3671,3671,3667,3667,3667,3667,3667,3667,2934,2934,2935,2935) | 0.002 | 1284 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (496,497,495,496,497,495,496,495,497,792,788,791,789,790,787,792,791,787,789,790,788,788,792,787,791,789,790,788,792,791,787,789,790,792,788,790,787,789,791,791,790,788,787,789,792,796,794,793,795,793,796,794,795,793,796,794,795,795,793,794,796,807,806,808,808,807,806,807,808,806,1343,1417,1415,1416,1414,1414,1417,1415,1416,1414,1417,1415,1416,1416,1415,1414,1417,1429,1423,1428,1422,1427,1421,1426,1424,1420,1425,1429,1428,1423,1422,1427,1424,1426,1420,1425,1421,1429,1423,1428,1427,1421,1424,1426,1420,1425,1422,1429,1428,1427,1422,1424,1421,1426,1420,1425,1423,1423,1422,1429,1421,1428,1427,1420,1426,1424,1425,1429,1423,1428,1422,1427,1421,1426,1420,1424,1425,1429,1423,1428,1422,1427,1421,1425,1420,1424,1426,1423,1429,1428,1422,1426,1421,1425,1420,1424,1427,1429,1423,1427,1426,1422,1425,1421,1420,1424,1428,1428,1423,1427,1426,1422,1425,1421,1420,1424,1429,1454,1452,1453,1451,1454,1451,1452,1453,1451,1454,1452,1453,1453,1451,1452,1454,1460,1456,1459,1457,1458,1455,1460,1459,1455,1457,1458,1456,1456,1460,1455,1459,1457,1458,1456,1460,1459,1455,1457,1458,1456,1460,1458,1455,1457,1459,1459,1456,1458,1457,1455,1460,1462,1461,1463,1462,1463,1461,1462,1463,1461,1491,1487,1490,1488,1489,1486,1491,1490,1486,1488,1489,1487,1487,1491,1486,1490,1488,1489,1487,1491,1490,1486,1488,1489,1491,1487,1489,1486,1488,1490,1490,1489,1487,1486,1488,1491,9777,9776,9775,1530,9774,1529,1528,1527,9773,1526,1524,1525,9778,1530,1529,9777,1528,9776,9775,1527,1526,9774,9773,1524,9778,1525,1530,9777,1529,1528,9776,9775,1527,9774,1525,1524,9773,1526,9778,1530,9777,1529,9776,1528,9775,1526,1525,9774,1524,9773,1527,9778,1530,1529,9777,9776,1527,9775,1526,1525,9774,1524,9773,9778,1528,1530,9777,1528,9776,1527,9775,1526,1525,9774,9773,1524,1529,9778,1529,1528,9777,1527,1526,9776,1525,9775,1524,9774,9773,1530,9778,1588,1587,1589,1588,1589,1587,1588,1589,1587,1709,1710,1708,1709,1710,1708,1709,1708,1710,1715,1713,1712,1714,1715,1712,1714,1713,1715,1712,1713,1714,1714,1713,1712,1715,1846,1847,1849,1848,1845,1847,1848,1845,1849,1846,1845,1849,1848,1847,1846,1849,1847,1845,1848,1846,1848,1847,1845,1849,1846,1865,1860,1864,1859,1863,1861,1858,1862,1865,1860,1864,1861,1858,1863,1862,1859,1865,1864,1859,1863,1861,1858,1862,1860,1860,1865,1859,1864,1858,1863,1861,1862,1860,1865,1864,1863,1859,1858,1861,1862,1860,1865,1864,1859,1862,1858,1861,1863,1860,1865,1863,1859,1862,1858,1861,1864,1864,1860,1863,1862,1859,1858,1861,1865,1875,1876,1874,1876,1875,1874,1875,1876,1874,2934,2935,2934,2935,2936,2939,2944,2943,2938,2940,8984,2941,2942,2937,2939,2940,2944,2937,2943,2942,8984,2941,2938,2940,2938,2943,2937,2944,2942,2941,8984,2939,2938,2944,2937,2943,8984,2942,2940,2941,2939,2944,2943,2938,2942,2937,8984,2940,2941,2939,2944,2938,2943,2937,2941,2940,8984,2942,2939,2944,2938,2942,2941,2937,8984,2940,2939,2943,2943,2942,2938,2941,2937,2940,8984,2944,2939,3231,3232,3245,3241,3244,3240,3242,3243,3245,3242,3244,3240,3243,3241,3241,3245,3240,3244,3243,3242,3241,3245,3244,3240,3242,3243,3245,3241,3243,3240,3242,3244,3244,3243,3241,3240,3242,3245,3251,3247,3250,3248,3246,3249,3251,3250,3248,3246,3249,3247,3247,3251,3246,3250,3248,3249,3251,3247,3250,3246,3248,3249,3247,3251,3249,3246,3248,3250,3250,3249,3247,3248,3246,3251,3253,3254,3256,3252,3255,3254,3252,3255,3256,3253,3252,3256,3254,3255,3253,3256,3254,3252,3255,3253,3255,3254,3252,3253,3256,3262,3258,3261,3259,3257,3260,3262,3261,3257,3259,3260,3258,3258,3262,3257,3261,3259,3260,3258,3262,3261,3257,3259,3260,3258,3262,3260,3257,3259,3261,3261,3260,3258,3257,3259,3262,3512,3510,3511,3509,3509,3512,3510,3511,3509,3512,3510,3511,3511,3510,3509,3512,3520,3515,3519,3514,3518,3516,3513,3517,3520,3515,3519,3516,3513,3518,3517,3514,3520,3519,3518,3514,3516,3513,3517,3515,3515,3520,3514,3519,3513,3518,3516,3517,3515,3520,3519,3514,3518,3513,3516,3517,3515,3520,3519,3514,3517,3513,3516,3518,3515,3520,3518,3517,3514,3513,3516,3519,3519,3518,3515,3517,3514,3513,3516,3520,3666,3662,3665,3663,3661,3664,3666,3665,3661,3663,3664,3662,3662,3666,3661,3665,3664,3663,3666,3662,3665,3661,3663,3664,3662,3666,3664,3661,3663,3665,3665,3664,3662,3663,3661,3666,3672,3668,3671,3669,3670,3667,3672,3671,3667,3669,3670,3668,3668,3672,3667,3671,3669,3670,3672,3668,3671,3667,3669,3670,3672,3668,3670,3667,3669,3671,3671,3668,3670,3669,3667,3672,5075,5076,5074,5075,5076,5074,5075,5074,5076,5078,5079,5077,5079,5078,5077,5078,5077,5079,5081,5082,5080,5081,5082,5080,5081,5082,5080,5095,5217,5221,5220,5216,5218,5215,5219,5217,5218,5221,5215,5220,5219,5216,5218,5220,5216,5221,5219,5215,5217,5216,5221,5215,5220,5218,5219,5217,5221,5216,5220,5215,5218,5217,5219,5221,5216,5219,5218,5215,5217,5220,5220,5219,5216,5218,5215,5221,5217,5234,5235,5237,5233,5236,5235,5233,5236,5237,5234,5233,5237,5235,5236,5234,5237,5233,5235,5234,5236,5236,5235,5233,5237,5234,5238,5240,5241,5243,5242,5239,5241,5242,5239,5243,5240,5239,5243,5241,5242,5240,6920,6915,6919,6914,6918,6916,6917,6913,6920,6915,6919,6916,6913,6918,6917,6914,6920,6919,6914,6918,6916,6913,6917,6915,6915,6920,6914,6919,6913,6918,6916,6917,6920,6915,6919,6918,6914,6913,6916,6917,6915,6920,6919,6914,6917,6913,6916,6918,6915,6920,6918,6914,6917,6913,6916,6919,6919,6918,6915,6917,6914,6913,6916,6920,7151,7149,7148,7150,7151,7148,7150,7149,7151,7148,7149,7150,7150,7148,7149,7151,7153,7152,7154,7154,7153,7152,7153,7154,7152,7156,7155,7157,7156,7157,7155,7156,7157,7155,7166,7167,7169,7168,7165,7167,7165,7168,7169,7166,7165,7169,7168,7167,7166,7169,7167,7165,7168,7166,7168,7167,7165,7169,7166,7171,7175,7172,9107,7173,7174,7170,7172,7174,7170,7175,9107,7173,7171,7170,7175,9107,7174,7172,7173,7171,7175,7170,7174,9107,7172,7171,7173,7175,7170,7173,9107,7172,7171,7174,7174,7170,7173,9107,7172,7175,7171,7178,7182,7181,7177,7179,7176,7180,7178,7179,7182,7181,7176,7180,7177,7179,7181,7182,7177,7176,7180,7178,7177,7182,7176,7181,7180,7179,7178,7182,7181,7177,7176,7179,7180,7178,7182,7177,7180,7179,7176,7181,7178,7181,7180,7177,7179,7176,7178,7182,8095,8341,8566,9778,1530,1529,9777,1528,9776,1527,9775,1526,9774,1524,9773,1525,9778,1530,1529,9777,1528,9776,1527,9775,1524,1526,9773,1525,9774,9778,1530,1529,9777,9776,1524,1528,9774,1527,1526,9773,1525,9775,9778,1530,1524,9777,1529,9775,1528,1527,9774,1526,9773,1525,9776,9778,1524,1530,1529,9776,1528,9775,1527,9774,1526,9773,1525,9777,1524,9777,1529,1530,9776,1528,1527,1526,9775,1525,9774,9773,9778) | 0.002 | 1310 |
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 (495,497,496,497,495,496,495,496,497,792,788,789,791,790,787,791,792,790,789,787,788,792,788,791,787,790,789,792,791,788,787,790,789,792,788,790,787,791,789,791,788,790,787,789,792,795,796,794,793,796,793,795,794,796,793,795,794,795,793,796,794,806,808,807,808,806,807,807,806,808,1343,1416,1417,1415,1414,1417,1416,1414,1415,1417,1414,1416,1415,1416,1414,1417,1415,1429,1428,1423,1422,1427,1424,1421,1426,1425,1420,1429,1423,1428,1422,1424,1427,1426,1425,1420,1421,1429,1423,1427,1428,1424,1426,1421,1425,1420,1422,1428,1429,1427,1424,1426,1425,1422,1421,1420,1423,1423,1429,1422,1428,1421,1427,1426,1420,1425,1424,1429,1428,1423,1427,1422,1426,1421,1420,1424,1425,1429,1428,1423,1427,1422,1421,1425,1420,1424,1426,1429,1428,1423,1422,1426,1421,1425,1420,1424,1427,1429,1423,1427,1426,1422,1421,1425,1420,1424,1428,1428,1423,1427,1426,1422,1425,1421,1420,1424,1429,1453,1454,1452,1451,1454,1451,1453,1452,1454,1451,1453,1452,1453,1451,1452,1454,1460,1456,1457,1459,1458,1455,1459,1460,1458,1457,1455,1456,1460,1456,1459,1455,1458,1457,1460,1459,1456,1455,1457,1458,1460,1456,1458,1455,1457,1459,1459,1456,1458,1455,1460,1457,1461,1463,1462,1461,1463,1462,1461,1462,1463,1491,1487,1488,1490,1489,1486,1490,1491,1489,1488,1486,1487,1491,1487,1490,1486,1489,1488,1491,1490,1487,1486,1488,1489,1491,1487,1489,1486,1488,1490,1490,1487,1489,1488,1486,1491,9778,9777,9776,1530,9775,1529,1528,1527,9774,1526,9773,1525,1524,1530,9778,1529,1528,9777,1527,9776,1526,9775,9774,1524,9773,1525,1530,9778,1529,9777,1528,1527,9776,9775,1525,9774,9773,1524,1526,1530,9778,1529,9777,1528,9776,1526,9775,9774,1525,9773,1524,1527,1530,9778,1529,9777,1527,9776,1526,9775,9774,1525,9773,1524,1528,1530,9778,1528,9777,1527,9776,9775,1526,9774,1525,9773,1524,1529,1529,9778,1528,1527,1526,9777,9776,1525,9775,9774,1524,9773,1530,1587,1589,1588,1589,1587,1588,1588,1587,1589,1708,1710,1709,1710,1708,1709,1708,1709,1710,1714,1715,1713,1712,1715,1714,1712,1713,1715,1712,1713,1714,1714,1712,1713,1715,1846,1847,1849,1848,1845,1845,1846,1849,1848,1847,1846,1849,1845,1848,1847,1849,1846,1847,1845,1848,1848,1846,1847,1845,1849,1865,1864,1860,1861,1859,1863,1862,1858,1865,1860,1864,1863,1861,1862,1858,1859,1864,1865,1863,1861,1862,1859,1858,1860,1865,1860,1864,1859,1863,1858,1862,1861,1865,1864,1860,1863,1859,1858,1861,1862,1865,1864,1860,1859,1862,1858,1863,1861,1865,1860,1863,1859,1862,1858,1864,1861,1864,1860,1863,1862,1859,1858,1861,1865,1874,1876,1875,1876,1874,1875,1875,1874,1876,2935,2934,2934,2935,2936,2939,2944,2940,2938,2943,2942,2941,8984,2937,2939,2940,2944,2943,2942,2937,2941,8984,2938,2938,2937,8984,2939,2944,2943,2942,2941,2940,2939,2938,2944,2943,2937,2942,8984,2941,2940,2944,2939,2943,2938,2942,2937,2940,8984,2941,2944,2939,2943,2938,2941,2937,2940,8984,2942,2944,2939,2942,2938,2937,2941,8984,2940,2943,2943,2939,2942,2941,2938,2937,8984,2940,2944,3231,3232,3245,3241,3242,3244,3243,3240,3244,3243,3245,3242,3240,3241,3245,3241,3244,3243,3240,3242,3245,3244,3241,3240,3242,3243,3245,3241,3243,3240,3244,3242,3244,3243,3241,3240,3242,3245,3251,3247,3248,3250,3249,3246,3250,3251,3249,3248,3246,3247,3251,3247,3250,3246,3249,3248,3251,3250,3247,3246,3248,3249,3251,3247,3249,3246,3250,3248,3250,3247,3249,3246,3251,3248,3253,3254,3256,3255,3252,3252,3253,3256,3255,3254,3253,3256,3252,3255,3254,3256,3253,3254,3252,3255,3255,3253,3254,3252,3256,3262,3258,3259,3261,3260,3257,3261,3262,3260,3259,3257,3258,3262,3258,3261,3257,3260,3259,3262,3261,3258,3257,3260,3259,3262,3258,3260,3257,3259,3261,3261,3260,3258,3257,3262,3259,3511,3512,3510,3509,3512,3511,3509,3510,3512,3509,3510,3511,3511,3509,3510,3512,3520,3519,3515,3516,3514,3518,3517,3513,3520,3515,3519,3518,3516,3517,3513,3514,3519,3520,3518,3516,3517,3514,3513,3515,3520,3515,3514,3519,3518,3513,3517,3516,3520,3519,3515,3518,3514,3513,3517,3516,3520,3519,3515,3514,3517,3513,3516,3518,3520,3515,3518,3514,3517,3513,3519,3516,3519,3515,3518,3517,3514,3513,3516,3520,3666,3662,3663,3665,3664,3661,3665,3666,3664,3663,3661,3662,3666,3662,3665,3661,3664,3663,3666,3665,3662,3661,3664,3663,3666,3662,3664,3661,3665,3663,3665,3664,3662,3661,3663,3666,3672,3668,3669,3671,3670,3667,3671,3672,3670,3669,3667,3668,3672,3668,3671,3667,3670,3669,3672,3671,3668,3667,3670,3669,3672,3668,3670,3667,3669,3671,3671,3670,3668,3667,3669,3672,5074,5076,5075,5076,5074,5075,5074,5075,5076,5077,5079,5078,5079,5077,5078,5077,5078,5079,5080,5082,5081,5082,5080,5081,5080,5081,5082,5095,5217,5218,5221,5216,5220,5219,5215,5217,5218,5221,5220,5219,5215,5216,5216,5215,5221,5217,5220,5219,5218,5217,5221,5216,5220,5215,5219,5218,5221,5217,5220,5216,5218,5215,5219,5221,5217,5219,5216,5215,5218,5220,5220,5217,5219,5218,5216,5215,5221,5234,5235,5237,5236,5233,5233,5234,5237,5236,5235,5234,5237,5233,5236,5235,5237,5234,5235,5233,5236,5236,5234,5235,5233,5237,5238,5240,5241,5243,5242,5239,5239,5240,5243,5242,5241,5240,5243,5239,5242,5241,5243,5240,5241,5239,5242,5242,5240,5241,5239,5243,6920,6919,6915,6916,6914,6918,6917,6913,6920,6915,6919,6918,6916,6917,6913,6914,6919,6920,6918,6916,6917,6914,6913,6915,6920,6915,6914,6919,6918,6913,6917,6916,6920,6919,6915,6918,6914,6913,6917,6916,6920,6919,6915,6917,6914,6913,6916,6918,6920,6915,6918,6914,6917,6913,6916,6919,6919,6915,6918,6917,6914,6913,6920,6916,7150,7151,7149,7148,7151,7150,7148,7149,7151,7148,7149,7150,7150,7148,7149,7151,7152,7154,7153,7154,7152,7153,7153,7152,7154,7155,7157,7156,7157,7155,7156,7156,7155,7157,7166,7167,7169,7168,7165,7165,7166,7169,7168,7167,7166,7169,7165,7168,7167,7169,7166,7167,7165,7168,7168,7166,7167,7165,7169,7171,7172,7175,7174,7173,9107,7170,7170,9107,7171,7175,7174,7173,7172,7171,7175,7170,7174,9107,7173,7172,7175,7171,7174,7170,9107,7172,7173,7175,7171,7173,7170,7172,9107,7174,7174,7171,7173,7170,7172,9107,7175,7178,7179,7182,7177,7181,7180,7176,7178,7179,7182,7181,7180,7176,7177,7177,7176,7182,7178,7181,7180,7179,7178,7182,7177,7181,7176,7180,7179,7182,7178,7181,7177,7179,7176,7180,7182,7178,7180,7177,7176,7179,7181,7181,7178,7180,7179,7177,7176,7182,8095,8341,8566,2939,2944,2943,2938,2937,2940,2942,2941,8984,7171,7175,7170,7172,7174,7173,9107,9778,1530,1529,9777,1528,9776,9775,1527,9774,1526,1524,1525,9773,9778,1530,1529,9777,9776,1528,1524,9775,1527,1526,1525,9773,9774,9778,1530,9777,1529,1524,9776,1528,1527,1526,9774,1525,9773,9775,9778,1530,1524,9777,1529,1528,1527,9775,1526,9774,1525,9773,9776,9778,1524,1530,1529,1528,9776,1527,9775,1526,9774,1525,9773,9777,9777,9776,9775,9774,9773,1530,9778,1529,1528,1527,1526,1525,1524)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 5 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 6 | 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` = '6'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.002 | 52 |
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 (1588,1588,1588,1587,1587,1587,1589,1589,1589,7176,7176,7176,7176,7176,7176,7176,7178,7178,7178,7178,7178,7178,7178,7180,7180,7180,7180,7180,7180,7180,7181,7181,7181,7181,7181,7181,7181,7177,7177,7177,7177,7177,7177,7177,7179,7179,7179,7179,7179,7179,7179,7182,7182,7182,7182,7182,7182,7182,793,793,793,793,794,794,794,794,795,795,795,795,796,796,796,796,5082,5082,5082,5080,5080,5080,5081,5081,5081,7151,7151,7151,7151,7148,7148,7148,7148,7149,7149,7149,7149,7150,7150,7150,7150,1415,1415,1415,1415,1414,1414,1414,1414,1417,1417,1417,1417,1416,1416,1416,1416,1463,1463,1463,1462,1462,1462,1461,1461,1461,3261,3261,3261,3261,3261,3261,3259,3259,3259,3259,3259,3259,3257,3257,3257,3257,3257,3257,3258,3258,3258,3258,3258,3258,3260,3260,3260,3260,3260,3260,3262,3262,3262,3262,3262,3262,1874,1874,1874,1876,1876,1876,1875,1875,1875,7165,7165,7165,7165,7165,7166,7166,7166,7166,7166,7167,7167,7167,7167,7167,7168,7168,7168,7168,7168,7169,7169,7169,7169,7169,1453,1453,1453,1453,1452,1452,1452,1452,1454,1454,1454,1454,1451,1451,1451,1451,3517,3517,3517,3517,3517,3517,3517,3517,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,3514,3514,3514,3514,3514,3514,3514,3514,3515,3515,3515,3515,3515,3515,3515,3515,3516,3516,3516,3516,3516,3516,3516,3516,3518,3518,3518,3518,3518,3518,3518,3518,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,5236,5236,5236,5236,5236,5237,5237,5237,5237,5237,5233,5233,5233,5233,5233,5234,5234,5234,5234,5234,5235,5235,5235,5235,5235,5074,5074,5074,5075,5075,5075,5076,5076,5076,6916,6916,6916,6916,6916,6916,6916,6916,6919,6919,6919,6919,6919,6919,6919,6919,6918,6918,6918,6918,6918,6918,6918,6918,6917,6917,6917,6917,6917,6917,6917,6917,6915,6915,6915,6915,6915,6915,6915,6915,6914,6914,6914,6914,6914,6914,6914,6914,6920,6920,6920,6920,6920,6920,6920,6920,6913,6913,6913,6913,6913,6913,6913,6913,8341,806,806,806,807,807,807,808,808,808,1343,2936,5238,3662,3662,3662,3662,3662,3662,3663,3663,3663,3663,3663,3663,3661,3661,3661,3661,3661,3661,3664,3664,3664,3664,3664,3664,3666,3666,3666,3666,3666,3666,3665,3665,3665,3665,3665,3665,787,787,787,787,787,787,788,788,788,788,788,788,789,789,789,789,789,789,790,790,790,790,790,790,791,791,791,791,791,791,792,792,792,792,792,792,495,495,495,497,497,497,496,496,496,1426,1426,1426,1426,1426,1426,1426,1426,1426,1426,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1423,1423,1423,1423,1423,1423,1423,1423,1423,1423,1429,1429,1429,1429,1429,1429,1429,1429,1429,1429,1422,1422,1422,1422,1422,1422,1422,1422,1422,1422,1424,1424,1424,1424,1424,1424,1424,1424,1424,1424,1427,1427,1427,1427,1427,1427,1427,1427,1427,1427,1421,1421,1421,1421,1421,1421,1421,1421,1421,1421,1420,1420,1420,1420,1420,1420,1420,1420,1420,1420,1428,1428,1428,1428,1428,1428,1428,1428,1428,1428,3252,3252,3252,3252,3252,3254,3254,3254,3254,3254,3253,3253,3253,3253,3253,3255,3255,3255,3255,3255,3256,3256,3256,3256,3256,8566,1708,1708,1708,1709,1709,1709,1710,1710,1710,5239,5239,5239,5239,5239,5240,5240,5240,5240,5240,5241,5241,5241,5241,5241,1849,1849,1849,1849,1849,1846,1846,1846,1846,1846,1848,1848,1848,1848,1848,1847,1847,1847,1847,1847,1845,1845,1845,1845,1845,1486,1486,1486,1486,1486,1486,1488,1488,1488,1488,1488,1488,1489,1489,1489,1489,1489,1489,1490,1490,1490,1490,1490,1490,1491,1491,1491,1491,1491,1491,1487,1487,1487,1487,1487,1487,1862,1862,1862,1862,1862,1862,1862,1862,1865,1865,1865,1865,1865,1865,1865,1865,1858,1858,1858,1858,1858,1858,1858,1858,1860,1860,1860,1860,1860,1860,1860,1860,1861,1861,1861,1861,1861,1861,1861,1861,1863,1863,1863,1863,1863,1863,1863,1863,1864,1864,1864,1864,1864,1864,1864,1864,1859,1859,1859,1859,1859,1859,1859,1859,3242,3242,3242,3242,3242,3242,3241,3241,3241,3241,3241,3241,3245,3245,3245,3245,3245,3245,3243,3243,3243,3243,3243,3243,3240,3240,3240,3240,3240,3240,3244,3244,3244,3244,3244,3244,7170,7170,7170,7170,7170,7170,7170,7171,7171,7171,7171,7171,7171,7171,7172,7172,7172,7172,7172,7172,7172,7173,7173,7173,7173,7173,7173,7173,7174,7174,7174,7174,7174,7174,7174,7175,7175,7175,7175,7175,7175,7175,3512,3512,3512,3512,3510,3510,3510,3510,3509,3509,3509,3509,3511,3511,3511,3511,3231,3232,8095,2939,2939,2939,2939,2939,2939,2939,2939,2939,2937,2937,2937,2937,2937,2937,2937,2937,2937,2944,2944,2944,2944,2944,2944,2944,2944,2944,2941,2941,2941,2941,2941,2941,2941,2941,2941,2938,2938,2938,2938,2938,2938,2938,2938,2938,2940,2940,2940,2940,2940,2940,2940,2940,2940,2943,2943,2943,2943,2943,2943,2943,2943,2943,2942,2942,2942,2942,2942,2942,2942,2942,2942,3246,3246,3246,3246,3246,3246,3247,3247,3247,3247,3247,3247,3248,3248,3248,3248,3248,3248,3249,3249,3249,3249,3249,3249,3250,3250,3250,3250,3250,3250,3251,3251,3251,3251,3251,3251,5095,1456,1456,1456,1456,1456,1456,1457,1457,1457,1457,1457,1457,1458,1458,1458,1458,1458,1458,1459,1459,1459,1459,1459,1459,1455,1455,1455,1455,1455,1455,1460,1460,1460,1460,1460,1460,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,5077,5077,5077,5079,5079,5079,5078,5078,5078,7155,7155,7155,7156,7156,7156,7157,7157,7157,5215,5215,5215,5215,5215,5215,5215,5221,5221,5221,5221,5221,5221,5221,5219,5219,5219,5219,5219,5219,5219,5216,5216,5216,5216,5216,5216,5216,5217,5217,5217,5217,5217,5217,5217,5218,5218,5218,5218,5218,5218,5218,5220,5220,5220,5220,5220,5220,5220,7154,7154,7154,7152,7152,7152,7153,7153,7153,3670,3670,3670,3670,3670,3670,3672,3672,3672,3672,3672,3672,3668,3668,3668,3668,3668,3668,3669,3669,3669,3669,3669,3669,3671,3671,3671,3671,3671,3671,3667,3667,3667,3667,3667,3667,2934,2934,2935,2935) | 0.001 | 1 |
select MIN(NULLIF(`do_99`*(1)*1, 0)) AS min99, MIN(NULLIF(`od_50`*(1)*1, 0)) AS min50, MIN(NULLIF(`od_100`*(1)*1, 0)) AS min100, MIN(NULLIF(`od_250`*(1)*1, 0)) AS min250, MIN(NULLIF(`od_500`*(1)*1, 0)) AS min500, MIN(NULLIF(`od_1000`*(1)*1, 0)) AS min1000 from shop_products_prices where product_id in (1588,1588,1588,1587,1587,1587,1589,1589,1589,7176,7176,7176,7176,7176,7176,7176,7178,7178,7178,7178,7178,7178,7178,7180,7180,7180,7180,7180,7180,7180,7181,7181,7181,7181,7181,7181,7181,7177,7177,7177,7177,7177,7177,7177,7179,7179,7179,7179,7179,7179,7179,7182,7182,7182,7182,7182,7182,7182,793,793,793,793,794,794,794,794,795,795,795,795,796,796,796,796,5082,5082,5082,5080,5080,5080,5081,5081,5081,7151,7151,7151,7151,7148,7148,7148,7148,7149,7149,7149,7149,7150,7150,7150,7150,1415,1415,1415,1415,1414,1414,1414,1414,1417,1417,1417,1417,1416,1416,1416,1416,1463,1463,1463,1462,1462,1462,1461,1461,1461,3261,3261,3261,3261,3261,3261,3259,3259,3259,3259,3259,3259,3257,3257,3257,3257,3257,3257,3258,3258,3258,3258,3258,3258,3260,3260,3260,3260,3260,3260,3262,3262,3262,3262,3262,3262,1874,1874,1874,1876,1876,1876,1875,1875,1875,7165,7165,7165,7165,7165,7166,7166,7166,7166,7166,7167,7167,7167,7167,7167,7168,7168,7168,7168,7168,7169,7169,7169,7169,7169,1453,1453,1453,1453,1452,1452,1452,1452,1454,1454,1454,1454,1451,1451,1451,1451,3517,3517,3517,3517,3517,3517,3517,3517,3519,3519,3519,3519,3519,3519,3519,3519,3520,3520,3520,3520,3520,3520,3520,3520,3513,3513,3513,3513,3513,3513,3513,3513,3514,3514,3514,3514,3514,3514,3514,3514,3515,3515,3515,3515,3515,3515,3515,3515,3516,3516,3516,3516,3516,3516,3516,3516,3518,3518,3518,3518,3518,3518,3518,3518,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,5236,5236,5236,5236,5236,5237,5237,5237,5237,5237,5233,5233,5233,5233,5233,5234,5234,5234,5234,5234,5235,5235,5235,5235,5235,5074,5074,5074,5075,5075,5075,5076,5076,5076,6916,6916,6916,6916,6916,6916,6916,6916,6919,6919,6919,6919,6919,6919,6919,6919,6918,6918,6918,6918,6918,6918,6918,6918,6917,6917,6917,6917,6917,6917,6917,6917,6915,6915,6915,6915,6915,6915,6915,6915,6914,6914,6914,6914,6914,6914,6914,6914,6920,6920,6920,6920,6920,6920,6920,6920,6913,6913,6913,6913,6913,6913,6913,6913,8341,806,806,806,807,807,807,808,808,808,1343,2936,5238,3662,3662,3662,3662,3662,3662,3663,3663,3663,3663,3663,3663,3661,3661,3661,3661,3661,3661,3664,3664,3664,3664,3664,3664,3666,3666,3666,3666,3666,3666,3665,3665,3665,3665,3665,3665,787,787,787,787,787,787,788,788,788,788,788,788,789,789,789,789,789,789,790,790,790,790,790,790,791,791,791,791,791,791,792,792,792,792,792,792,495,495,495,497,497,497,496,496,496,1426,1426,1426,1426,1426,1426,1426,1426,1426,1426,1425,1425,1425,1425,1425,1425,1425,1425,1425,1425,1423,1423,1423,1423,1423,1423,1423,1423,1423,1423,1429,1429,1429,1429,1429,1429,1429,1429,1429,1429,1422,1422,1422,1422,1422,1422,1422,1422,1422,1422,1424,1424,1424,1424,1424,1424,1424,1424,1424,1424,1427,1427,1427,1427,1427,1427,1427,1427,1427,1427,1421,1421,1421,1421,1421,1421,1421,1421,1421,1421,1420,1420,1420,1420,1420,1420,1420,1420,1420,1420,1428,1428,1428,1428,1428,1428,1428,1428,1428,1428,3252,3252,3252,3252,3252,3254,3254,3254,3254,3254,3253,3253,3253,3253,3253,3255,3255,3255,3255,3255,3256,3256,3256,3256,3256,8566,1708,1708,1708,1709,1709,1709,1710,1710,1710,5239,5239,5239,5239,5239,5240,5240,5240,5240,5240,5241,5241,5241,5241,5241,1849,1849,1849,1849,1849,1846,1846,1846,1846,1846,1848,1848,1848,1848,1848,1847,1847,1847,1847,1847,1845,1845,1845,1845,1845,1486,1486,1486,1486,1486,1486,1488,1488,1488,1488,1488,1488,1489,1489,1489,1489,1489,1489,1490,1490,1490,1490,1490,1490,1491,1491,1491,1491,1491,1491,1487,1487,1487,1487,1487,1487,1862,1862,1862,1862,1862,1862,1862,1862,1865,1865,1865,1865,1865,1865,1865,1865,1858,1858,1858,1858,1858,1858,1858,1858,1860,1860,1860,1860,1860,1860,1860,1860,1861,1861,1861,1861,1861,1861,1861,1861,1863,1863,1863,1863,1863,1863,1863,1863,1864,1864,1864,1864,1864,1864,1864,1864,1859,1859,1859,1859,1859,1859,1859,1859,3242,3242,3242,3242,3242,3242,3241,3241,3241,3241,3241,3241,3245,3245,3245,3245,3245,3245,3243,3243,3243,3243,3243,3243,3240,3240,3240,3240,3240,3240,3244,3244,3244,3244,3244,3244,7170,7170,7170,7170,7170,7170,7170,7171,7171,7171,7171,7171,7171,7171,7172,7172,7172,7172,7172,7172,7172,7173,7173,7173,7173,7173,7173,7173,7174,7174,7174,7174,7174,7174,7174,7175,7175,7175,7175,7175,7175,7175,3512,3512,3512,3512,3510,3510,3510,3510,3509,3509,3509,3509,3511,3511,3511,3511,3231,3232,8095,2939,2939,2939,2939,2939,2939,2939,2939,2939,2937,2937,2937,2937,2937,2937,2937,2937,2937,2944,2944,2944,2944,2944,2944,2944,2944,2944,2941,2941,2941,2941,2941,2941,2941,2941,2941,2938,2938,2938,2938,2938,2938,2938,2938,2938,2940,2940,2940,2940,2940,2940,2940,2940,2940,2943,2943,2943,2943,2943,2943,2943,2943,2943,2942,2942,2942,2942,2942,2942,2942,2942,2942,3246,3246,3246,3246,3246,3246,3247,3247,3247,3247,3247,3247,3248,3248,3248,3248,3248,3248,3249,3249,3249,3249,3249,3249,3250,3250,3250,3250,3250,3250,3251,3251,3251,3251,3251,3251,5095,1456,1456,1456,1456,1456,1456,1457,1457,1457,1457,1457,1457,1458,1458,1458,1458,1458,1458,1459,1459,1459,1459,1459,1459,1455,1455,1455,1455,1455,1455,1460,1460,1460,1460,1460,1460,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9777,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9774,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9773,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9776,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9775,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,9778,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1524,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1526,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1527,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1528,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1525,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1529,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,1530,5077,5077,5077,5079,5079,5079,5078,5078,5078,7155,7155,7155,7156,7156,7156,7157,7157,7157,5215,5215,5215,5215,5215,5215,5215,5221,5221,5221,5221,5221,5221,5221,5219,5219,5219,5219,5219,5219,5219,5216,5216,5216,5216,5216,5216,5216,5217,5217,5217,5217,5217,5217,5217,5218,5218,5218,5218,5218,5218,5218,5220,5220,5220,5220,5220,5220,5220,7154,7154,7154,7152,7152,7152,7153,7153,7153,3670,3670,3670,3670,3670,3670,3672,3672,3672,3672,3672,3672,3668,3668,3668,3668,3668,3668,3669,3669,3669,3669,3669,3669,3671,3671,3671,3671,3671,3671,3667,3667,3667,3667,3667,3667,2934,2934,2935,2935) | 0.001 | 1 |
SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`shop_configuration`) | 0.000 | 8 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-text'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_1'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_2'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_domain'
LIMIT 0, 1 | 0.000 | 1 |
SELECT `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` = '1486' | 0.000 | 6 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '1491'
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` = '1874' | 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` = '1875'
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` = '2937' | 0.000 | 9 |
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` = '2939'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 8 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '3257' | 0.000 | 6 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '3262'
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` = '1858' | 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` = '1865'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 8 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '3513' | 0.000 | 8 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '3520'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 8 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '3509' | 0.000 | 4 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '3512'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 4 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '1708' | 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` = '1709'
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` = '5238' | 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` = '5238'
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` = '7155' | 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` = '7156'
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` = '3240' | 0.000 | 6 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '3245'
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` = '3246' | 0.000 | 6 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '3251'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 6 |
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.093 | 6265 |