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.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` = '99' | 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` = 99 | 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` = '99'
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 (99) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.036 | 625 |
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 (9741,9741,9741,9741,9741,9741,9596,9596,9596,9596,9596,9596,9596,9644,9644,9644,9644,9602,9602,9602,9602,9602,9602,5226,5226,5226,5226,5226,5226,5222,5222,5222,5222,5222,5222,5223,5223,5223,5223,5223,5223,5225,5225,5225,5225,5225,5225,5224,5224,5224,5224,5224,5224,5227,5227,5227,5227,5227,5227,8604,8328,8601,5173,5111,5172,5204,5204,5204,5204,5204,5205,5205,5205,5205,5205,5206,5206,5206,5206,5206,5207,5207,5207,5207,5207,5208,5208,5208,5208,5208,1482,1482,1482,1482,1482,1482,1482,1482,1480,1480,1480,1480,1480,1480,1480,1480,1485,1485,1485,1485,1485,1485,1485,1485,1483,1483,1483,1483,1483,1483,1483,1483,1484,1484,1484,1484,1484,1484,1484,1484,1481,1481,1481,1481,1481,1481,1481,1481,1478,1478,1478,1478,1478,1478,1478,1478,1479,1479,1479,1479,1479,1479,1479,1479,9738,9738,9738,9738,9738,9738,9739,9739,9739,9739,9739,9739,9737,9737,9737,9737,9737,9737,9736,9736,9736,9736,9736,9736,9740,9740,9740,9740,9740,9740,9595,9595,9595,9595,9595,9595,9595,9590,9590,9590,9590,9590,9590,9590,9594,9594,9594,9594,9594,9594,9594,9592,9592,9592,9592,9592,9592,9592,9593,9593,9593,9593,9593,9593,9593,9591,9591,9591,9591,9591,9591,9591,1474,1474,1474,1474,1477,1477,1477,1477,1476,1476,1476,1476,1475,1475,1475,1475,1707,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,9643,9643,9643,9643,9645,9645,9645,9645,9646,9646,9646,9646,8596,6958,8010,1512,1512,1512,1512,1512,1512,1512,1512,1512,1513,1513,1513,1513,1513,1513,1513,1513,1513,1511,1511,1511,1511,1511,1511,1511,1511,1511,1515,1515,1515,1515,1515,1515,1515,1515,1515,1516,1516,1516,1516,1516,1516,1516,1516,1516,1517,1517,1517,1517,1517,1517,1517,1517,1517,1514,1514,1514,1514,1514,1514,1514,1514,1514,1509,1509,1509,1509,1509,1509,1509,1509,1509,1510,1510,1510,1510,1510,1510,1510,1510,1510,5238,5249,5249,5249,5249,5250,5250,5250,5250,5251,5251,5251,5251,5248,5248,5248,5248,1802,1802,1802,1802,1802,1803,1803,1803,1803,1803,1804,1804,1804,1804,1804,1801,1801,1801,1801,1801,1805,1805,1805,1805,1805,9734,5188,5188,5188,5187,5187,5187,5186,5186,5186,1725,1725,1725,1724,1724,1724,1726,1726,1726,9735,5150,5150,5150,5150,5150,5150,5150,5152,5152,5152,5152,5152,5152,5152,5151,5151,5151,5151,5151,5151,5151,5155,5155,5155,5155,5155,5155,5155,5156,5156,5156,5156,5156,5156,5156,5154,5154,5154,5154,5154,5154,5154,5153,5153,5153,5153,5153,5153,5153,9597,9597,9597,9597,9597,9597,9598,9598,9598,9598,9598,9598,9599,9599,9599,9599,9599,9599,9600,9600,9600,9600,9600,9600,9601,9601,9601,9601,9601,9601,1708,1708,1708,1709,1709,1709,1710,1710,1710,1450,5242,5242,5242,5242,5242,5243,5243,5243,5243,5243,1723,1723,1723,1721,1721,1721,1722,1722,1722,8098,5183,5183,5183,5184,5184,5184,5185,5185,5185,1487,1487,1487,1487,1487,1487,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,8595,8606,6957,1717,5196,5196,5196,5196,5196,5192,5192,5192,5192,5192,5193,5193,5193,5193,5193,5194,5194,5194,5194,5194,5195,5195,5195,5195,5195,1520,1520,1520,1520,1520,1522,1522,1522,1522,1522,1523,1523,1523,1523,1523,1521,1521,1521,1521,1521,1519,1519,1519,1519,1519) ) as s GROUP BY id_product_ps ) as ss | 0.040 | 41 |
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 (9741,9741,9741,9741,9741,9741,9596,9596,9596,9596,9596,9596,9596,9644,9644,9644,9644,9602,9602,9602,9602,9602,9602,5226,5226,5226,5226,5226,5226,5222,5222,5222,5222,5222,5222,5223,5223,5223,5223,5223,5223,5225,5225,5225,5225,5225,5225,5224,5224,5224,5224,5224,5224,5227,5227,5227,5227,5227,5227,8604,8328,8601,5173,5111,5172,5204,5204,5204,5204,5204,5205,5205,5205,5205,5205,5206,5206,5206,5206,5206,5207,5207,5207,5207,5207,5208,5208,5208,5208,5208,1482,1482,1482,1482,1482,1482,1482,1482,1480,1480,1480,1480,1480,1480,1480,1480,1485,1485,1485,1485,1485,1485,1485,1485,1483,1483,1483,1483,1483,1483,1483,1483,1484,1484,1484,1484,1484,1484,1484,1484,1481,1481,1481,1481,1481,1481,1481,1481,1478,1478,1478,1478,1478,1478,1478,1478,1479,1479,1479,1479,1479,1479,1479,1479,9738,9738,9738,9738,9738,9738,9739,9739,9739,9739,9739,9739,9737,9737,9737,9737,9737,9737,9736,9736,9736,9736,9736,9736,9740,9740,9740,9740,9740,9740,9595,9595,9595,9595,9595,9595,9595,9590,9590,9590,9590,9590,9590,9590,9594,9594,9594,9594,9594,9594,9594,9592,9592,9592,9592,9592,9592,9592,9593,9593,9593,9593,9593,9593,9593,9591,9591,9591,9591,9591,9591,9591,1474,1474,1474,1474,1477,1477,1477,1477,1476,1476,1476,1476,1475,1475,1475,1475,1707,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,9643,9643,9643,9643,9645,9645,9645,9645,9646,9646,9646,9646,8596,6958,8010,1512,1512,1512,1512,1512,1512,1512,1512,1512,1513,1513,1513,1513,1513,1513,1513,1513,1513,1511,1511,1511,1511,1511,1511,1511,1511,1511,1515,1515,1515,1515,1515,1515,1515,1515,1515,1516,1516,1516,1516,1516,1516,1516,1516,1516,1517,1517,1517,1517,1517,1517,1517,1517,1517,1514,1514,1514,1514,1514,1514,1514,1514,1514,1509,1509,1509,1509,1509,1509,1509,1509,1509,1510,1510,1510,1510,1510,1510,1510,1510,1510,5238,5249,5249,5249,5249,5250,5250,5250,5250,5251,5251,5251,5251,5248,5248,5248,5248,1802,1802,1802,1802,1802,1803,1803,1803,1803,1803,1804,1804,1804,1804,1804,1801,1801,1801,1801,1801,1805,1805,1805,1805,1805,9734,5188,5188,5188,5187,5187,5187,5186,5186,5186,1725,1725,1725,1724,1724,1724,1726,1726,1726,9735,5150,5150,5150,5150,5150,5150,5150,5152,5152,5152,5152,5152,5152,5152,5151,5151,5151,5151,5151,5151,5151,5155,5155,5155,5155,5155,5155,5155,5156,5156,5156,5156,5156,5156,5156,5154,5154,5154,5154,5154,5154,5154,5153,5153,5153,5153,5153,5153,5153,9597,9597,9597,9597,9597,9597,9598,9598,9598,9598,9598,9598,9599,9599,9599,9599,9599,9599,9600,9600,9600,9600,9600,9600,9601,9601,9601,9601,9601,9601,1708,1708,1708,1709,1709,1709,1710,1710,1710,1450,5242,5242,5242,5242,5242,5243,5243,5243,5243,5243,1723,1723,1723,1721,1721,1721,1722,1722,1722,8098,5183,5183,5183,5184,5184,5184,5185,5185,5185,1487,1487,1487,1487,1487,1487,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,8595,8606,6957,1717,5196,5196,5196,5196,5196,5192,5192,5192,5192,5192,5193,5193,5193,5193,5193,5194,5194,5194,5194,5194,5195,5195,5195,5195,5195,1520,1520,1520,1520,1520,1522,1522,1522,1522,1522,1523,1523,1523,1523,1523,1521,1521,1521,1521,1521,1519,1519,1519,1519,1519) ) 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.006 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (9741,9741,9741,9741,9741,9741,9596,9596,9596,9596,9596,9596,9596,9644,9644,9644,9644,9602,9602,9602,9602,9602,9602,5226,5226,5226,5226,5226,5226,5222,5222,5222,5222,5222,5222,5223,5223,5223,5223,5223,5223,5225,5225,5225,5225,5225,5225,5224,5224,5224,5224,5224,5224,5227,5227,5227,5227,5227,5227,8604,8328,8601,5173,5111,5172,5204,5204,5204,5204,5204,5205,5205,5205,5205,5205,5206,5206,5206,5206,5206,5207,5207,5207,5207,5207,5208,5208,5208,5208,5208,1482,1482,1482,1482,1482,1482,1482,1482,1480,1480,1480,1480,1480,1480,1480,1480,1485,1485,1485,1485,1485,1485,1485,1485,1483,1483,1483,1483,1483,1483,1483,1483,1484,1484,1484,1484,1484,1484,1484,1484,1481,1481,1481,1481,1481,1481,1481,1481,1478,1478,1478,1478,1478,1478,1478,1478,1479,1479,1479,1479,1479,1479,1479,1479,9738,9738,9738,9738,9738,9738,9739,9739,9739,9739,9739,9739,9737,9737,9737,9737,9737,9737,9736,9736,9736,9736,9736,9736,9740,9740,9740,9740,9740,9740,9595,9595,9595,9595,9595,9595,9595,9590,9590,9590,9590,9590,9590,9590,9594,9594,9594,9594,9594,9594,9594,9592,9592,9592,9592,9592,9592,9592,9593,9593,9593,9593,9593,9593,9593,9591,9591,9591,9591,9591,9591,9591,1474,1474,1474,1474,1477,1477,1477,1477,1476,1476,1476,1476,1475,1475,1475,1475,1707,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,9643,9643,9643,9643,9645,9645,9645,9645,9646,9646,9646,9646,8596,6958,8010,1512,1512,1512,1512,1512,1512,1512,1512,1512,1513,1513,1513,1513,1513,1513,1513,1513,1513,1511,1511,1511,1511,1511,1511,1511,1511,1511,1515,1515,1515,1515,1515,1515,1515,1515,1515,1516,1516,1516,1516,1516,1516,1516,1516,1516,1517,1517,1517,1517,1517,1517,1517,1517,1517,1514,1514,1514,1514,1514,1514,1514,1514,1514,1509,1509,1509,1509,1509,1509,1509,1509,1509,1510,1510,1510,1510,1510,1510,1510,1510,1510,5238,5249,5249,5249,5249,5250,5250,5250,5250,5251,5251,5251,5251,5248,5248,5248,5248,1802,1802,1802,1802,1802,1803,1803,1803,1803,1803,1804,1804,1804,1804,1804,1801,1801,1801,1801,1801,1805,1805,1805,1805,1805,9734,5188,5188,5188,5187,5187,5187,5186,5186,5186,1725,1725,1725,1724,1724,1724,1726,1726,1726,9735,5150,5150,5150,5150,5150,5150,5150,5152,5152,5152,5152,5152,5152,5152,5151,5151,5151,5151,5151,5151,5151,5155,5155,5155,5155,5155,5155,5155,5156,5156,5156,5156,5156,5156,5156,5154,5154,5154,5154,5154,5154,5154,5153,5153,5153,5153,5153,5153,5153,9597,9597,9597,9597,9597,9597,9598,9598,9598,9598,9598,9598,9599,9599,9599,9599,9599,9599,9600,9600,9600,9600,9600,9600,9601,9601,9601,9601,9601,9601,1708,1708,1708,1709,1709,1709,1710,1710,1710,1450,5242,5242,5242,5242,5242,5243,5243,5243,5243,5243,1723,1723,1723,1721,1721,1721,1722,1722,1722,8098,5183,5183,5183,5184,5184,5184,5185,5185,5185,1487,1487,1487,1487,1487,1487,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,8595,8606,6957,1717,5196,5196,5196,5196,5196,5192,5192,5192,5192,5192,5193,5193,5193,5193,5193,5194,5194,5194,5194,5194,5195,5195,5195,5195,5195,1520,1520,1520,1520,1520,1522,1522,1522,1522,1522,1523,1523,1523,1523,1523,1521,1521,1521,1521,1521,1519,1519,1519,1519,1519) | 0.001 | 625 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (1450,1477,1475,1474,1476,1477,1474,1475,1476,1477,1474,1475,1476,1476,1475,1474,1477,1485,1480,1484,1479,1483,1481,1482,1478,1485,1480,1484,1481,1483,1478,1482,1479,1485,1484,1483,1479,1481,1478,1482,1480,1480,1479,1485,1478,1484,1483,1481,1482,1485,1480,1484,1479,1483,1478,1481,1482,1485,1480,1484,1479,1482,1478,1481,1483,1485,1480,1483,1482,1479,1478,1481,1484,1484,1483,1480,1482,1479,1478,1481,1485,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,1512,1517,1516,1511,1515,1510,1513,1509,1514,1512,1517,1513,1511,1516,1515,1509,1514,1510,1512,1513,1517,1510,1516,1515,1509,1514,1511,1513,1516,1511,1517,1515,1510,1514,1509,1512,1511,1517,1510,1516,1509,1515,1513,1514,1512,1517,1516,1511,1510,1515,1509,1513,1512,1514,1517,1511,1516,1514,1510,1513,1509,1512,1515,1517,1511,1515,1514,1510,1513,1509,1516,1512,1516,1515,1511,1514,1513,1510,1509,1517,1512,1520,1521,1523,1522,1519,1521,1522,1519,1523,1520,1519,1523,1522,1521,1520,1523,1521,1519,1522,1520,1522,1521,1519,1520,1523,1707,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,1717,1722,1723,1721,1722,1723,1721,1722,1721,1723,1725,1724,1726,1726,1725,1724,1725,1724,1726,1802,1803,1805,1804,1801,1803,1804,1801,1805,1802,1801,1805,1803,1804,1802,1805,1801,1803,1804,1802,1804,1803,1801,1802,1805,5111,5152,5156,5155,5151,5153,5154,5150,5152,5153,5156,5155,5150,5154,5151,5153,5151,5155,5150,5156,5154,5152,5151,5156,5150,5155,5154,5153,5152,5156,5151,5155,5150,5153,5154,5152,5156,5151,5154,5153,5150,5152,5155,5155,5154,5151,5153,5150,5152,5156,5172,5173,5184,5185,5183,5185,5184,5183,5184,5185,5183,5187,5188,5186,5187,5188,5186,5187,5186,5188,5193,5194,5196,5195,5192,5194,5195,5192,5196,5193,5192,5196,5195,5194,5193,5196,5192,5194,5195,5193,5195,5194,5192,5196,5193,5205,5206,5208,5204,5207,5206,5207,5204,5208,5205,5204,5208,5206,5207,5205,5208,5206,5204,5205,5207,5207,5206,5204,5205,5208,5227,5223,5226,5224,5225,5222,5227,5226,5222,5224,5225,5223,5223,5227,5222,5226,5224,5225,5227,5223,5226,5222,5224,5225,5223,5227,5225,5222,5224,5226,5226,5223,5225,5222,5224,5227,5238,5243,5241,5239,5242,5240,5242,5241,5239,5240,5243,5251,5249,5248,5250,5251,5248,5250,5249,5251,5248,5249,5250,5250,5249,5248,5251,6957,6958,8010,8098,8328,8595,8596,8601,8604,8606,9592,9596,9595,9591,9593,9594,9590,9592,9593,9596,9595,9590,9594,9591,9593,9591,9595,9590,9596,9594,9592,9591,9596,9590,9595,9594,9593,9592,9596,9595,9591,9590,9593,9594,9592,9596,9591,9594,9593,9590,9595,9592,9595,9594,9591,9593,9590,9596,9592,9602,9598,9601,9599,9597,9600,9602,9601,9599,9597,9600,9598,9598,9602,9597,9601,9599,9600,9598,9602,9601,9597,9599,9600,9598,9602,9600,9597,9599,9601,9601,9600,9598,9597,9599,9602,9646,9644,9645,9643,9643,9646,9644,9645,9643,9646,9644,9645,9645,9643,9644,9646,9734,9735,9741,9737,9740,9738,9739,9736,9741,9740,9738,9736,9739,9737,9737,9741,9736,9740,9738,9739,9741,9737,9740,9736,9738,9739,9741,9737,9739,9736,9738,9740,9740,9739,9737,9738,9736,9741) | 0.001 | 640 |
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 (1450,1476,1477,1475,1474,1477,1474,1476,1475,1477,1474,1476,1475,1476,1474,1477,1475,1485,1484,1480,1481,1479,1483,1482,1478,1485,1480,1484,1483,1481,1482,1478,1479,1484,1485,1483,1481,1482,1479,1478,1480,1485,1480,1479,1484,1483,1478,1482,1481,1485,1484,1480,1483,1479,1478,1482,1481,1485,1484,1480,1479,1482,1478,1483,1481,1485,1480,1483,1479,1482,1478,1484,1481,1484,1483,1480,1482,1479,1478,1485,1481,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,1512,1517,1511,1516,1513,1510,1515,1514,1509,1512,1513,1517,1511,1516,1515,1514,1509,1510,1512,1513,1517,1516,1515,1510,1514,1509,1511,1511,1510,1509,1517,1512,1516,1515,1514,1513,1512,1511,1517,1510,1516,1515,1509,1514,1513,1517,1512,1516,1515,1511,1510,1513,1509,1514,1517,1512,1516,1511,1514,1510,1509,1513,1515,1517,1512,1515,1511,1514,1510,1509,1513,1516,1516,1512,1515,1514,1513,1511,1510,1509,1517,1520,1521,1523,1522,1519,1519,1520,1523,1522,1521,1520,1523,1519,1522,1521,1523,1520,1521,1519,1522,1522,1520,1521,1519,1523,1707,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,1717,1721,1723,1722,1723,1721,1722,1721,1722,1723,1724,1726,1725,1724,1726,1725,1725,1724,1726,1802,1803,1805,1804,1801,1801,1802,1805,1804,1803,1802,1805,1801,1804,1803,1805,1802,1803,1801,1804,1804,1802,1803,1801,1805,5111,5152,5153,5156,5151,5155,5154,5150,5152,5153,5156,5155,5154,5150,5151,5151,5150,5156,5152,5155,5154,5153,5152,5156,5151,5155,5150,5154,5153,5156,5152,5155,5151,5153,5150,5154,5156,5152,5154,5151,5150,5153,5155,5155,5154,5152,5153,5151,5150,5156,5172,5173,5183,5185,5184,5185,5183,5184,5183,5184,5185,5186,5188,5187,5186,5188,5187,5186,5187,5188,5193,5194,5196,5195,5192,5192,5193,5196,5195,5194,5193,5196,5192,5195,5194,5196,5193,5194,5192,5195,5195,5193,5194,5192,5196,5205,5206,5208,5207,5204,5204,5205,5208,5207,5206,5205,5208,5204,5207,5206,5208,5205,5206,5204,5207,5207,5205,5206,5204,5208,5227,5223,5224,5226,5225,5222,5226,5227,5225,5224,5222,5223,5227,5223,5226,5222,5225,5224,5227,5226,5223,5222,5225,5224,5227,5223,5225,5222,5226,5224,5226,5225,5223,5222,5227,5224,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,5250,5251,5249,5248,5251,5248,5250,5249,5251,5248,5249,5250,5250,5248,5249,5251,6957,6958,8010,8098,8328,8595,8596,8601,8604,8606,9592,9593,9596,9591,9595,9594,9590,9592,9593,9596,9595,9594,9590,9591,9591,9590,9596,9592,9595,9594,9593,9592,9596,9591,9595,9590,9594,9593,9596,9592,9595,9591,9593,9590,9594,9596,9592,9594,9591,9590,9593,9595,9595,9592,9594,9593,9591,9590,9596,9602,9598,9599,9601,9600,9597,9601,9602,9600,9599,9597,9598,9602,9598,9601,9597,9600,9599,9602,9601,9598,9597,9600,9599,9602,9598,9600,9597,9599,9601,9601,9598,9600,9597,9599,9602,9645,9646,9644,9643,9646,9645,9643,9644,9646,9643,9645,9644,9645,9643,9646,9644,9734,9735,9741,9737,9738,9740,9739,9736,9740,9741,9739,9738,9736,9737,9741,9737,9740,9736,9739,9738,9741,9740,9737,9736,9739,9738,9741,9737,9739,9736,9740,9738,9740,9739,9737,9736,9738,9741)
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` = 99 | 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` = '99'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.001 | 29 |
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 (9741,9741,9741,9741,9741,9741,9596,9596,9596,9596,9596,9596,9596,9644,9644,9644,9644,9602,9602,9602,9602,9602,9602,5226,5226,5226,5226,5226,5226,5222,5222,5222,5222,5222,5222,5223,5223,5223,5223,5223,5223,5225,5225,5225,5225,5225,5225,5224,5224,5224,5224,5224,5224,5227,5227,5227,5227,5227,5227,8604,8328,8601,5173,5111,5172,5204,5204,5204,5204,5204,5205,5205,5205,5205,5205,5206,5206,5206,5206,5206,5207,5207,5207,5207,5207,5208,5208,5208,5208,5208,1482,1482,1482,1482,1482,1482,1482,1482,1480,1480,1480,1480,1480,1480,1480,1480,1485,1485,1485,1485,1485,1485,1485,1485,1483,1483,1483,1483,1483,1483,1483,1483,1484,1484,1484,1484,1484,1484,1484,1484,1481,1481,1481,1481,1481,1481,1481,1481,1478,1478,1478,1478,1478,1478,1478,1478,1479,1479,1479,1479,1479,1479,1479,1479,9738,9738,9738,9738,9738,9738,9739,9739,9739,9739,9739,9739,9737,9737,9737,9737,9737,9737,9736,9736,9736,9736,9736,9736,9740,9740,9740,9740,9740,9740,9595,9595,9595,9595,9595,9595,9595,9590,9590,9590,9590,9590,9590,9590,9594,9594,9594,9594,9594,9594,9594,9592,9592,9592,9592,9592,9592,9592,9593,9593,9593,9593,9593,9593,9593,9591,9591,9591,9591,9591,9591,9591,1474,1474,1474,1474,1477,1477,1477,1477,1476,1476,1476,1476,1475,1475,1475,1475,1707,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,9643,9643,9643,9643,9645,9645,9645,9645,9646,9646,9646,9646,8596,6958,8010,1512,1512,1512,1512,1512,1512,1512,1512,1512,1513,1513,1513,1513,1513,1513,1513,1513,1513,1511,1511,1511,1511,1511,1511,1511,1511,1511,1515,1515,1515,1515,1515,1515,1515,1515,1515,1516,1516,1516,1516,1516,1516,1516,1516,1516,1517,1517,1517,1517,1517,1517,1517,1517,1517,1514,1514,1514,1514,1514,1514,1514,1514,1514,1509,1509,1509,1509,1509,1509,1509,1509,1509,1510,1510,1510,1510,1510,1510,1510,1510,1510,5238,5249,5249,5249,5249,5250,5250,5250,5250,5251,5251,5251,5251,5248,5248,5248,5248,1802,1802,1802,1802,1802,1803,1803,1803,1803,1803,1804,1804,1804,1804,1804,1801,1801,1801,1801,1801,1805,1805,1805,1805,1805,9734,5188,5188,5188,5187,5187,5187,5186,5186,5186,1725,1725,1725,1724,1724,1724,1726,1726,1726,9735,5150,5150,5150,5150,5150,5150,5150,5152,5152,5152,5152,5152,5152,5152,5151,5151,5151,5151,5151,5151,5151,5155,5155,5155,5155,5155,5155,5155,5156,5156,5156,5156,5156,5156,5156,5154,5154,5154,5154,5154,5154,5154,5153,5153,5153,5153,5153,5153,5153,9597,9597,9597,9597,9597,9597,9598,9598,9598,9598,9598,9598,9599,9599,9599,9599,9599,9599,9600,9600,9600,9600,9600,9600,9601,9601,9601,9601,9601,9601,1708,1708,1708,1709,1709,1709,1710,1710,1710,1450,5242,5242,5242,5242,5242,5243,5243,5243,5243,5243,1723,1723,1723,1721,1721,1721,1722,1722,1722,8098,5183,5183,5183,5184,5184,5184,5185,5185,5185,1487,1487,1487,1487,1487,1487,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,8595,8606,6957,1717,5196,5196,5196,5196,5196,5192,5192,5192,5192,5192,5193,5193,5193,5193,5193,5194,5194,5194,5194,5194,5195,5195,5195,5195,5195,1520,1520,1520,1520,1520,1522,1522,1522,1522,1522,1523,1523,1523,1523,1523,1521,1521,1521,1521,1521,1519,1519,1519,1519,1519) | 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 (9741,9741,9741,9741,9741,9741,9596,9596,9596,9596,9596,9596,9596,9644,9644,9644,9644,9602,9602,9602,9602,9602,9602,5226,5226,5226,5226,5226,5226,5222,5222,5222,5222,5222,5222,5223,5223,5223,5223,5223,5223,5225,5225,5225,5225,5225,5225,5224,5224,5224,5224,5224,5224,5227,5227,5227,5227,5227,5227,8604,8328,8601,5173,5111,5172,5204,5204,5204,5204,5204,5205,5205,5205,5205,5205,5206,5206,5206,5206,5206,5207,5207,5207,5207,5207,5208,5208,5208,5208,5208,1482,1482,1482,1482,1482,1482,1482,1482,1480,1480,1480,1480,1480,1480,1480,1480,1485,1485,1485,1485,1485,1485,1485,1485,1483,1483,1483,1483,1483,1483,1483,1483,1484,1484,1484,1484,1484,1484,1484,1484,1481,1481,1481,1481,1481,1481,1481,1481,1478,1478,1478,1478,1478,1478,1478,1478,1479,1479,1479,1479,1479,1479,1479,1479,9738,9738,9738,9738,9738,9738,9739,9739,9739,9739,9739,9739,9737,9737,9737,9737,9737,9737,9736,9736,9736,9736,9736,9736,9740,9740,9740,9740,9740,9740,9595,9595,9595,9595,9595,9595,9595,9590,9590,9590,9590,9590,9590,9590,9594,9594,9594,9594,9594,9594,9594,9592,9592,9592,9592,9592,9592,9592,9593,9593,9593,9593,9593,9593,9593,9591,9591,9591,9591,9591,9591,9591,1474,1474,1474,1474,1477,1477,1477,1477,1476,1476,1476,1476,1475,1475,1475,1475,1707,1712,1712,1712,1712,1713,1713,1713,1713,1714,1714,1714,1714,1715,1715,1715,1715,9643,9643,9643,9643,9645,9645,9645,9645,9646,9646,9646,9646,8596,6958,8010,1512,1512,1512,1512,1512,1512,1512,1512,1512,1513,1513,1513,1513,1513,1513,1513,1513,1513,1511,1511,1511,1511,1511,1511,1511,1511,1511,1515,1515,1515,1515,1515,1515,1515,1515,1515,1516,1516,1516,1516,1516,1516,1516,1516,1516,1517,1517,1517,1517,1517,1517,1517,1517,1517,1514,1514,1514,1514,1514,1514,1514,1514,1514,1509,1509,1509,1509,1509,1509,1509,1509,1509,1510,1510,1510,1510,1510,1510,1510,1510,1510,5238,5249,5249,5249,5249,5250,5250,5250,5250,5251,5251,5251,5251,5248,5248,5248,5248,1802,1802,1802,1802,1802,1803,1803,1803,1803,1803,1804,1804,1804,1804,1804,1801,1801,1801,1801,1801,1805,1805,1805,1805,1805,9734,5188,5188,5188,5187,5187,5187,5186,5186,5186,1725,1725,1725,1724,1724,1724,1726,1726,1726,9735,5150,5150,5150,5150,5150,5150,5150,5152,5152,5152,5152,5152,5152,5152,5151,5151,5151,5151,5151,5151,5151,5155,5155,5155,5155,5155,5155,5155,5156,5156,5156,5156,5156,5156,5156,5154,5154,5154,5154,5154,5154,5154,5153,5153,5153,5153,5153,5153,5153,9597,9597,9597,9597,9597,9597,9598,9598,9598,9598,9598,9598,9599,9599,9599,9599,9599,9599,9600,9600,9600,9600,9600,9600,9601,9601,9601,9601,9601,9601,1708,1708,1708,1709,1709,1709,1710,1710,1710,1450,5242,5242,5242,5242,5242,5243,5243,5243,5243,5243,1723,1723,1723,1721,1721,1721,1722,1722,1722,8098,5183,5183,5183,5184,5184,5184,5185,5185,5185,1487,1487,1487,1487,1487,1487,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,8595,8606,6957,1717,5196,5196,5196,5196,5196,5192,5192,5192,5192,5192,5193,5193,5193,5193,5193,5194,5194,5194,5194,5194,5195,5195,5195,5195,5195,1520,1520,1520,1520,1520,1522,1522,1522,1522,1522,1523,1523,1523,1523,1523,1521,1521,1521,1521,1521,1519,1519,1519,1519,1519) | 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` = '6957' | 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` = '6957'
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` = '6958' | 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` = '6958'
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` = '1724' | 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` = '1725'
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` = '8328' | 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` = '8328'
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` = '5183' | 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` = '5184'
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` = '9734' | 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` = '9734'
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` = '9735' | 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` = '9735'
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` = '1474' | 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` = '1477'
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` = '8596' | 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` = '8596'
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` = '5111' | 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` = '5111'
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` = '1721' | 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` = '1722'
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` = '5150' | 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` = '5152'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 7 |
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.102 | 4170 |