| 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 | 77 |
| 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` >= '2026-04-07'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
| SELECT *
FROM (`configuration`) | 0.000 | 66 |
| SELECT *
FROM (`configuration`) | 0.000 | 66 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 113 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`shop_parameters` AS `p`)
INNER JOIN `shop_parameters_description` AS `pd` ON (`pd`.`parameter_id` = `p`.`id_parameter`)
WHERE `p`.`active` = 'Y' | 0.000 | 1 |
| SELECT `shop_parameters`.*, `shop_product_parameters`.*, `shop_parameters_values`.*
FROM (`shop_parameters`)
LEFT JOIN `shop_product_parameters` ON (`shop_product_parameters`.`parameter_id` = `shop_parameters`.`id_parameter`)
LEFT JOIN `shop_products_parameters` ON (`shop_products_parameters`.`product_id` = `shop_product_parameters`.`product_id`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`id_parameter_value` ASC | 0.003 | 518 |
| SELECT *
FROM (`pages`)
WHERE `lang` = 'pl_PL'
AND `available` = 'Y'
AND `show_in_menu` = 1
AND `page_type` != 'news'
ORDER BY `page_position` DESC, `available` ASC | 0.000 | 5 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '2'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1'
ORDER BY `boxes`.`position` DESC | 0.000 | 4 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '4'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1' | 0.000 | 3 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '71' | 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` = 71 | 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` = '71'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (5135,5177,1422,9802,1407,8562,5129,8333,1411,8671,8579,5190,8044,5169,5112,5124,5144,5161,5140,9043,8138,5108,5145,9479,9461,1587,5130,5137,8986,1353,5234,5231,5134,5201,5139,5149,5120,9763,5239,8099,8107,5466,5123,5180,5228,6533,8168,8334,9488,5158,9463,8271,5114,5171,10037,9469,9459,9493,5142,9762,5214,1463,1497,8573,1452,5209,1371,5197,9804,9780,5110,5146,9484,5230,8120,5118,8563,10238,5245,9127,5091,5148,10241,1506,9081,9082,1457,9776,5215,8608) | 0.000 | 255 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (1353,1371,1409,1406,1407,1408,1413,1410,1412,1411,1429,1423,1428,1427,1424,1421,1426,1420,1425,1422,1454,1451,1452,1453,1456,1460,1455,1459,1457,1458,1462,1463,1461,1494,1499,1498,1493,1496,1492,1495,1497,1508,1507,1502,1505,1501,1504,1500,1503,1506,1588,1587,1589,5091,5092,5108,5109,5107,5110,5112,5113,5114,5115,5117,5116,5118,5121,5120,5119,5122,5123,5124,5128,5127,5125,5126,5129,5133,5131,5130,5132,5134,5135,5137,5138,5136,5139,5140,5142,5143,5141,5144,5145,5147,5146,5148,5149,5157,5160,5159,5158,5163,5167,5166,5162,5164,5165,5161,5169,5170,5168,5171,5176,5175,5174,5177,5179,5178,5180,5190,5191,5200,5198,5197,5199,5202,5201,5203,5209,5210,5213,5214,5212,5217,5221,5220,5216,5218,5215,5219,5228,5229,5230,5231,5232,5235,5233,5236,5237,5234,5240,5241,5243,5239,5242,5247,5244,5245,5246,5465,5466,6533,8044,8099,8107,8120,8138,8168,8271,8333,8334,8562,8563,8573,8579,8608,8671,8986,9043,9081,9082,9127,9460,9459,9458,9473,9474,9462,9461,10117,9464,9465,9466,9463,9468,9469,9467,9475,9477,9476,9478,9480,9479,9485,9486,9487,9484,9491,9489,9488,9490,9492,9495,9493,9494,9761,9760,9758,9759,9762,9756,9765,9764,9763,9757,9778,1530,1524,9777,1529,1528,9775,1527,9774,1526,9773,1525,9776,9780,9803,9802,9801,9805,9804,9806,10038,10040,10039,10037,10239,10240,10238,10242,10243,10241) | 0.001 | 1171 |
| 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 (1353,1371,1408,1409,1407,1406,1409,1406,1408,1407,1409,1406,1408,1407,1408,1406,1409,1407,1412,1413,1411,1410,1413,1410,1412,1411,1413,1410,1411,1412,1412,1410,1413,1411,1429,1428,1423,1422,1427,1424,1421,1426,1425,1420,1429,1423,1428,1422,1424,1427,1426,1425,1420,1421,1429,1423,1427,1428,1424,1426,1421,1425,1420,1422,1428,1429,1427,1424,1426,1425,1422,1421,1420,1423,1423,1429,1422,1428,1421,1427,1426,1420,1425,1424,1429,1428,1423,1427,1422,1426,1421,1420,1424,1425,1429,1428,1423,1427,1422,1421,1425,1420,1424,1426,1429,1423,1428,1422,1426,1421,1425,1420,1427,1424,1429,1423,1427,1422,1426,1421,1425,1420,1428,1424,1428,1427,1423,1426,1422,1425,1421,1420,1424,1429,1453,1454,1452,1451,1454,1451,1453,1452,1454,1451,1453,1452,1453,1451,1452,1454,1460,1456,1457,1459,1458,1455,1459,1460,1458,1457,1455,1456,1460,1456,1459,1455,1458,1457,1460,1459,1456,1455,1457,1458,1460,1456,1458,1455,1459,1457,1459,1456,1458,1455,1460,1457,1461,1463,1462,1461,1463,1462,1461,1462,1463,1499,1498,1494,1495,1493,1497,1496,1492,1499,1494,1498,1497,1495,1496,1492,1493,1498,1499,1497,1495,1496,1493,1492,1494,1499,1494,1498,1493,1497,1492,1496,1495,1499,1498,1494,1497,1493,1492,1495,1496,1499,1498,1494,1496,1493,1492,1497,1495,1499,1494,1497,1493,1496,1492,1495,1498,1498,1494,1497,1496,1493,1492,1499,1495,1503,1508,1502,1507,1504,1501,1506,1505,1500,1503,1504,1508,1502,1507,1506,1505,1500,1501,1503,1504,1508,1507,1506,1501,1505,1500,1502,1502,1501,1500,1508,1503,1507,1506,1505,1504,1503,1502,1508,1501,1507,1506,1500,1505,1504,1508,1503,1507,1506,1502,1501,1504,1500,1505,1508,1503,1507,1502,1505,1501,1500,1504,1506,1508,1503,1502,1506,1505,1501,1500,1504,1507,1507,1503,1506,1505,1502,1504,1501,1500,1508,9778,9777,1530,9776,9775,1529,1528,1527,9774,1526,9773,1525,1524,1530,9778,1529,1528,9777,1527,9776,1526,9775,9774,1524,9773,1525,1530,9778,1529,1528,9777,1527,9776,9775,1525,9774,9773,1524,1526,1530,9778,1529,1528,9777,9776,1526,9775,9774,1525,9773,1524,1527,1530,9778,1529,9777,9776,1527,1526,9775,9774,1525,9773,1524,1528,1530,9778,1528,9777,1527,9776,9775,1526,9774,1525,9773,1524,1529,1529,9778,1528,1527,1526,9777,9776,1525,9775,9774,1524,9773,1530,1587,1589,1588,1589,1587,1588,1587,1588,1589,5092,5091,5092,5091,5107,5109,5108,5109,5107,5108,5107,5108,5109,5110,5113,5112,5113,5112,5115,5114,5115,5114,5116,5118,5117,5118,5116,5117,5117,5116,5118,5119,5121,5120,5119,5121,5120,5120,5119,5121,5123,5122,5122,5123,5124,5126,5127,5129,5128,5125,5125,5126,5129,5128,5127,5126,5129,5125,5128,5127,5129,5126,5127,5125,5128,5128,5126,5127,5125,5129,5132,5133,5131,5130,5133,5130,5132,5131,5133,5130,5131,5132,5132,5130,5131,5133,5134,5135,5136,5138,5137,5136,5138,5137,5136,5137,5138,5139,5140,5141,5143,5142,5143,5141,5142,5141,5142,5143,5144,5145,5147,5146,5146,5147,5148,5149,5159,5160,5158,5157,5160,5157,5159,5158,5160,5157,5158,5159,5159,5157,5160,5158,5163,5164,5167,5162,5166,5165,5161,5163,5164,5167,5166,5165,5161,5162,5162,5161,5167,5163,5166,5165,5164,5163,5167,5162,5166,5161,5165,5164,5167,5163,5166,5162,5164,5161,5165,5167,5163,5165,5162,5161,5164,5166,5166,5163,5165,5164,5162,5161,5167,5168,5170,5169,5170,5168,5169,5169,5168,5170,5171,5176,5177,5175,5174,5177,5176,5174,5175,5177,5174,5176,5175,5176,5174,5177,5175,5178,5180,5179,5180,5178,5179,5179,5178,5180,5191,5190,5191,5190,5199,5200,5198,5197,5200,5197,5199,5198,5200,5197,5199,5198,5199,5197,5200,5198,5201,5203,5202,5203,5201,5202,5202,5201,5203,5210,5209,5210,5209,5212,5214,5213,5212,5214,5213,5213,5212,5214,5217,5218,5221,5216,5220,5219,5215,5217,5218,5221,5220,5219,5215,5216,5216,5215,5221,5217,5220,5219,5218,5217,5221,5216,5220,5215,5219,5218,5221,5217,5220,5216,5218,5215,5219,5221,5217,5219,5216,5215,5218,5220,5220,5217,5219,5218,5216,5215,5221,5228,5230,5229,5229,5230,5232,5231,5232,5231,5234,5235,5237,5236,5233,5233,5234,5237,5236,5235,5234,5237,5233,5236,5235,5237,5234,5235,5233,5236,5236,5234,5235,5233,5237,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,5246,5247,5245,5244,5247,5244,5246,5245,5247,5244,5246,5245,5246,5244,5245,5247,5466,5465,5466,5465,6533,8044,8099,8107,8120,8138,8168,8271,8333,8334,8562,8563,8573,8579,8608,8671,8986,9043,9081,9082,9127,9460,9459,9458,9459,9458,9460,9459,9460,9458,9473,9474,9462,10117,9461,10117,9474,9473,9461,9462,9464,9465,9466,9463,9465,9463,9466,9464,9464,9466,9463,9465,9464,9465,9463,9466,9468,9467,9469,9467,9469,9468,9467,9469,9468,9461,9473,9462,10117,9474,9473,9461,9462,10117,9474,9476,9477,9479,9478,9480,9475,9475,9477,9478,9480,9479,9476,9475,9479,9478,9476,9480,9477,9475,9480,9477,9476,9479,9478,9475,9477,9476,9480,9478,9479,9475,9478,9476,9477,9479,9480,9485,9486,9487,9484,9487,9486,9484,9485,9487,9485,9484,9486,9485,9486,9484,9487,9491,9489,9490,9488,9490,9491,9488,9489,9491,9489,9490,9488,9490,9489,9491,9488,9494,9495,9493,9492,9495,9492,9494,9493,9495,9492,9494,9493,9494,9492,9495,9493,9757,9763,9765,9764,9756,9756,9757,9765,9764,9763,9759,9760,9762,9761,9758,9758,9759,9762,9761,9760,9759,9762,9758,9761,9760,9762,9759,9760,9758,9761,9761,9759,9760,9758,9762,9757,9765,9756,9764,9763,9765,9757,9763,9756,9764,9764,9757,9763,9756,9765,9778,1530,1529,9777,1528,9776,9775,1527,1524,9774,1526,1525,9773,9778,1530,9777,1529,9776,1528,1524,9775,1527,1526,1525,9773,9774,9778,1530,9777,1529,1524,9776,1528,1527,1526,9774,1525,9773,9775,9778,1524,1530,9777,1529,1528,1527,9775,1526,9774,1525,9773,9776,9778,1524,1530,1529,1528,9776,1527,9775,1526,9774,1525,9773,9777,9777,9776,9775,9774,9773,1530,9778,1529,1528,1527,1526,1525,1524,9780,9801,9803,9802,9801,9803,9802,9802,9801,9803,9804,9806,9805,9806,9804,9805,9804,9805,9806,10038,10040,10039,10037,10039,10040,10037,10038,10040,10038,10037,10039,10038,10037,10040,10039,9473,9462,9474,9461,10117,10238,10240,10239,10240,10238,10239,10238,10239,10240,10241,10243,10242,10243,10241,10242,10241,10242,10243)
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` = 71 | 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`) | 0.000 | 113 |
| 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 `spv`.`active` = 'Y'
AND `sptc`.`category_id` IN (71)
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.002 | 41 |
| select max(NULLIF(`do_99` *(1)*1, 0)) AS max99, max(NULLIF(`od_25` *(1)*1, 0)) AS max25, 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 (5135,5177,1422,9802,1407,8562,5129,8333,1411,8671,8579,5190,8044,5169,5112,5124,5144,5161,5140,9043,8138,5108,5145,9479,9461,1587,5130,5137,8986,1353,5234,5231,5134,5201,5139,5149,5120,9763,5239,8099,8107,5466,5123,5180,5228,6533,8168,8334,9488,5158,9463,8271,5114,5171,10037,9469,9459,9493,5142,9762,5214,1463,1497,8573,1452,5209,1371,5197,9804,9780,5110,5146,9484,5230,8120,5118,8563,10238,5245,9127,5091,5148,10241,1506,9081,9082,1457,9776,5215,8608) | 0.000 | 1 |
| select MIN(NULLIF(`do_99`*(1)*1, 0)) AS min99, MIN(NULLIF(`od_25`*(1)*1, 0)) AS min25, 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 (5135,5177,1422,9802,1407,8562,5129,8333,1411,8671,8579,5190,8044,5169,5112,5124,5144,5161,5140,9043,8138,5108,5145,9479,9461,1587,5130,5137,8986,1353,5234,5231,5134,5201,5139,5149,5120,9763,5239,8099,8107,5466,5123,5180,5228,6533,8168,8334,9488,5158,9463,8271,5114,5171,10037,9469,9459,9493,5142,9762,5214,1463,1497,8573,1452,5209,1371,5197,9804,9780,5110,5146,9484,5230,8120,5118,8563,10238,5245,9127,5091,5148,10241,1506,9081,9082,1457,9776,5215,8608) | 0.000 | 1 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| 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, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '9776'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '9776' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 13 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1529' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1524' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1525' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9775' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1526' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9776' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1530' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9774' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1527' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9778' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9773' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1528' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9777' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '8608'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '8608' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '8608' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5091'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5091' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 2 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5092' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5091' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5110'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5110' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5110' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5118'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5118' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 3 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5118' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5116' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5142'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5142' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 3 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5141' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5143' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5142' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5146'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5146' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 2 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5147' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5146' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5148'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5148' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5148' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5197'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5197' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 4 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5200' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5197' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5198' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5199' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5209'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5209' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 2 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5210' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5209' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5214'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5214' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 3 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5213' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5214' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5212' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5215'
GROUP BY srp.product_id
ORDER BY quantity DESC | 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, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
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)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5215' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY 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, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 7 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5215' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5216' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5218' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5221' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5219' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5217' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5220' | 0.000 | 1 |
| SELECT `name`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
| SELECT `description`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'footer_text'
LIMIT 0, 1 | 0.000 | 1 |
| Total: 124 | 0.022 | 3934 |
(+48) 22 812 90 60
