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.005 | 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.001 | 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` = '38' | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '37' | 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` = 38 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (37,4)
ORDER BY `level` ASC | 0.000 | 2 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '38'
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 (38) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.101 | 1173 |
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 (9798,9798,9798,9798,9798,9579,9579,9579,1383,1383,1383,9713,9713,9702,9702,9702,5428,5428,5428,1780,1780,1781,1781,1718,1718,1718,1719,1719,1719,1720,1720,1720,9744,9744,9744,9743,9743,9743,9742,9742,9742,8161,7916,7916,7915,7915,6339,6339,6339,6339,6339,6339,6338,6338,6338,6338,6338,6338,6340,6340,6340,6340,6340,6340,6337,6337,6337,6337,6337,6337,6341,6341,6341,6341,6341,6341,6336,6336,6336,6336,6336,6336,5418,1784,1784,1784,1784,1784,1785,1785,1785,1785,1785,1788,1788,1788,1788,1788,1786,1786,1786,1786,1786,1787,1787,1787,1787,1787,8848,8620,9799,9799,9799,9799,9799,9800,9800,9800,9800,9800,9796,9796,9796,9796,9796,9797,9797,9797,9797,9797,6342,1638,1638,1638,1638,1638,1638,1638,1637,1637,1637,1637,1637,1637,1637,1639,1639,1639,1639,1639,1639,1639,1640,1640,1640,1640,1640,1640,1640,1641,1641,1641,1641,1641,1641,1641,1642,1642,1642,1642,1642,1642,1642,1643,1643,1643,1643,1643,1643,1643,8575,8574,6525,6525,6525,6525,6525,6525,6525,6525,6523,6523,6523,6523,6523,6523,6523,6523,6529,6529,6529,6529,6529,6529,6529,6529,6524,6524,6524,6524,6524,6524,6524,6524,6526,6526,6526,6526,6526,6526,6526,6526,6527,6527,6527,6527,6527,6527,6527,6527,6528,6528,6528,6528,6528,6528,6528,6528,6530,6530,6530,6530,6530,6530,6530,6530,1816,1816,1816,1816,1816,1816,1816,1818,1818,1818,1818,1818,1818,1818,1817,1817,1817,1817,1817,1817,1817,1819,1819,1819,1819,1819,1819,1819,1814,1814,1814,1814,1814,1814,1814,1815,1815,1815,1815,1815,1815,1815,1820,1820,1820,1820,1820,1820,1820,1329,8681,9788,9788,9788,9788,9788,9788,9788,9790,9790,9790,9790,9790,9790,9790,9789,9789,9789,9789,9789,9789,9789,9786,9786,9786,9786,9786,9786,9786,9792,9792,9792,9792,9792,9792,9792,9791,9791,9791,9791,9791,9791,9791,9787,9787,9787,9787,9787,9787,9787,5444,5444,5444,5444,5444,5445,5445,5445,5445,5445,5443,5443,5443,5443,5443,5441,5441,5441,5441,5441,5442,5442,5442,5442,5442,1739,1739,1739,1739,1739,1740,1740,1740,1740,1740,1741,1741,1741,1741,1741,1743,1743,1743,1743,1743,1742,1742,1742,1742,1742,1365,1365,1365,1365,1365,1365,1366,1366,1366,1366,1366,1366,1367,1367,1367,1367,1367,1367,1369,1369,1369,1369,1369,1369,1368,1368,1368,1368,1368,1368,1370,1370,1370,1370,1370,1370,9126,8706,1670,1670,1670,1670,1672,1672,1672,1672,1673,1673,1673,1673,1671,1671,1671,1671,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,9580,9782,9782,9782,9782,9782,9783,9783,9783,9783,9783,9784,9784,9784,9784,9784,9785,9785,9785,9785,9785,9781,9781,9781,9781,9781,1344,1344,1344,1345,1345,1345,1346,1346,1346,9578,9578,9578,9577,9577,9577,1782,8568,5425,5431,5431,5431,5431,5431,5431,5431,5434,5434,5434,5434,5434,5434,5434,5433,5433,5433,5433,5433,5433,5433,5429,5429,5429,5429,5429,5429,5429,5432,5432,5432,5432,5432,5432,5432,5435,5435,5435,5435,5435,5435,5435,5430,5430,5430,5430,5430,5430,5430,1372,5100,1725,1725,1725,1724,1724,1724,1726,1726,1726,5106,5106,5106,5104,5104,5104,5105,5105,5105,1770,1770,1770,1770,1770,1770,1770,1770,1767,1767,1767,1767,1767,1767,1767,1767,1768,1768,1768,1768,1768,1768,1768,1768,1769,1769,1769,1769,1769,1769,1769,1769,1766,1766,1766,1766,1766,1766,1766,1766,1772,1772,1772,1772,1772,1772,1772,1772,1771,1771,1771,1771,1771,1771,1771,1771,1773,1773,1773,1773,1773,1773,1773,1773,1381,1381,1381,1382,1382,1382,6440,9712,1723,1723,1723,1721,1721,1721,1722,1722,1722,24,24,24,24,24,24,24,24,24,1867,1867,1867,1867,1867,1867,1867,1867,1867,1873,1873,1873,1873,1873,1873,1873,1873,1873,1866,1866,1866,1866,1866,1866,1866,1866,1866,1868,1868,1868,1868,1868,1868,1868,1868,1868,1871,1871,1871,1871,1871,1871,1871,1871,1871,1869,1869,1869,1869,1869,1869,1869,1869,1869,1870,1870,1870,1870,1870,1870,1870,1870,1870,1872,1872,1872,1872,1872,1872,1872,1872,1872,5436,9714,9714,9767,9745,7959,7959,7959,7959,7959,7961,7961,7961,7961,7961,7958,7958,7958,7958,7958,7960,7960,7960,7960,7960,7962,7962,7962,7962,7962,5459,1650,1650,1650,1650,1650,1650,1650,1644,1644,1644,1644,1644,1644,1644,1645,1645,1645,1645,1645,1645,1645,1647,1647,1647,1647,1647,1647,1647,1648,1648,1648,1648,1648,1648,1648,1649,1649,1649,1649,1649,1649,1649,1646,1646,1646,1646,1646,1646,1646,5438,5438,5438,5439,5439,5439,5440,5440,5440,5446,5446,5446,5446,5446,5449,5449,5449,5449,5449,5448,5448,5448,5448,5448,5447,5447,5447,5447,5447,5450,5450,5450,5450,5450,6344,8153,8570,8567,5455,5455,5455,5455,5455,5455,5453,5453,5453,5453,5453,5453,5456,5456,5456,5456,5456,5456,5458,5458,5458,5458,5458,5458,5457,5457,5457,5457,5457,5457,5454,5454,5454,5454,5454,5454,9772,9772,9772,9772,9771,9771,9771,9771,9770,9770,9770,9770,9769,9769,9769,9769,8115,8609,7914,6574,8171,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,6910,6910,6910,6910,6909,6909,6909,6909,6911,6911,6911,6911,6912,6912,6912,6912,5421,5421,5421,5423,5423,5423,5422,5422,5422,9700,9700,9700,9701,9701,9701,5424,1821,8114,8602,1793,1793,1793,1793,1793,1793,1793,1789,1789,1789,1789,1789,1789,1789,1795,1795,1795,1795,1795,1795,1795,1791,1791,1791,1791,1791,1791,1791,1794,1794,1794,1794,1794,1794,1794,1790,1790,1790,1790,1790,1790,1790,1792,1792,1792,1792,1792,1792,1792,8572,5417,8565,9768,1652,1652,1652,1652,1652,1652,1653,1653,1653,1653,1653,1653,1654,1654,1654,1654,1654,1654,1656,1656,1656,1656,1656,1656,1651,1651,1651,1651,1651,1651,1655,1655,1655,1655,1655,1655,5426,5426,5426,5427,5427,5427,5420,5420,5419,5419,1844,5437) ) as s GROUP BY id_product_ps ) as ss | 0.075 | 83 |
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 (9798,9798,9798,9798,9798,9579,9579,9579,1383,1383,1383,9713,9713,9702,9702,9702,5428,5428,5428,1780,1780,1781,1781,1718,1718,1718,1719,1719,1719,1720,1720,1720,9744,9744,9744,9743,9743,9743,9742,9742,9742,8161,7916,7916,7915,7915,6339,6339,6339,6339,6339,6339,6338,6338,6338,6338,6338,6338,6340,6340,6340,6340,6340,6340,6337,6337,6337,6337,6337,6337,6341,6341,6341,6341,6341,6341,6336,6336,6336,6336,6336,6336,5418,1784,1784,1784,1784,1784,1785,1785,1785,1785,1785,1788,1788,1788,1788,1788,1786,1786,1786,1786,1786,1787,1787,1787,1787,1787,8848,8620,9799,9799,9799,9799,9799,9800,9800,9800,9800,9800,9796,9796,9796,9796,9796,9797,9797,9797,9797,9797,6342,1638,1638,1638,1638,1638,1638,1638,1637,1637,1637,1637,1637,1637,1637,1639,1639,1639,1639,1639,1639,1639,1640,1640,1640,1640,1640,1640,1640,1641,1641,1641,1641,1641,1641,1641,1642,1642,1642,1642,1642,1642,1642,1643,1643,1643,1643,1643,1643,1643,8575,8574,6525,6525,6525,6525,6525,6525,6525,6525,6523,6523,6523,6523,6523,6523,6523,6523,6529,6529,6529,6529,6529,6529,6529,6529,6524,6524,6524,6524,6524,6524,6524,6524,6526,6526,6526,6526,6526,6526,6526,6526,6527,6527,6527,6527,6527,6527,6527,6527,6528,6528,6528,6528,6528,6528,6528,6528,6530,6530,6530,6530,6530,6530,6530,6530,1816,1816,1816,1816,1816,1816,1816,1818,1818,1818,1818,1818,1818,1818,1817,1817,1817,1817,1817,1817,1817,1819,1819,1819,1819,1819,1819,1819,1814,1814,1814,1814,1814,1814,1814,1815,1815,1815,1815,1815,1815,1815,1820,1820,1820,1820,1820,1820,1820,1329,8681,9788,9788,9788,9788,9788,9788,9788,9790,9790,9790,9790,9790,9790,9790,9789,9789,9789,9789,9789,9789,9789,9786,9786,9786,9786,9786,9786,9786,9792,9792,9792,9792,9792,9792,9792,9791,9791,9791,9791,9791,9791,9791,9787,9787,9787,9787,9787,9787,9787,5444,5444,5444,5444,5444,5445,5445,5445,5445,5445,5443,5443,5443,5443,5443,5441,5441,5441,5441,5441,5442,5442,5442,5442,5442,1739,1739,1739,1739,1739,1740,1740,1740,1740,1740,1741,1741,1741,1741,1741,1743,1743,1743,1743,1743,1742,1742,1742,1742,1742,1365,1365,1365,1365,1365,1365,1366,1366,1366,1366,1366,1366,1367,1367,1367,1367,1367,1367,1369,1369,1369,1369,1369,1369,1368,1368,1368,1368,1368,1368,1370,1370,1370,1370,1370,1370,9126,8706,1670,1670,1670,1670,1672,1672,1672,1672,1673,1673,1673,1673,1671,1671,1671,1671,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,9580,9782,9782,9782,9782,9782,9783,9783,9783,9783,9783,9784,9784,9784,9784,9784,9785,9785,9785,9785,9785,9781,9781,9781,9781,9781,1344,1344,1344,1345,1345,1345,1346,1346,1346,9578,9578,9578,9577,9577,9577,1782,8568,5425,5431,5431,5431,5431,5431,5431,5431,5434,5434,5434,5434,5434,5434,5434,5433,5433,5433,5433,5433,5433,5433,5429,5429,5429,5429,5429,5429,5429,5432,5432,5432,5432,5432,5432,5432,5435,5435,5435,5435,5435,5435,5435,5430,5430,5430,5430,5430,5430,5430,1372,5100,1725,1725,1725,1724,1724,1724,1726,1726,1726,5106,5106,5106,5104,5104,5104,5105,5105,5105,1770,1770,1770,1770,1770,1770,1770,1770,1767,1767,1767,1767,1767,1767,1767,1767,1768,1768,1768,1768,1768,1768,1768,1768,1769,1769,1769,1769,1769,1769,1769,1769,1766,1766,1766,1766,1766,1766,1766,1766,1772,1772,1772,1772,1772,1772,1772,1772,1771,1771,1771,1771,1771,1771,1771,1771,1773,1773,1773,1773,1773,1773,1773,1773,1381,1381,1381,1382,1382,1382,6440,9712,1723,1723,1723,1721,1721,1721,1722,1722,1722,24,24,24,24,24,24,24,24,24,1867,1867,1867,1867,1867,1867,1867,1867,1867,1873,1873,1873,1873,1873,1873,1873,1873,1873,1866,1866,1866,1866,1866,1866,1866,1866,1866,1868,1868,1868,1868,1868,1868,1868,1868,1868,1871,1871,1871,1871,1871,1871,1871,1871,1871,1869,1869,1869,1869,1869,1869,1869,1869,1869,1870,1870,1870,1870,1870,1870,1870,1870,1870,1872,1872,1872,1872,1872,1872,1872,1872,1872,5436,9714,9714,9767,9745,7959,7959,7959,7959,7959,7961,7961,7961,7961,7961,7958,7958,7958,7958,7958,7960,7960,7960,7960,7960,7962,7962,7962,7962,7962,5459,1650,1650,1650,1650,1650,1650,1650,1644,1644,1644,1644,1644,1644,1644,1645,1645,1645,1645,1645,1645,1645,1647,1647,1647,1647,1647,1647,1647,1648,1648,1648,1648,1648,1648,1648,1649,1649,1649,1649,1649,1649,1649,1646,1646,1646,1646,1646,1646,1646,5438,5438,5438,5439,5439,5439,5440,5440,5440,5446,5446,5446,5446,5446,5449,5449,5449,5449,5449,5448,5448,5448,5448,5448,5447,5447,5447,5447,5447,5450,5450,5450,5450,5450,6344,8153,8570,8567,5455,5455,5455,5455,5455,5455,5453,5453,5453,5453,5453,5453,5456,5456,5456,5456,5456,5456,5458,5458,5458,5458,5458,5458,5457,5457,5457,5457,5457,5457,5454,5454,5454,5454,5454,5454,9772,9772,9772,9772,9771,9771,9771,9771,9770,9770,9770,9770,9769,9769,9769,9769,8115,8609,7914,6574,8171,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,6910,6910,6910,6910,6909,6909,6909,6909,6911,6911,6911,6911,6912,6912,6912,6912,5421,5421,5421,5423,5423,5423,5422,5422,5422,9700,9700,9700,9701,9701,9701,5424,1821,8114,8602,1793,1793,1793,1793,1793,1793,1793,1789,1789,1789,1789,1789,1789,1789,1795,1795,1795,1795,1795,1795,1795,1791,1791,1791,1791,1791,1791,1791,1794,1794,1794,1794,1794,1794,1794,1790,1790,1790,1790,1790,1790,1790,1792,1792,1792,1792,1792,1792,1792,8572,5417,8565,9768,1652,1652,1652,1652,1652,1652,1653,1653,1653,1653,1653,1653,1654,1654,1654,1654,1654,1654,1656,1656,1656,1656,1656,1656,1651,1651,1651,1651,1651,1651,1655,1655,1655,1655,1655,1655,5426,5426,5426,5427,5427,5427,5420,5420,5419,5419,1844,5437) ) 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 24 ,12 | 0.013 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (9798,9798,9798,9798,9798,9579,9579,9579,1383,1383,1383,9713,9713,9702,9702,9702,5428,5428,5428,1780,1780,1781,1781,1718,1718,1718,1719,1719,1719,1720,1720,1720,9744,9744,9744,9743,9743,9743,9742,9742,9742,8161,7916,7916,7915,7915,6339,6339,6339,6339,6339,6339,6338,6338,6338,6338,6338,6338,6340,6340,6340,6340,6340,6340,6337,6337,6337,6337,6337,6337,6341,6341,6341,6341,6341,6341,6336,6336,6336,6336,6336,6336,5418,1784,1784,1784,1784,1784,1785,1785,1785,1785,1785,1788,1788,1788,1788,1788,1786,1786,1786,1786,1786,1787,1787,1787,1787,1787,8848,8620,9799,9799,9799,9799,9799,9800,9800,9800,9800,9800,9796,9796,9796,9796,9796,9797,9797,9797,9797,9797,6342,1638,1638,1638,1638,1638,1638,1638,1637,1637,1637,1637,1637,1637,1637,1639,1639,1639,1639,1639,1639,1639,1640,1640,1640,1640,1640,1640,1640,1641,1641,1641,1641,1641,1641,1641,1642,1642,1642,1642,1642,1642,1642,1643,1643,1643,1643,1643,1643,1643,8575,8574,6525,6525,6525,6525,6525,6525,6525,6525,6523,6523,6523,6523,6523,6523,6523,6523,6529,6529,6529,6529,6529,6529,6529,6529,6524,6524,6524,6524,6524,6524,6524,6524,6526,6526,6526,6526,6526,6526,6526,6526,6527,6527,6527,6527,6527,6527,6527,6527,6528,6528,6528,6528,6528,6528,6528,6528,6530,6530,6530,6530,6530,6530,6530,6530,1816,1816,1816,1816,1816,1816,1816,1818,1818,1818,1818,1818,1818,1818,1817,1817,1817,1817,1817,1817,1817,1819,1819,1819,1819,1819,1819,1819,1814,1814,1814,1814,1814,1814,1814,1815,1815,1815,1815,1815,1815,1815,1820,1820,1820,1820,1820,1820,1820,1329,8681,9788,9788,9788,9788,9788,9788,9788,9790,9790,9790,9790,9790,9790,9790,9789,9789,9789,9789,9789,9789,9789,9786,9786,9786,9786,9786,9786,9786,9792,9792,9792,9792,9792,9792,9792,9791,9791,9791,9791,9791,9791,9791,9787,9787,9787,9787,9787,9787,9787,5444,5444,5444,5444,5444,5445,5445,5445,5445,5445,5443,5443,5443,5443,5443,5441,5441,5441,5441,5441,5442,5442,5442,5442,5442,1739,1739,1739,1739,1739,1740,1740,1740,1740,1740,1741,1741,1741,1741,1741,1743,1743,1743,1743,1743,1742,1742,1742,1742,1742,1365,1365,1365,1365,1365,1365,1366,1366,1366,1366,1366,1366,1367,1367,1367,1367,1367,1367,1369,1369,1369,1369,1369,1369,1368,1368,1368,1368,1368,1368,1370,1370,1370,1370,1370,1370,9126,8706,1670,1670,1670,1670,1672,1672,1672,1672,1673,1673,1673,1673,1671,1671,1671,1671,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,9580,9782,9782,9782,9782,9782,9783,9783,9783,9783,9783,9784,9784,9784,9784,9784,9785,9785,9785,9785,9785,9781,9781,9781,9781,9781,1344,1344,1344,1345,1345,1345,1346,1346,1346,9578,9578,9578,9577,9577,9577,1782,8568,5425,5431,5431,5431,5431,5431,5431,5431,5434,5434,5434,5434,5434,5434,5434,5433,5433,5433,5433,5433,5433,5433,5429,5429,5429,5429,5429,5429,5429,5432,5432,5432,5432,5432,5432,5432,5435,5435,5435,5435,5435,5435,5435,5430,5430,5430,5430,5430,5430,5430,1372,5100,1725,1725,1725,1724,1724,1724,1726,1726,1726,5106,5106,5106,5104,5104,5104,5105,5105,5105,1770,1770,1770,1770,1770,1770,1770,1770,1767,1767,1767,1767,1767,1767,1767,1767,1768,1768,1768,1768,1768,1768,1768,1768,1769,1769,1769,1769,1769,1769,1769,1769,1766,1766,1766,1766,1766,1766,1766,1766,1772,1772,1772,1772,1772,1772,1772,1772,1771,1771,1771,1771,1771,1771,1771,1771,1773,1773,1773,1773,1773,1773,1773,1773,1381,1381,1381,1382,1382,1382,6440,9712,1723,1723,1723,1721,1721,1721,1722,1722,1722,24,24,24,24,24,24,24,24,24,1867,1867,1867,1867,1867,1867,1867,1867,1867,1873,1873,1873,1873,1873,1873,1873,1873,1873,1866,1866,1866,1866,1866,1866,1866,1866,1866,1868,1868,1868,1868,1868,1868,1868,1868,1868,1871,1871,1871,1871,1871,1871,1871,1871,1871,1869,1869,1869,1869,1869,1869,1869,1869,1869,1870,1870,1870,1870,1870,1870,1870,1870,1870,1872,1872,1872,1872,1872,1872,1872,1872,1872,5436,9714,9714,9767,9745,7959,7959,7959,7959,7959,7961,7961,7961,7961,7961,7958,7958,7958,7958,7958,7960,7960,7960,7960,7960,7962,7962,7962,7962,7962,5459,1650,1650,1650,1650,1650,1650,1650,1644,1644,1644,1644,1644,1644,1644,1645,1645,1645,1645,1645,1645,1645,1647,1647,1647,1647,1647,1647,1647,1648,1648,1648,1648,1648,1648,1648,1649,1649,1649,1649,1649,1649,1649,1646,1646,1646,1646,1646,1646,1646,5438,5438,5438,5439,5439,5439,5440,5440,5440,5446,5446,5446,5446,5446,5449,5449,5449,5449,5449,5448,5448,5448,5448,5448,5447,5447,5447,5447,5447,5450,5450,5450,5450,5450,6344,8153,8570,8567,5455,5455,5455,5455,5455,5455,5453,5453,5453,5453,5453,5453,5456,5456,5456,5456,5456,5456,5458,5458,5458,5458,5458,5458,5457,5457,5457,5457,5457,5457,5454,5454,5454,5454,5454,5454,9772,9772,9772,9772,9771,9771,9771,9771,9770,9770,9770,9770,9769,9769,9769,9769,8115,8609,7914,6574,8171,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,6910,6910,6910,6910,6909,6909,6909,6909,6911,6911,6911,6911,6912,6912,6912,6912,5421,5421,5421,5423,5423,5423,5422,5422,5422,9700,9700,9700,9701,9701,9701,5424,1821,8114,8602,1793,1793,1793,1793,1793,1793,1793,1789,1789,1789,1789,1789,1789,1789,1795,1795,1795,1795,1795,1795,1795,1791,1791,1791,1791,1791,1791,1791,1794,1794,1794,1794,1794,1794,1794,1790,1790,1790,1790,1790,1790,1790,1792,1792,1792,1792,1792,1792,1792,8572,5417,8565,9768,1652,1652,1652,1652,1652,1652,1653,1653,1653,1653,1653,1653,1654,1654,1654,1654,1654,1654,1656,1656,1656,1656,1656,1656,1651,1651,1651,1651,1651,1651,1655,1655,1655,1655,1655,1655,5426,5426,5426,5427,5427,5427,5420,5420,5419,5419,1844,5437) | 0.002 | 1173 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (1868,1873,1872,1867,1871,1866,1869,1870,24,1329,1345,1346,1344,1345,1346,1344,1345,1344,1346,1370,1366,1369,1367,1368,1365,1370,1369,1365,1367,1368,1366,1366,1370,1365,1369,1368,1367,1370,1366,1369,1365,1367,1368,1370,1366,1368,1365,1367,1369,1369,1368,1366,1367,1365,1370,1372,1382,1383,1381,1382,1383,1381,1382,1383,1381,1405,1399,1404,1398,1403,1397,1402,1396,1400,1401,1395,1399,1405,1404,1398,1403,1397,1400,1402,1395,1401,1396,1399,1405,1400,1398,1404,1403,1396,1402,1395,1401,1397,1399,1400,1405,1397,1404,1403,1396,1402,1395,1401,1398,1400,1404,1405,1398,1397,1403,1402,1401,1396,1395,1399,1398,1397,1405,1396,1404,1395,1403,1402,1401,1400,1399,1405,1398,1404,1403,1397,1396,1402,1395,1400,1399,1401,1405,1404,1398,1397,1403,1401,1396,1400,1395,1399,1402,1405,1398,1404,1397,1402,1401,1396,1400,1395,1403,1399,1405,1398,1403,1402,1397,1401,1396,1395,1400,1404,1399,1404,1403,1398,1402,1401,1397,1400,1396,1395,1405,1399,1639,1643,1642,1638,1640,1637,1641,1639,1640,1643,1637,1642,1641,1638,1640,1642,1638,1643,1641,1637,1639,1638,1643,1637,1642,1641,1640,1639,1643,1638,1642,1637,1640,1639,1641,1643,1638,1641,1640,1637,1642,1639,1642,1641,1640,1638,1637,1643,1639,1646,1650,1649,1645,1647,1644,1648,1646,1647,1650,1644,1649,1648,1645,1647,1649,1645,1650,1648,1644,1646,1645,1650,1644,1649,1647,1648,1646,1650,1645,1649,1644,1647,1646,1648,1650,1645,1648,1647,1644,1646,1649,1649,1648,1647,1645,1644,1650,1646,1656,1652,1655,1653,1654,1651,1656,1655,1653,1651,1654,1652,1652,1656,1651,1655,1653,1654,1652,1656,1655,1651,1653,1654,1656,1652,1654,1651,1653,1655,1655,1654,1652,1651,1653,1656,1673,1671,1672,1670,1670,1673,1672,1671,1673,1670,1671,1672,1672,1670,1671,1673,1719,1720,1718,1720,1719,1718,1719,1718,1720,1722,1723,1721,1722,1723,1721,1722,1721,1723,1725,1724,1726,1726,1725,1724,1725,1724,1726,1740,1741,1743,1739,1742,1741,1739,1742,1743,1740,1739,1743,1741,1742,1740,1743,1741,1739,1740,1742,1742,1741,1739,1743,1740,1773,1768,1772,1767,1771,1769,1766,1770,1773,1768,1772,1769,1771,1766,1770,1767,1773,1772,1767,1771,1769,1766,1770,1768,1768,1767,1773,1772,1766,1771,1769,1770,1768,1773,1772,1767,1771,1766,1769,1770,1773,1768,1772,1767,1770,1766,1769,1771,1768,1773,1771,1767,1770,1766,1769,1772,1772,1771,1768,1770,1767,1769,1766,1773,1780,1781,1780,1781,1782,1785,1786,1788,1784,1787,1786,1784,1787,1788,1785,1784,1788,1786,1787,1785,1788,1786,1784,1785,1787,1787,1786,1784,1788,1785,1791,1795,1794,1790,1792,1793,1789,1791,1792,1795,1794,1789,1793,1790,1792,1794,1790,1789,1795,1793,1791,1790,1795,1789,1794,1793,1792,1791,1795,1790,1794,1789,1792,1793,1791,1795,1790,1793,1792,1789,1791,1794,1794,1793,1792,1790,1789,1795,1791,1816,1820,1819,1815,1817,1818,1814,1816,1817,1820,1814,1819,1818,1815,1817,1819,1815,1820,1818,1814,1816,1815,1820,1814,1819,1818,1817,1816,1820,1819,1815,1814,1817,1818,1816,1820,1815,1818,1817,1814,1816,1819,1819,1818,1817,1815,1814,1820,1816,1821,1844,1868,1873,1869,1867,1872,24,1871,1870,1866,1868,1869,1873,1866,1872,1871,24,1870,1867,1869,1867,1872,1873,1871,1866,1870,24,1868,1867,1866,1873,1872,24,1871,1870,1869,1868,1873,1867,1872,1871,1866,24,1869,1870,1868,1873,1867,1872,1866,1870,1869,24,1868,1871,1873,1867,1871,1870,1866,1869,24,1868,1872,1872,1871,1867,1870,1869,1866,24,1868,1873,5100,5105,5104,5106,5105,5106,5104,5105,5106,5104,5417,5418,5419,5420,5419,5420,5422,5421,5423,5422,5423,5421,5422,5423,5421,5424,5425,5427,5428,5426,5427,5428,5426,5427,5428,5426,5431,5435,5434,5430,5432,5433,5429,5431,5432,5435,5434,5429,5433,5430,5432,5434,5430,5435,5433,5429,5431,5430,5435,5429,5434,5432,5433,5431,5435,5434,5430,5429,5432,5433,5431,5435,5430,5433,5429,5432,5431,5434,5434,5430,5433,5432,5429,5431,5435,5436,5437,5439,5440,5438,5440,5439,5438,5439,5438,5440,5442,5443,5445,5441,5444,5443,5441,5444,5445,5442,5441,5445,5443,5444,5442,5445,5441,5443,5442,5444,5444,5443,5441,5445,5442,5447,5448,5450,5446,5449,5448,5446,5449,5450,5447,5446,5450,5448,5449,5447,5450,5446,5448,5447,5449,5449,5448,5446,5450,5447,5458,5454,5457,5455,5456,5453,5458,5457,5453,5455,5456,5454,5454,5458,5453,5457,5456,5455,5458,5454,5457,5453,5455,5456,5454,5458,5456,5453,5455,5457,5457,5454,5456,5455,5453,5458,5459,6341,6337,6340,6338,6336,6339,6341,6340,6338,6339,6336,6337,6337,6341,6336,6340,6338,6339,6337,6341,6340,6336,6338,6339,6341,6337,6339,6336,6338,6340,6340,6339,6337,6336,6338,6341,6342,6344,6391,6389,6390,6388,6391,6388,6389,6390,6388,6391,6389,6390,6390,6389,6388,6391,6440,6530,6525,6529,6524,6528,6526,6523,6527,6530,6525,6529,6526,6523,6528,6527,6524,6530,6529,6524,6528,6526,6523,6527,6525,6525,6524,6530,6523,6529,6528,6527,6526,6525,6530,6529,6528,6524,6523,6526,6527,6530,6525,6529,6524,6527,6523,6526,6528,6530,6525,6528,6524,6527,6523,6526,6529,6529,6528,6525,6527,6524,6526,6523,6530,6574,6912,6910,6911,6909,6909,6912,6911,6910,6912,6909,6910,6911,6911,6909,6910,6912,7914,7915,7916,7915,7916,7959,7960,7962,7961,7958,7960,7958,7961,7962,7959,7958,7962,7961,7960,7959,7962,7960,7958,7961,7959,7961,7960,7958,7962,7959,8114,8115,8153,8161,8171,8565,8567,8568,8570,8572,8574,8575,8602,8609,8620,8681,8706,8848,9126,9578,9577,9579,9578,9579,9577,9578,9577,9579,9580,9701,9700,9702,9701,9702,9700,9701,9702,9700,9712,9714,9713,9713,9714,9743,9744,9742,9744,9743,9742,9743,9744,9742,9745,9767,9768,9772,9770,9769,9771,9769,9772,9770,9771,9772,9769,9770,9771,9771,9769,9770,9772,9785,9782,9784,9781,9783,9785,9781,9784,9783,9782,9784,9781,9782,9785,9783,9783,9782,9781,9785,9784,9781,9784,9785,9783,9782,9788,9792,9791,9787,9789,9790,9786,9788,9789,9792,9791,9786,9790,9787,9789,9787,9791,9792,9790,9786,9788,9787,9792,9786,9791,9790,9789,9788,9792,9787,9791,9786,9789,9788,9790,9792,9787,9790,9789,9786,9788,9791,9791,9790,9789,9787,9786,9792,9788,9797,9798,9800,9796,9799,9798,9796,9799,9800,9797,9796,9800,9798,9799,9797,9800,9796,9798,9797,9799,9799,9798,9796,9800,9797) | 0.002 | 1173 |
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 (1868,1873,1867,1872,1869,1866,1871,1870,24,1329,1344,1346,1345,1346,1344,1345,1344,1345,1346,1370,1366,1367,1369,1368,1365,1369,1370,1368,1367,1365,1366,1370,1366,1369,1365,1368,1367,1370,1369,1366,1365,1367,1368,1370,1366,1368,1365,1367,1369,1369,1368,1366,1365,1370,1367,1372,1381,1383,1382,1381,1383,1382,1382,1381,1383,1399,1405,1404,1398,1397,1403,1400,1396,1402,1401,1395,1399,1405,1400,1398,1404,1397,1403,1402,1401,1395,1396,1399,1400,1405,1398,1404,1403,1402,1396,1401,1395,1397,1399,1400,1405,1404,1403,1397,1402,1396,1401,1395,1398,1398,1397,1396,1395,1405,1399,1404,1403,1402,1401,1400,1399,1398,1405,1397,1404,1396,1403,1402,1395,1401,1400,1405,1399,1404,1403,1398,1402,1397,1396,1400,1395,1401,1405,1399,1404,1403,1398,1397,1401,1396,1395,1400,1402,1405,1399,1404,1398,1402,1397,1396,1401,1395,1400,1403,1405,1399,1403,1398,1402,1397,1396,1401,1395,1400,1404,1404,1399,1403,1402,1401,1398,1397,1400,1396,1395,1405,1639,1640,1643,1638,1642,1641,1637,1639,1640,1643,1642,1641,1637,1638,1638,1637,1643,1639,1642,1641,1640,1639,1643,1638,1642,1637,1641,1640,1643,1639,1642,1638,1640,1637,1641,1643,1639,1641,1638,1637,1640,1642,1642,1641,1639,1640,1638,1637,1643,1646,1647,1650,1645,1649,1648,1644,1646,1647,1650,1649,1648,1644,1645,1645,1644,1650,1646,1649,1648,1647,1646,1650,1645,1649,1644,1648,1647,1650,1646,1649,1645,1647,1644,1648,1650,1646,1648,1645,1644,1647,1649,1649,1646,1648,1647,1645,1644,1650,1656,1652,1653,1655,1654,1651,1655,1656,1654,1653,1651,1652,1656,1652,1655,1651,1654,1653,1656,1655,1652,1651,1653,1654,1656,1652,1654,1651,1653,1655,1655,1652,1654,1651,1656,1653,1672,1673,1671,1670,1673,1670,1672,1671,1673,1670,1671,1672,1672,1670,1673,1671,1718,1720,1719,1720,1718,1719,1719,1718,1720,1721,1723,1722,1723,1721,1722,1721,1722,1723,1724,1726,1725,1724,1726,1725,1725,1724,1726,1740,1741,1743,1742,1739,1739,1740,1743,1742,1741,1740,1743,1739,1742,1741,1743,1740,1741,1739,1742,1742,1740,1741,1739,1743,1773,1772,1768,1769,1767,1771,1770,1766,1773,1768,1772,1771,1769,1770,1766,1767,1772,1773,1771,1769,1770,1767,1766,1768,1773,1768,1767,1772,1771,1766,1770,1769,1773,1772,1768,1771,1767,1766,1770,1769,1773,1772,1768,1770,1767,1766,1769,1771,1773,1768,1771,1767,1770,1766,1769,1772,1772,1768,1771,1770,1767,1766,1773,1769,1781,1780,1781,1780,1782,1785,1786,1788,1787,1784,1784,1785,1788,1787,1786,1785,1788,1784,1787,1786,1788,1785,1786,1784,1787,1787,1785,1786,1784,1788,1791,1792,1795,1790,1794,1793,1789,1791,1792,1795,1794,1793,1789,1790,1790,1789,1795,1791,1794,1793,1792,1791,1795,1790,1794,1789,1793,1792,1795,1791,1794,1790,1792,1789,1793,1795,1791,1793,1790,1789,1792,1794,1794,1793,1791,1792,1790,1789,1795,1816,1817,1820,1815,1819,1818,1814,1816,1817,1820,1819,1818,1814,1815,1815,1814,1820,1816,1819,1818,1817,1816,1820,1815,1819,1814,1818,1817,1820,1816,1819,1815,1817,1814,1818,1820,1816,1818,1815,1814,1817,1819,1819,1816,1818,1817,1815,1814,1820,1821,1844,1868,1869,1873,1867,1872,1871,1870,24,1866,1868,1869,1873,1872,1871,1866,1870,24,1867,1867,1866,24,1873,1868,1872,1871,1870,1869,1868,1867,1873,1866,1872,1871,24,1870,1869,1873,1868,1872,1871,1867,1866,1869,24,1870,1873,1868,1872,1867,1870,1866,24,1869,1871,1873,1868,1871,1867,1870,1866,24,1869,1872,1872,1868,1871,1870,1869,1867,1866,24,1873,5100,5104,5106,5105,5104,5106,5105,5104,5105,5106,5417,5418,5420,5419,5420,5419,5421,5423,5422,5423,5421,5422,5421,5422,5423,5424,5425,5426,5428,5427,5426,5428,5427,5426,5427,5428,5431,5432,5435,5430,5434,5433,5429,5431,5432,5435,5434,5433,5429,5430,5430,5429,5435,5431,5434,5433,5432,5431,5435,5430,5434,5429,5433,5432,5435,5431,5434,5430,5432,5429,5433,5435,5431,5433,5430,5429,5432,5434,5434,5431,5433,5432,5430,5429,5435,5436,5437,5438,5440,5439,5438,5440,5439,5438,5439,5440,5442,5443,5445,5444,5441,5441,5442,5445,5444,5443,5442,5445,5441,5444,5443,5445,5442,5443,5441,5444,5444,5442,5443,5441,5445,5447,5448,5450,5449,5446,5446,5447,5450,5449,5448,5447,5450,5446,5449,5448,5450,5447,5448,5446,5449,5449,5447,5448,5446,5450,5458,5454,5455,5457,5456,5453,5457,5458,5456,5455,5453,5454,5458,5454,5457,5453,5456,5455,5458,5457,5454,5453,5455,5456,5458,5454,5456,5453,5457,5455,5457,5456,5454,5453,5455,5458,5459,6341,6337,6338,6340,6339,6336,6340,6341,6339,6338,6336,6337,6341,6337,6340,6336,6339,6338,6341,6340,6337,6336,6338,6339,6341,6337,6339,6336,6338,6340,6340,6337,6339,6336,6338,6341,6342,6344,6390,6391,6389,6388,6391,6388,6390,6389,6391,6388,6389,6390,6390,6388,6391,6389,6440,6530,6529,6525,6526,6524,6528,6527,6523,6530,6525,6529,6528,6526,6527,6523,6524,6529,6530,6528,6526,6527,6524,6523,6525,6530,6525,6524,6529,6528,6523,6527,6526,6530,6529,6525,6528,6524,6523,6527,6526,6530,6529,6525,6527,6524,6523,6526,6528,6530,6525,6528,6524,6527,6523,6526,6529,6529,6528,6525,6527,6524,6523,6530,6526,6574,6911,6912,6910,6909,6912,6911,6909,6910,6912,6909,6910,6911,6911,6909,6910,6912,7914,7916,7915,7916,7915,7959,7960,7962,7961,7958,7958,7959,7962,7961,7960,7959,7962,7958,7961,7960,7962,7959,7960,7958,7961,7961,7959,7960,7958,7962,8114,8115,8153,8161,8171,8565,8567,8568,8570,8572,8574,8575,8602,8609,8620,8681,8706,8848,9126,9577,9579,9578,9579,9577,9578,9578,9577,9579,9580,9700,9702,9701,9702,9700,9701,9701,9700,9702,9712,9714,9713,9713,9714,9742,9744,9743,9744,9742,9743,9742,9743,9744,9745,9767,9768,9771,9772,9770,9769,9772,9769,9771,9770,9772,9769,9770,9771,9771,9769,9772,9770,9785,9782,9784,9783,9781,9784,9781,9783,9782,9785,9784,9785,9782,9781,9783,9783,9782,9785,9781,9784,9782,9781,9785,9784,9783,9788,9789,9792,9787,9791,9790,9786,9788,9789,9792,9791,9790,9786,9787,9787,9786,9792,9788,9791,9790,9789,9788,9792,9787,9791,9786,9790,9789,9792,9788,9791,9787,9789,9786,9790,9792,9788,9787,9790,9786,9789,9791,9791,9788,9790,9789,9787,9786,9792,9797,9798,9800,9799,9796,9796,9797,9800,9799,9798,9797,9800,9796,9799,9798,9800,9797,9798,9796,9799,9799,9797,9798,9796,9800)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 0 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 38 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 37 | 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` = '38'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.002 | 39 |
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 (9798,9798,9798,9798,9798,9579,9579,9579,1383,1383,1383,9713,9713,9702,9702,9702,5428,5428,5428,1780,1780,1781,1781,1718,1718,1718,1719,1719,1719,1720,1720,1720,9744,9744,9744,9743,9743,9743,9742,9742,9742,8161,7916,7916,7915,7915,6339,6339,6339,6339,6339,6339,6338,6338,6338,6338,6338,6338,6340,6340,6340,6340,6340,6340,6337,6337,6337,6337,6337,6337,6341,6341,6341,6341,6341,6341,6336,6336,6336,6336,6336,6336,5418,1784,1784,1784,1784,1784,1785,1785,1785,1785,1785,1788,1788,1788,1788,1788,1786,1786,1786,1786,1786,1787,1787,1787,1787,1787,8848,8620,9799,9799,9799,9799,9799,9800,9800,9800,9800,9800,9796,9796,9796,9796,9796,9797,9797,9797,9797,9797,6342,1638,1638,1638,1638,1638,1638,1638,1637,1637,1637,1637,1637,1637,1637,1639,1639,1639,1639,1639,1639,1639,1640,1640,1640,1640,1640,1640,1640,1641,1641,1641,1641,1641,1641,1641,1642,1642,1642,1642,1642,1642,1642,1643,1643,1643,1643,1643,1643,1643,8575,8574,6525,6525,6525,6525,6525,6525,6525,6525,6523,6523,6523,6523,6523,6523,6523,6523,6529,6529,6529,6529,6529,6529,6529,6529,6524,6524,6524,6524,6524,6524,6524,6524,6526,6526,6526,6526,6526,6526,6526,6526,6527,6527,6527,6527,6527,6527,6527,6527,6528,6528,6528,6528,6528,6528,6528,6528,6530,6530,6530,6530,6530,6530,6530,6530,1816,1816,1816,1816,1816,1816,1816,1818,1818,1818,1818,1818,1818,1818,1817,1817,1817,1817,1817,1817,1817,1819,1819,1819,1819,1819,1819,1819,1814,1814,1814,1814,1814,1814,1814,1815,1815,1815,1815,1815,1815,1815,1820,1820,1820,1820,1820,1820,1820,1329,8681,9788,9788,9788,9788,9788,9788,9788,9790,9790,9790,9790,9790,9790,9790,9789,9789,9789,9789,9789,9789,9789,9786,9786,9786,9786,9786,9786,9786,9792,9792,9792,9792,9792,9792,9792,9791,9791,9791,9791,9791,9791,9791,9787,9787,9787,9787,9787,9787,9787,5444,5444,5444,5444,5444,5445,5445,5445,5445,5445,5443,5443,5443,5443,5443,5441,5441,5441,5441,5441,5442,5442,5442,5442,5442,1739,1739,1739,1739,1739,1740,1740,1740,1740,1740,1741,1741,1741,1741,1741,1743,1743,1743,1743,1743,1742,1742,1742,1742,1742,1365,1365,1365,1365,1365,1365,1366,1366,1366,1366,1366,1366,1367,1367,1367,1367,1367,1367,1369,1369,1369,1369,1369,1369,1368,1368,1368,1368,1368,1368,1370,1370,1370,1370,1370,1370,9126,8706,1670,1670,1670,1670,1672,1672,1672,1672,1673,1673,1673,1673,1671,1671,1671,1671,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,9580,9782,9782,9782,9782,9782,9783,9783,9783,9783,9783,9784,9784,9784,9784,9784,9785,9785,9785,9785,9785,9781,9781,9781,9781,9781,1344,1344,1344,1345,1345,1345,1346,1346,1346,9578,9578,9578,9577,9577,9577,1782,8568,5425,5431,5431,5431,5431,5431,5431,5431,5434,5434,5434,5434,5434,5434,5434,5433,5433,5433,5433,5433,5433,5433,5429,5429,5429,5429,5429,5429,5429,5432,5432,5432,5432,5432,5432,5432,5435,5435,5435,5435,5435,5435,5435,5430,5430,5430,5430,5430,5430,5430,1372,5100,1725,1725,1725,1724,1724,1724,1726,1726,1726,5106,5106,5106,5104,5104,5104,5105,5105,5105,1770,1770,1770,1770,1770,1770,1770,1770,1767,1767,1767,1767,1767,1767,1767,1767,1768,1768,1768,1768,1768,1768,1768,1768,1769,1769,1769,1769,1769,1769,1769,1769,1766,1766,1766,1766,1766,1766,1766,1766,1772,1772,1772,1772,1772,1772,1772,1772,1771,1771,1771,1771,1771,1771,1771,1771,1773,1773,1773,1773,1773,1773,1773,1773,1381,1381,1381,1382,1382,1382,6440,9712,1723,1723,1723,1721,1721,1721,1722,1722,1722,24,24,24,24,24,24,24,24,24,1867,1867,1867,1867,1867,1867,1867,1867,1867,1873,1873,1873,1873,1873,1873,1873,1873,1873,1866,1866,1866,1866,1866,1866,1866,1866,1866,1868,1868,1868,1868,1868,1868,1868,1868,1868,1871,1871,1871,1871,1871,1871,1871,1871,1871,1869,1869,1869,1869,1869,1869,1869,1869,1869,1870,1870,1870,1870,1870,1870,1870,1870,1870,1872,1872,1872,1872,1872,1872,1872,1872,1872,5436,9714,9714,9767,9745,7959,7959,7959,7959,7959,7961,7961,7961,7961,7961,7958,7958,7958,7958,7958,7960,7960,7960,7960,7960,7962,7962,7962,7962,7962,5459,1650,1650,1650,1650,1650,1650,1650,1644,1644,1644,1644,1644,1644,1644,1645,1645,1645,1645,1645,1645,1645,1647,1647,1647,1647,1647,1647,1647,1648,1648,1648,1648,1648,1648,1648,1649,1649,1649,1649,1649,1649,1649,1646,1646,1646,1646,1646,1646,1646,5438,5438,5438,5439,5439,5439,5440,5440,5440,5446,5446,5446,5446,5446,5449,5449,5449,5449,5449,5448,5448,5448,5448,5448,5447,5447,5447,5447,5447,5450,5450,5450,5450,5450,6344,8153,8570,8567,5455,5455,5455,5455,5455,5455,5453,5453,5453,5453,5453,5453,5456,5456,5456,5456,5456,5456,5458,5458,5458,5458,5458,5458,5457,5457,5457,5457,5457,5457,5454,5454,5454,5454,5454,5454,9772,9772,9772,9772,9771,9771,9771,9771,9770,9770,9770,9770,9769,9769,9769,9769,8115,8609,7914,6574,8171,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,6910,6910,6910,6910,6909,6909,6909,6909,6911,6911,6911,6911,6912,6912,6912,6912,5421,5421,5421,5423,5423,5423,5422,5422,5422,9700,9700,9700,9701,9701,9701,5424,1821,8114,8602,1793,1793,1793,1793,1793,1793,1793,1789,1789,1789,1789,1789,1789,1789,1795,1795,1795,1795,1795,1795,1795,1791,1791,1791,1791,1791,1791,1791,1794,1794,1794,1794,1794,1794,1794,1790,1790,1790,1790,1790,1790,1790,1792,1792,1792,1792,1792,1792,1792,8572,5417,8565,9768,1652,1652,1652,1652,1652,1652,1653,1653,1653,1653,1653,1653,1654,1654,1654,1654,1654,1654,1656,1656,1656,1656,1656,1656,1651,1651,1651,1651,1651,1651,1655,1655,1655,1655,1655,1655,5426,5426,5426,5427,5427,5427,5420,5420,5419,5419,1844,5437) | 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 (9798,9798,9798,9798,9798,9579,9579,9579,1383,1383,1383,9713,9713,9702,9702,9702,5428,5428,5428,1780,1780,1781,1781,1718,1718,1718,1719,1719,1719,1720,1720,1720,9744,9744,9744,9743,9743,9743,9742,9742,9742,8161,7916,7916,7915,7915,6339,6339,6339,6339,6339,6339,6338,6338,6338,6338,6338,6338,6340,6340,6340,6340,6340,6340,6337,6337,6337,6337,6337,6337,6341,6341,6341,6341,6341,6341,6336,6336,6336,6336,6336,6336,5418,1784,1784,1784,1784,1784,1785,1785,1785,1785,1785,1788,1788,1788,1788,1788,1786,1786,1786,1786,1786,1787,1787,1787,1787,1787,8848,8620,9799,9799,9799,9799,9799,9800,9800,9800,9800,9800,9796,9796,9796,9796,9796,9797,9797,9797,9797,9797,6342,1638,1638,1638,1638,1638,1638,1638,1637,1637,1637,1637,1637,1637,1637,1639,1639,1639,1639,1639,1639,1639,1640,1640,1640,1640,1640,1640,1640,1641,1641,1641,1641,1641,1641,1641,1642,1642,1642,1642,1642,1642,1642,1643,1643,1643,1643,1643,1643,1643,8575,8574,6525,6525,6525,6525,6525,6525,6525,6525,6523,6523,6523,6523,6523,6523,6523,6523,6529,6529,6529,6529,6529,6529,6529,6529,6524,6524,6524,6524,6524,6524,6524,6524,6526,6526,6526,6526,6526,6526,6526,6526,6527,6527,6527,6527,6527,6527,6527,6527,6528,6528,6528,6528,6528,6528,6528,6528,6530,6530,6530,6530,6530,6530,6530,6530,1816,1816,1816,1816,1816,1816,1816,1818,1818,1818,1818,1818,1818,1818,1817,1817,1817,1817,1817,1817,1817,1819,1819,1819,1819,1819,1819,1819,1814,1814,1814,1814,1814,1814,1814,1815,1815,1815,1815,1815,1815,1815,1820,1820,1820,1820,1820,1820,1820,1329,8681,9788,9788,9788,9788,9788,9788,9788,9790,9790,9790,9790,9790,9790,9790,9789,9789,9789,9789,9789,9789,9789,9786,9786,9786,9786,9786,9786,9786,9792,9792,9792,9792,9792,9792,9792,9791,9791,9791,9791,9791,9791,9791,9787,9787,9787,9787,9787,9787,9787,5444,5444,5444,5444,5444,5445,5445,5445,5445,5445,5443,5443,5443,5443,5443,5441,5441,5441,5441,5441,5442,5442,5442,5442,5442,1739,1739,1739,1739,1739,1740,1740,1740,1740,1740,1741,1741,1741,1741,1741,1743,1743,1743,1743,1743,1742,1742,1742,1742,1742,1365,1365,1365,1365,1365,1365,1366,1366,1366,1366,1366,1366,1367,1367,1367,1367,1367,1367,1369,1369,1369,1369,1369,1369,1368,1368,1368,1368,1368,1368,1370,1370,1370,1370,1370,1370,9126,8706,1670,1670,1670,1670,1672,1672,1672,1672,1673,1673,1673,1673,1671,1671,1671,1671,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1397,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1401,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1402,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1398,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1396,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1395,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1399,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1404,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1405,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1400,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,1403,9580,9782,9782,9782,9782,9782,9783,9783,9783,9783,9783,9784,9784,9784,9784,9784,9785,9785,9785,9785,9785,9781,9781,9781,9781,9781,1344,1344,1344,1345,1345,1345,1346,1346,1346,9578,9578,9578,9577,9577,9577,1782,8568,5425,5431,5431,5431,5431,5431,5431,5431,5434,5434,5434,5434,5434,5434,5434,5433,5433,5433,5433,5433,5433,5433,5429,5429,5429,5429,5429,5429,5429,5432,5432,5432,5432,5432,5432,5432,5435,5435,5435,5435,5435,5435,5435,5430,5430,5430,5430,5430,5430,5430,1372,5100,1725,1725,1725,1724,1724,1724,1726,1726,1726,5106,5106,5106,5104,5104,5104,5105,5105,5105,1770,1770,1770,1770,1770,1770,1770,1770,1767,1767,1767,1767,1767,1767,1767,1767,1768,1768,1768,1768,1768,1768,1768,1768,1769,1769,1769,1769,1769,1769,1769,1769,1766,1766,1766,1766,1766,1766,1766,1766,1772,1772,1772,1772,1772,1772,1772,1772,1771,1771,1771,1771,1771,1771,1771,1771,1773,1773,1773,1773,1773,1773,1773,1773,1381,1381,1381,1382,1382,1382,6440,9712,1723,1723,1723,1721,1721,1721,1722,1722,1722,24,24,24,24,24,24,24,24,24,1867,1867,1867,1867,1867,1867,1867,1867,1867,1873,1873,1873,1873,1873,1873,1873,1873,1873,1866,1866,1866,1866,1866,1866,1866,1866,1866,1868,1868,1868,1868,1868,1868,1868,1868,1868,1871,1871,1871,1871,1871,1871,1871,1871,1871,1869,1869,1869,1869,1869,1869,1869,1869,1869,1870,1870,1870,1870,1870,1870,1870,1870,1870,1872,1872,1872,1872,1872,1872,1872,1872,1872,5436,9714,9714,9767,9745,7959,7959,7959,7959,7959,7961,7961,7961,7961,7961,7958,7958,7958,7958,7958,7960,7960,7960,7960,7960,7962,7962,7962,7962,7962,5459,1650,1650,1650,1650,1650,1650,1650,1644,1644,1644,1644,1644,1644,1644,1645,1645,1645,1645,1645,1645,1645,1647,1647,1647,1647,1647,1647,1647,1648,1648,1648,1648,1648,1648,1648,1649,1649,1649,1649,1649,1649,1649,1646,1646,1646,1646,1646,1646,1646,5438,5438,5438,5439,5439,5439,5440,5440,5440,5446,5446,5446,5446,5446,5449,5449,5449,5449,5449,5448,5448,5448,5448,5448,5447,5447,5447,5447,5447,5450,5450,5450,5450,5450,6344,8153,8570,8567,5455,5455,5455,5455,5455,5455,5453,5453,5453,5453,5453,5453,5456,5456,5456,5456,5456,5456,5458,5458,5458,5458,5458,5458,5457,5457,5457,5457,5457,5457,5454,5454,5454,5454,5454,5454,9772,9772,9772,9772,9771,9771,9771,9771,9770,9770,9770,9770,9769,9769,9769,9769,8115,8609,7914,6574,8171,6388,6388,6388,6388,6389,6389,6389,6389,6390,6390,6390,6390,6391,6391,6391,6391,6910,6910,6910,6910,6909,6909,6909,6909,6911,6911,6911,6911,6912,6912,6912,6912,5421,5421,5421,5423,5423,5423,5422,5422,5422,9700,9700,9700,9701,9701,9701,5424,1821,8114,8602,1793,1793,1793,1793,1793,1793,1793,1789,1789,1789,1789,1789,1789,1789,1795,1795,1795,1795,1795,1795,1795,1791,1791,1791,1791,1791,1791,1791,1794,1794,1794,1794,1794,1794,1794,1790,1790,1790,1790,1790,1790,1790,1792,1792,1792,1792,1792,1792,1792,8572,5417,8565,9768,1652,1652,1652,1652,1652,1652,1653,1653,1653,1653,1653,1653,1654,1654,1654,1654,1654,1654,1656,1656,1656,1656,1656,1656,1651,1651,1651,1651,1651,1651,1655,1655,1655,1655,1655,1655,5426,5426,5426,5427,5427,5427,5420,5420,5419,5419,1844,5437) | 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` = '1670' | 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` = '1673'
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` = '6909' | 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` = '6912'
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` = '8568' | 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` = '8568'
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` = '8572' | 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` = '8572'
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` = '5421' | 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` = '5422'
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` = '1372' | 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` = '1372'
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` = '8681' | 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` = '8681'
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` = '1637' | 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` = '1639'
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` = '5100' | 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` = '5100'
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` = '5104' | 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` = '5105'
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` = '1718' | 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` = '1719'
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` = '1766' | 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` = '1773'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 8 |
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.216 | 5871 |