| Queries | Time | Rows |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.001 | 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-15'
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` = '30' | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '1' | 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` = 30 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (1)
ORDER BY `level` ASC | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '30'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| SELECT s.*, COALESCE(s.sum_quantity, 0) AS sum_quantity, COALESCE(s.sum_quantity, 0) AS sum_available_now FROM (Select * from( SELECT sptv.variant_id, p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo, p.sum_quantity_mag1 AS sum_quantity, `magazyn`.`quantity` AS `available_now` FROM shop_products AS `p`
inner JOIN shop_product_to_variant AS `sptv` ON (`sptv`.`product_id` = `p`.`id_product` AND `sptv`.`variant_id` = `p`.`best_variant_id` AND `sptv`.`active` = 'Y')
left JOIN shop_products_images AS `pi` ON (`pi`.`product_id` = `p`.`id_product` AND `pi`.`mainimage` = 'Y')
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `p`.`id_product`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_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 shop_products_to_categories AS `ptc` ON (`ptc`.`product_id` = `p`.`id_product`) WHERE p.active = 'Y' AND p.best_variant_id IS NOT NULL AND p.id_product IN (3553,5011,4957,5004,7823,4966,712,4923,9943,7832,4885,5053,4888,1841,7221,4956,741,8085,8319,3447,5015,7826,7825,5027,3928,8599,8148,4988,8633,7028,494,699,3044,5048,4899,4521,8272,74,8190,8074,8556,8683,8560,8558,6464,1839,5038,1843,7827,742,4955,7010,7017,8702,7011,7007,8086,769,8703,7216,8149,7009,5036,8078,3589,4397,4932,1840,719,6238,8337,8080,3931,8172,8102,8079,8076,9241,8090,8682,8189,9395,8978,3694,8087,8150,3043,3697,9217,61,5265,3591,9457,8137,3686,715,6463,5070,8701,7008,3042,443,8198,8089,69,3711,3040,4919,6236,9216,8082,8561,8077,3448,3929,7220,8320,4653,4992,4999,5071,721,3544,4974,3687,6597,7834,8704,8075,3041,8188,3446,8555,8557,8559,4984,3580,3577,5044,8136,7288,3533,8081,704,5069,448,5054,3552,9973,4943,8125,8126,4902,8083,444,5068,4942,7021,549,747,9394,8084,8072) GROUP BY p.id_product_ps ) as s order by available_now DESC, mainproduct DESC, product_name ASC) AS s order by sum_quantity DESC LIMIT 144 ,12 | 0.012 | 12 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (3553,5011,4957,5004,7823,4966,712,4923,9943,7832,4885,5053,4888,1841,7221,4956,741,8085,8319,3447,5015,7826,7825,5027,3928,8599,8148,4988,8633,7028,494,699,3044,5048,4899,4521,8272,74,8190,8074,8556,8683,8560,8558,6464,1839,5038,1843,7827,742,4955,7010,7017,8702,7011,7007,8086,769,8703,7216,8149,7009,5036,8078,3589,4397,4932,1840,719,6238,8337,8080,3931,8172,8102,8079,8076,9241,8090,8682,8189,9395,8978,3694,8087,8150,3043,3697,9217,61,5265,3591,9457,8137,3686,715,6463,5070,8701,7008,3042,443,8198,8089,69,3711,3040,4919,6236,9216,8082,8561,8077,3448,3929,7220,8320,4653,4992,4999,5071,721,3544,4974,3687,6597,7834,8704,8075,3041,8188,3446,8555,8557,8559,4984,3580,3577,5044,8136,7288,3533,8081,704,5069,448,5054,3552,9973,4943,8125,8126,4902,8083,444,5068,4942,7021,549,747,9394,8084,8072) | 0.001 | 368 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (63,67,66,62,64,65,61,70,71,73,72,69,75,74,443,444,446,450,449,448,447,493,494,492,549,703,702,698,700,701,699,704,713,712,716,715,714,718,717,719,722,723,726,720,725,724,721,741,742,747,769,1839,1840,1841,1843,3040,3041,3042,3043,3044,3446,3447,3448,3533,3534,3532,3545,3543,3548,3549,3547,3542,3546,3541,3544,3551,3552,3550,3553,3577,3580,3589,3592,3591,3590,3685,3684,3686,3688,3687,3689,3693,3692,3690,3694,3691,3695,3699,3697,3698,3696,3711,3928,3930,3929,3931,3932,4397,4521,4652,4649,4651,4648,4650,4653,4886,4882,4884,4881,4883,4885,4893,4889,4892,4890,4888,4891,4900,4896,4898,4895,4897,4899,4905,4903,4902,4904,4917,4921,4920,4919,4918,4923,4924,4935,4933,4932,4934,4941,4938,4940,4939,4942,4945,4949,4948,4944,4946,4943,4947,4954,4953,4952,4955,4956,4959,4963,4962,4958,4960,4957,4961,4965,4969,4964,4968,4967,4966,4981,4976,4980,4975,4979,4977,4974,4978,4982,4985,4983,4984,4986,4990,4989,4988,4987,4994,4991,4993,4992,4996,5000,4998,4995,4997,4999,5002,5007,5001,5006,5005,5004,5003,5009,5014,5008,5013,5012,5011,5010,5016,5017,5019,5015,5018,5028,5029,5032,5026,5031,5030,5027,5036,5038,5039,5042,5046,5044,5045,5043,5049,5047,5050,5051,5048,5053,5055,5056,5058,5057,5054,5068,5069,5070,5071,5265,6236,6238,6463,6467,6465,6464,6466,6599,6603,6602,6598,6600,6601,6597,7007,7008,7009,7010,7011,7016,7015,7017,7022,7023,7025,7021,7024,7027,7028,7026,7216,7219,7218,7217,7220,7221,7288,7824,7823,7825,7826,7830,7828,7829,7827,7832,7834,7835,7833,8072,8074,8075,8076,8077,8078,8079,8080,8081,8082,8083,8084,8085,8086,8087,8089,8090,8102,8125,8126,8136,8137,8148,8149,8150,8172,8188,8189,8190,8198,8272,8319,8320,8337,8555,8556,8557,8558,8559,8560,8561,8599,8633,8682,8683,8701,8702,8703,8704,8978,9215,9216,9217,9242,9241,9240,9394,9395,9457,9943,8758,9991,9974,9973) | 0.002 | 1477 |
| 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 (63,64,67,62,66,65,61,63,64,67,66,65,61,62,62,61,67,63,66,65,64,63,67,62,66,61,65,64,67,63,66,62,64,61,65,67,63,65,62,61,64,66,66,63,65,64,62,61,67,70,71,73,72,69,69,70,73,72,71,70,73,69,72,71,73,70,71,69,72,72,70,71,69,73,75,74,74,75,443,444,447,448,450,449,446,446,447,450,449,448,447,450,446,449,448,450,447,448,446,449,449,447,448,446,450,492,494,493,494,492,493,492,493,494,549,703,699,700,702,701,698,702,703,701,700,698,699,703,699,702,698,701,700,703,702,699,698,700,701,703,699,701,698,700,702,702,701,699,698,700,703,704,713,712,712,713,714,716,715,716,714,715,714,715,716,717,719,718,717,719,718,718,717,719,722,723,726,721,725,724,720,722,723,726,725,724,720,721,721,720,726,722,725,724,723,722,726,721,725,720,724,723,726,722,725,721,723,720,724,726,722,724,721,720,723,725,725,722,724,723,721,720,726,741,742,747,769,1839,1840,1841,1843,3040,3041,3042,3043,3044,3446,3447,3448,3532,3534,3533,3534,3532,3533,3532,3533,3534,3544,3549,3543,3548,3545,3542,3547,3546,3541,3544,3545,3549,3543,3548,3547,3546,3541,3542,3544,3545,3549,3548,3547,3542,3546,3541,3543,3543,3542,3541,3549,3544,3548,3547,3546,3545,3544,3543,3549,3542,3548,3547,3541,3546,3545,3549,3544,3548,3547,3543,3542,3545,3541,3546,3549,3544,3548,3543,3546,3542,3541,3545,3547,3549,3544,3547,3543,3546,3542,3541,3545,3548,3548,3544,3547,3546,3543,3545,3542,3541,3549,3550,3552,3551,3552,3550,3551,3550,3551,3552,3553,3577,3580,3589,3590,3592,3591,3592,3590,3591,3591,3590,3592,3684,3686,3685,3684,3686,3685,3684,3685,3686,3687,3689,3688,3689,3687,3688,3688,3687,3689,3691,3692,3694,3693,3690,3690,3691,3694,3693,3692,3691,3694,3690,3693,3692,3694,3691,3692,3690,3693,3693,3691,3692,3690,3694,3696,3697,3699,3698,3695,3695,3696,3699,3698,3697,3696,3699,3695,3698,3697,3699,3696,3697,3695,3698,3698,3696,3697,3695,3699,3711,3928,3930,3929,3929,3930,3932,3931,3932,3931,4397,4521,4653,4649,4650,4652,4651,4648,4652,4653,4651,4650,4648,4649,4653,4649,4652,4648,4651,4650,4653,4652,4649,4648,4651,4650,4653,4649,4651,4648,4652,4650,4652,4651,4649,4648,4653,4650,4886,4882,4883,4885,4884,4881,4885,4886,4884,4883,4881,4882,4886,4882,4885,4881,4884,4883,4886,4885,4882,4881,4884,4883,4886,4882,4884,4881,4883,4885,4885,4882,4884,4881,4883,4886,4893,4889,4890,4892,4891,4888,4892,4893,4891,4890,4888,4889,4893,4889,4892,4888,4891,4890,4893,4892,4889,4888,4891,4890,4893,4889,4891,4888,4890,4892,4892,4889,4891,4888,4890,4893,4900,4896,4897,4899,4898,4895,4899,4900,4898,4897,4895,4896,4900,4896,4899,4895,4898,4897,4900,4899,4896,4895,4898,4897,4900,4896,4898,4895,4897,4899,4899,4898,4896,4895,4900,4897,4904,4905,4903,4902,4905,4904,4902,4903,4905,4902,4904,4903,4904,4902,4905,4903,4918,4919,4921,4920,4917,4917,4918,4921,4920,4919,4918,4921,4917,4920,4919,4921,4918,4919,4917,4920,4920,4918,4919,4917,4921,4924,4923,4923,4924,4934,4935,4933,4932,4935,4934,4932,4933,4935,4932,4934,4933,4934,4932,4935,4933,4939,4940,4942,4941,4938,4938,4939,4942,4941,4940,4939,4942,4938,4941,4940,4942,4939,4940,4938,4941,4941,4939,4940,4938,4942,4945,4946,4949,4944,4948,4947,4943,4945,4946,4949,4948,4947,4943,4944,4944,4943,4949,4945,4948,4947,4946,4945,4949,4944,4948,4943,4947,4946,4949,4945,4948,4944,4946,4943,4947,4949,4945,4947,4944,4943,4946,4948,4948,4947,4945,4946,4944,4943,4949,4954,4955,4953,4952,4955,4954,4952,4953,4955,4952,4953,4954,4954,4952,4953,4955,4956,4959,4960,4963,4958,4962,4961,4957,4959,4960,4963,4962,4961,4957,4958,4958,4957,4963,4959,4962,4961,4960,4959,4963,4958,4962,4957,4961,4960,4963,4959,4962,4958,4960,4957,4961,4963,4959,4958,4961,4957,4960,4962,4962,4959,4961,4960,4958,4957,4963,4969,4965,4966,4968,4967,4964,4968,4969,4967,4966,4964,4965,4969,4965,4968,4964,4967,4966,4969,4968,4965,4964,4967,4966,4969,4965,4967,4964,4968,4966,4968,4967,4965,4964,4969,4966,4981,4980,4976,4977,4975,4979,4978,4974,4981,4976,4980,4979,4977,4978,4974,4975,4980,4981,4979,4977,4978,4975,4974,4976,4981,4976,4975,4980,4979,4974,4978,4977,4981,4980,4976,4979,4975,4974,4977,4978,4981,4980,4976,4975,4978,4974,4979,4977,4981,4976,4979,4975,4978,4974,4977,4980,4980,4979,4976,4978,4975,4974,4977,4981,4984,4985,4983,4982,4985,4982,4984,4983,4985,4982,4984,4983,4984,4982,4985,4983,4987,4988,4990,4989,4986,4986,4987,4990,4989,4988,4987,4990,4986,4989,4988,4990,4987,4988,4986,4989,4989,4987,4988,4986,4990,4993,4994,4992,4991,4994,4993,4991,4992,4994,4991,4993,4992,4993,4991,4992,4994,5000,4996,4997,4999,4998,4995,4999,5000,4998,4997,4995,4996,5000,4996,4999,4995,4998,4997,5000,4999,4996,4995,4998,4997,5000,4996,4998,4995,4997,4999,4999,4996,4998,4995,4997,5000,5003,5004,5007,5002,5006,5005,5001,5003,5004,5007,5006,5005,5001,5002,5002,5001,5007,5003,5006,5005,5004,5003,5007,5002,5006,5001,5005,5004,5007,5003,5006,5002,5004,5001,5005,5007,5003,5005,5002,5001,5004,5006,5006,5003,5005,5004,5002,5001,5007,5010,5011,5014,5009,5013,5012,5008,5010,5011,5014,5013,5012,5008,5009,5009,5008,5014,5010,5013,5012,5011,5010,5014,5009,5013,5008,5012,5011,5014,5010,5013,5009,5011,5008,5012,5014,5010,5012,5009,5008,5011,5013,5013,5010,5012,5011,5009,5008,5014,5016,5017,5019,5018,5015,5015,5016,5019,5018,5017,5016,5019,5015,5018,5017,5019,5016,5017,5015,5018,5018,5016,5017,5015,5019,5028,5029,5032,5027,5031,5030,5026,5028,5029,5032,5031,5030,5026,5027,5027,5026,5032,5028,5031,5030,5029,5028,5032,5027,5031,5026,5030,5029,5032,5028,5031,5027,5029,5026,5030,5032,5028,5030,5027,5026,5029,5031,5031,5028,5030,5029,5027,5026,5032,5036,5039,5038,5039,5038,5043,5044,5046,5045,5042,5042,5043,5046,5045,5044,5043,5046,5042,5045,5044,5046,5043,5044,5042,5045,5045,5043,5044,5042,5046,5048,5049,5051,5050,5047,5047,5048,5051,5050,5049,5048,5051,5047,5050,5049,5051,5048,5049,5047,5050,5050,5048,5049,5047,5051,5053,5055,5056,5058,5057,5054,5054,5055,5058,5057,5056,5055,5058,5054,5057,5056,5058,5055,5056,5054,5057,5057,5055,5056,5054,5058,5068,5069,5070,5071,5265,6236,6238,6463,6466,6467,6465,6464,6467,6466,6464,6465,6467,6464,6466,6465,6466,6464,6467,6465,6599,6600,6603,6598,6602,6601,6597,6599,6600,6603,6602,6601,6597,6598,6598,6597,6603,6599,6602,6601,6600,6599,6603,6598,6602,6597,6601,6600,6603,6599,6602,6598,6600,6597,6601,6603,6599,6598,6601,6597,6600,6602,6602,6599,6601,6600,6598,6597,6603,7007,7008,7009,7010,7011,7015,7017,7016,7017,7015,7016,7015,7016,7017,7022,7023,7025,7024,7021,7021,7022,7025,7024,7023,7022,7025,7021,7024,7023,7025,7022,7023,7021,7024,7024,7022,7023,7021,7025,7026,7028,7027,7028,7026,7027,7027,7026,7028,7216,7219,7220,7218,7217,7220,7217,7219,7218,7220,7217,7219,7218,7219,7217,7220,7218,7221,7288,7824,7823,7823,7824,7825,7826,7829,7830,7828,7827,7830,7827,7829,7828,7830,7827,7828,7829,7829,7827,7830,7828,7832,7833,7835,7834,7835,7833,7834,7833,7834,7835,8072,8074,8075,8076,8077,8078,8079,8080,8081,8082,8083,8084,8085,8086,8087,8089,8090,8102,8125,8126,8136,8137,8148,8149,8150,8172,8188,8189,8190,8198,8272,8319,8320,8337,8555,8556,8557,8558,8559,8560,8561,8599,8633,8682,8683,8701,8702,8703,8704,9974,9991,9973,8978,9216,9215,9215,9216,9217,9240,9242,9241,9242,9240,9241,9241,9240,9242,9394,9395,9457,9943,9991,8758,9974,9973,9991,8758,9973,9974,9974,8758,9973,9991)
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` = 30 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 1 | 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 (30)
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.003 | 54 |
| 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 (3553,5011,4957,5004,7823,4966,712,4923,9943,7832,4885,5053,4888,1841,7221,4956,741,8085,8319,3447,5015,7826,7825,5027,3928,8599,8148,4988,8633,7028,494,699,3044,5048,4899,4521,8272,74,8190,8074,8556,8683,8560,8558,6464,1839,5038,1843,7827,742,4955,7010,7017,8702,7011,7007,8086,769,8703,7216,8149,7009,5036,8078,3589,4397,4932,1840,719,6238,8337,8080,3931,8172,8102,8079,8076,9241,8090,8682,8189,9395,8978,3694,8087,8150,3043,3697,9217,61,5265,3591,9457,8137,3686,715,6463,5070,8701,7008,3042,443,8198,8089,69,3711,3040,4919,6236,9216,8082,8561,8077,3448,3929,7220,8320,4653,4992,4999,5071,721,3544,4974,3687,6597,7834,8704,8075,3041,8188,3446,8555,8557,8559,4984,3580,3577,5044,8136,7288,3533,8081,704,5069,448,5054,3552,9973,4943,8125,8126,4902,8083,444,5068,4942,7021,549,747,9394,8084,8072) | 0.001 | 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 (3553,5011,4957,5004,7823,4966,712,4923,9943,7832,4885,5053,4888,1841,7221,4956,741,8085,8319,3447,5015,7826,7825,5027,3928,8599,8148,4988,8633,7028,494,699,3044,5048,4899,4521,8272,74,8190,8074,8556,8683,8560,8558,6464,1839,5038,1843,7827,742,4955,7010,7017,8702,7011,7007,8086,769,8703,7216,8149,7009,5036,8078,3589,4397,4932,1840,719,6238,8337,8080,3931,8172,8102,8079,8076,9241,8090,8682,8189,9395,8978,3694,8087,8150,3043,3697,9217,61,5265,3591,9457,8137,3686,715,6463,5070,8701,7008,3042,443,8198,8089,69,3711,3040,4919,6236,9216,8082,8561,8077,3448,3929,7220,8320,4653,4992,4999,5071,721,3544,4974,3687,6597,7834,8704,8075,3041,8188,3446,8555,8557,8559,4984,3580,3577,5044,8136,7288,3533,8081,704,5069,448,5054,3552,9973,4943,8125,8126,4902,8083,444,5068,4942,7021,549,747,9394,8084,8072) | 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 = '5044'
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 = '5044' 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 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5043' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5045' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5042' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5046' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5044' | 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 = '5054'
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 = '5054' 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 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5054' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5055' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5058' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5056' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5057' | 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 = '5068'
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 = '5068' 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` = '5068' | 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 = '5069'
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 = '5069' 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` = '5069' | 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 = '5071'
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 = '5071' 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` = '5071' | 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 = '8125'
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 = '8125' 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 | 0 |
| 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 = '8126'
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 = '8126' 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 | 0 |
| 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 = '8136'
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 = '8136' 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` = '8136' | 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 = '6597'
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 = '6597' 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` = '6602' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6599' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6600' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6603' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6598' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6601' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6597' | 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 = '8188'
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 = '8188' 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` = '8188' | 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 = '7021'
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 = '7021' 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 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7024' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7022' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7025' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7021' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7023' | 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 = '7288'
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 = '7288' 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` = '7288' | 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: 110 | 0.035 | 4348 |
(+48) 22 812 90 60
