| 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` = '12' | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '11' | 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` = 12 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (11)
ORDER BY `level` ASC | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '12'
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 (3442,4923,9943,7832,4885,5053,7221,8743,4956,8085,7229,9946,8206,7826,3928,5051,7294,7802,8633,7028,7806,7238,4931,7202,5052,4897,74,8074,8556,9125,8543,8545,8541,7029,8560,8558,630,9192,7290,5038,7019,9548,9337,7010,7015,7011,7007,8086,7216,7241,7773,7009,5036,7783,7810,8078,7240,4397,4932,7814,7274,4398,8080,9554,3931,7272,3930,8102,8079,8076,686,4648,7255,9146,9395,8978,3694,3443,8087,7789,3697,9217,61,5265,7197,9567,9457,9559,8137,3686,7203,755,9549,7774,6463,5070,7008,7192,7822,644,7251,69,3040,9569,7212,6236,9216,4941,8082,8561,3448,620,9568,7220,7796,5266,7263,7265,7247,4908,9240,8825,8829,8531,8537,8551,8838,8839,8840,1302,8550,8845,8843,8844,1308,3687,7256,9527,6597,7834,8704,8075,3041,3446,8555,8557,8559,7237,3577,5044,8136,7288,4911,8081,5069,10005,7289,4880,9812,7225,7286,5058,4945,9807,6204,9542,7196,9570,8125,8126,7793,4902,8083,9523,4887,5068,8744,8191,549,7777,651,7278,9394,8084,8072,8720) 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 12 ,12 | 0.011 | 12 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (3442,4923,9943,7832,4885,5053,7221,8743,4956,8085,7229,9946,8206,7826,3928,5051,7294,7802,8633,7028,7806,7238,4931,7202,5052,4897,74,8074,8556,9125,8543,8545,8541,7029,8560,8558,630,9192,7290,5038,7019,9548,9337,7010,7015,7011,7007,8086,7216,7241,7773,7009,5036,7783,7810,8078,7240,4397,4932,7814,7274,4398,8080,9554,3931,7272,3930,8102,8079,8076,686,4648,7255,9146,9395,8978,3694,3443,8087,7789,3697,9217,61,5265,7197,9567,9457,9559,8137,3686,7203,755,9549,7774,6463,5070,7008,7192,7822,644,7251,69,3040,9569,7212,6236,9216,4941,8082,8561,3448,620,9568,7220,7796,5266,7263,7265,7247,4908,9240,8825,8829,8531,8537,8551,8838,8839,8840,1302,8550,8845,8843,8844,1308,3687,7256,9527,6597,7834,8704,8075,3041,3446,8555,8557,8559,7237,3577,5044,8136,7288,4911,8081,5069,10005,7289,4880,9812,7225,7286,5058,4945,9807,6204,9542,7196,9570,8125,8126,7793,4902,8083,9523,4887,5068,8744,8191,549,7777,651,7278,9394,8084,8072,8720) | 0.001 | 476 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (63,67,66,62,64,65,61,70,71,73,72,69,75,74,549,619,620,618,629,628,626,630,627,643,644,655,654,650,652,653,651,685,686,758,756,757,755,1302,1308,3040,3041,3441,3442,3443,3446,3448,3577,3685,3684,3686,3688,3687,3689,3693,3692,3690,3694,3691,3695,3699,3697,3698,3696,3928,3929,3930,3931,3932,4397,4399,4400,4402,4401,4398,4653,4649,4652,4650,4648,4651,4880,4886,4882,4884,4881,4883,4885,4887,4896,4900,4895,4899,4898,4897,4905,4903,4902,4904,4906,4910,4909,4908,4907,4916,4912,4915,4913,4914,4911,4923,4924,4930,4929,4927,4928,4926,4931,4935,4933,4932,4934,4942,4938,4940,4941,4939,4946,4944,4948,4949,4947,4943,4945,4956,5036,5038,5039,5042,5046,5044,5045,5043,5050,5049,5047,5048,5051,5052,5053,5057,5056,5054,5058,5055,5068,5069,5070,5265,5266,6205,6204,6236,6463,6599,6603,6602,6598,6600,6601,6597,7007,7008,7009,7010,7011,7016,7017,7015,7020,7019,7018,7027,7028,7026,7029,7192,7195,7194,7193,7196,7198,7199,7201,7200,7197,7202,7203,7213,7214,7211,7215,7212,7216,7219,7218,7217,7220,7221,7225,7230,7231,7233,7232,7229,7236,7234,7235,7237,7238,7239,7240,7242,7243,7245,7241,7244,7248,7249,7246,7250,7247,7254,7252,7253,7251,7255,7257,7258,7260,7256,7259,7261,7264,7262,7263,7267,7271,7270,7266,7268,7269,7265,7272,7275,7276,7273,7277,7274,7279,7280,7282,7281,7278,7287,7283,7285,7284,7286,7288,7289,7291,7292,7290,7298,7297,7293,7295,7296,7294,7773,7775,7774,7776,7778,7779,7781,7777,7780,7787,7786,7782,7784,7785,7783,7791,7788,7790,7789,7792,7795,7794,7793,7801,7797,7800,7798,7796,7799,7805,7803,7804,7802,7809,7807,7808,7806,7813,7811,7810,7812,7819,7815,7818,7816,7814,7817,7821,7822,7820,7826,7832,7834,7835,7833,8072,8074,8075,8076,8078,8079,8080,8081,8082,8083,8084,8085,8086,8087,8102,8125,8126,8136,8137,8191,8206,8531,8537,8541,8543,8545,8550,8551,8555,8556,8557,8558,8559,8560,8561,8633,8704,8720,8743,8744,8825,8528,8830,8829,8838,8839,8840,8843,8844,8842,8841,8845,8978,9125,9333,9334,9145,9335,9146,9191,9190,9189,9192,9215,9216,9217,9241,9240,9242,9344,9343,9339,9338,9342,9341,9336,9340,9337,9394,9395,9457,9526,9524,9525,9523,9532,9528,9531,9529,9527,9530,9544,9539,9543,9540,9541,9542,9547,9546,9533,9548,9545,9550,9551,9553,9552,9549,9555,9556,9558,9557,9554,9566,9561,9565,9560,9564,9562,9563,9559,9567,9568,9569,9581,9571,9574,9572,9573,9570,9808,9807,9809,9811,9812,9810,9943,9947,9948,9945,9949,9946,10005) | 0.002 | 1948 |
| 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,549,618,620,619,618,620,619,618,619,620,627,628,630,629,626,626,627,630,629,628,627,630,626,629,628,630,627,628,626,629,629,627,628,626,630,644,643,644,643,655,651,652,654,653,650,654,655,653,652,650,651,655,651,654,650,653,652,655,654,651,650,653,652,655,651,653,650,652,654,654,651,653,650,652,655,686,685,686,685,757,758,756,755,758,757,755,756,758,755,756,757,757,755,756,758,1302,1308,3040,3041,3442,3441,3441,3442,3443,3446,3448,3577,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,3928,3930,3929,3929,3930,3932,3931,3932,3931,4397,4399,4400,4402,4401,4398,4398,4399,4402,4401,4400,4399,4402,4398,4401,4400,4402,4399,4400,4398,4401,4401,4399,4400,4398,4402,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,4880,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,4887,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,4907,4908,4910,4909,4906,4906,4907,4910,4909,4908,4907,4910,4906,4909,4908,4910,4907,4908,4906,4909,4909,4907,4908,4906,4910,4916,4912,4913,4915,4914,4911,4915,4916,4914,4913,4911,4912,4916,4912,4915,4911,4914,4913,4916,4915,4912,4911,4914,4913,4916,4912,4914,4911,4913,4915,4915,4912,4914,4911,4916,4913,4924,4923,4923,4924,4931,4927,4928,4930,4929,4926,4930,4931,4929,4928,4926,4927,4931,4927,4930,4926,4929,4928,4931,4930,4927,4926,4928,4929,4931,4927,4929,4926,4930,4928,4930,4929,4927,4926,4928,4931,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,4956,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,5052,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,5265,5266,6205,6204,6204,6205,6236,6463,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,7018,7020,7019,7020,7018,7019,7019,7018,7020,7026,7028,7027,7028,7026,7027,7027,7026,7028,7029,7192,7195,7196,7194,7193,7196,7195,7193,7194,7196,7193,7194,7195,7195,7193,7196,7194,7198,7199,7201,7200,7197,7197,7198,7201,7200,7199,7198,7201,7197,7200,7199,7201,7198,7199,7197,7200,7200,7198,7199,7197,7201,7202,7203,7212,7213,7215,7214,7211,7211,7212,7215,7214,7213,7212,7215,7211,7214,7213,7215,7212,7213,7211,7214,7214,7212,7213,7211,7215,7216,7219,7220,7218,7217,7220,7217,7219,7218,7220,7217,7219,7218,7219,7217,7220,7218,7221,7225,7230,7231,7233,7232,7229,7229,7230,7233,7232,7231,7230,7233,7229,7232,7231,7233,7230,7231,7229,7232,7232,7230,7231,7229,7233,7236,7237,7235,7234,7237,7236,7234,7235,7237,7234,7236,7235,7236,7234,7237,7235,7239,7238,7238,7239,7240,7242,7243,7245,7244,7241,7241,7242,7245,7244,7243,7242,7245,7241,7244,7243,7245,7242,7243,7241,7244,7244,7242,7243,7241,7245,7247,7248,7250,7249,7246,7246,7247,7250,7249,7248,7247,7250,7246,7249,7248,7250,7247,7248,7246,7249,7249,7247,7248,7246,7250,7253,7254,7252,7251,7254,7251,7253,7252,7254,7251,7252,7253,7253,7251,7252,7254,7255,7257,7258,7260,7259,7256,7256,7257,7260,7259,7258,7257,7260,7256,7259,7258,7260,7257,7258,7256,7259,7259,7257,7258,7256,7260,7263,7264,7262,7261,7264,7263,7261,7262,7264,7261,7263,7262,7263,7261,7264,7262,7267,7268,7271,7266,7270,7269,7265,7267,7268,7271,7270,7269,7265,7266,7266,7265,7271,7267,7270,7269,7268,7267,7271,7266,7270,7265,7269,7268,7271,7267,7270,7266,7268,7265,7269,7271,7267,7266,7269,7265,7268,7270,7270,7269,7267,7268,7266,7265,7271,7272,7274,7275,7277,7276,7273,7273,7274,7277,7276,7275,7274,7277,7273,7276,7275,7277,7274,7275,7273,7276,7276,7274,7275,7273,7277,7279,7280,7282,7281,7278,7278,7279,7282,7281,7280,7279,7282,7278,7281,7280,7282,7279,7280,7278,7281,7281,7279,7280,7278,7282,7284,7285,7287,7286,7283,7283,7284,7287,7286,7285,7284,7287,7283,7286,7285,7287,7284,7285,7283,7286,7286,7284,7285,7283,7287,7288,7289,7290,7292,7291,7292,7290,7291,7290,7291,7292,7298,7294,7295,7297,7296,7293,7297,7298,7296,7295,7293,7294,7298,7294,7297,7293,7296,7295,7298,7297,7294,7293,7296,7295,7298,7294,7296,7293,7295,7297,7297,7294,7296,7293,7298,7295,7773,7774,7776,7775,7776,7774,7775,7775,7774,7776,7778,7779,7781,7780,7777,7777,7778,7781,7780,7779,7778,7781,7777,7780,7779,7781,7778,7779,7777,7780,7780,7778,7779,7777,7781,7787,7783,7784,7786,7785,7782,7786,7787,7785,7784,7782,7783,7787,7783,7786,7782,7785,7784,7787,7786,7783,7782,7785,7784,7787,7783,7785,7782,7784,7786,7786,7785,7783,7782,7784,7787,7790,7791,7789,7788,7791,7790,7788,7789,7791,7788,7789,7790,7790,7788,7789,7791,7794,7795,7793,7792,7795,7794,7792,7793,7795,7792,7793,7794,7794,7792,7793,7795,7801,7797,7798,7800,7799,7796,7800,7801,7799,7798,7796,7797,7801,7797,7800,7796,7799,7798,7801,7800,7797,7796,7798,7799,7801,7797,7799,7796,7800,7798,7800,7797,7799,7796,7798,7801,7804,7805,7803,7802,7805,7804,7802,7803,7805,7802,7803,7804,7804,7802,7805,7803,7808,7809,7807,7806,7809,7808,7806,7807,7809,7806,7807,7808,7808,7806,7809,7807,7812,7813,7811,7810,7813,7810,7812,7811,7813,7810,7811,7812,7812,7810,7813,7811,7819,7815,7816,7818,7817,7814,7818,7819,7817,7816,7814,7815,7819,7815,7818,7814,7817,7816,7819,7818,7815,7814,7816,7817,7819,7815,7817,7814,7816,7818,7818,7815,7817,7814,7816,7819,7820,7822,7821,7822,7820,7821,7820,7821,7822,7826,7832,7833,7835,7834,7835,7833,7834,7833,7834,7835,8072,8074,8075,8076,8078,8079,8080,8081,8082,8083,8084,8085,8086,8087,8102,8125,8126,8136,8137,8191,8206,8829,8830,8528,8531,8537,8541,8543,8545,8550,8551,8555,8556,8557,8558,8559,8560,8561,8633,8704,8720,8743,8744,8825,8829,8528,8830,8829,8528,8830,8838,8839,8840,8841,8845,8842,8841,8845,8842,8843,8844,8841,8842,8845,8978,9125,9146,9333,9335,9334,9145,9145,9335,9146,9334,9333,9191,9192,9190,9189,9192,9191,9189,9190,9192,9189,9190,9191,9191,9189,9190,9192,9216,9215,9215,9216,9217,9240,9242,9241,9242,9240,9241,9241,9240,9242,9146,9335,9145,9333,9334,9335,9146,9333,9145,9334,9334,9146,9333,9145,9335,9340,9344,9343,9339,9338,9342,9337,9341,9336,9340,9344,9339,9343,9338,9342,9341,9336,9337,9339,9343,9341,9337,9336,9338,9340,9344,9338,9337,9342,9336,9343,9341,9339,9343,9338,9340,9341,9337,9339,9336,9343,9339,9344,9338,9342,9337,9340,9336,9341,9343,9339,9337,9340,9338,9342,9341,9336,9339,9344,9338,9342,9341,9337,9336,9340,9343,9339,9337,9343,9336,9341,9342,9340,9338,9344,9394,9395,9457,9525,9526,9524,9523,9526,9523,9525,9524,9526,9523,9524,9525,9525,9523,9524,9526,9532,9528,9529,9531,9530,9527,9531,9532,9530,9529,9527,9528,9532,9528,9531,9527,9530,9529,9532,9531,9528,9527,9529,9530,9532,9528,9530,9527,9531,9529,9531,9528,9530,9527,9532,9529,9545,9546,9548,9547,9533,9543,9544,9542,9541,9540,9539,9544,9541,9543,9542,9539,9540,9544,9539,9543,9540,9542,9541,9544,9543,9539,9540,9541,9542,9544,9539,9542,9540,9541,9543,9543,9542,9539,9540,9541,9544,9533,9545,9548,9547,9546,9545,9548,9533,9547,9546,9548,9545,9546,9533,9547,9547,9545,9546,9533,9548,9550,9551,9553,9552,9549,9549,9550,9553,9552,9551,9550,9553,9549,9552,9551,9553,9550,9551,9549,9552,9552,9550,9551,9549,9553,9555,9556,9558,9557,9554,9554,9555,9558,9557,9556,9555,9558,9554,9557,9556,9558,9555,9556,9554,9557,9557,9555,9556,9554,9558,9566,9565,9561,9562,9560,9564,9563,9559,9566,9561,9565,9564,9562,9563,9559,9560,9565,9566,9564,9562,9563,9560,9559,9561,9566,9561,9560,9565,9564,9559,9563,9562,9566,9565,9561,9564,9560,9559,9563,9562,9566,9565,9561,9560,9563,9559,9562,9564,9566,9561,9564,9560,9563,9559,9565,9562,9565,9564,9561,9563,9560,9559,9562,9566,9567,9568,9569,9581,9571,9572,9574,9573,9570,9574,9581,9573,9572,9570,9571,9581,9571,9574,9570,9573,9572,9581,9574,9571,9570,9572,9573,9581,9571,9573,9570,9572,9574,9574,9571,9573,9570,9581,9572,9807,9809,9808,9809,9807,9808,9807,9808,9809,9810,9812,9811,9810,9812,9811,9811,9810,9812,9943,9946,9947,9949,9948,9945,9945,9946,9949,9948,9947,9946,9949,9945,9948,9947,9949,9946,9947,9945,9948,9948,9946,9947,9945,9949,10005)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 12 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 11 | 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 (12,13,29,44,45,46,47,106,113)
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.004 | 62 |
| 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 (3442,4923,9943,7832,4885,5053,7221,8743,4956,8085,7229,9946,8206,7826,3928,5051,7294,7802,8633,7028,7806,7238,4931,7202,5052,4897,74,8074,8556,9125,8543,8545,8541,7029,8560,8558,630,9192,7290,5038,7019,9548,9337,7010,7015,7011,7007,8086,7216,7241,7773,7009,5036,7783,7810,8078,7240,4397,4932,7814,7274,4398,8080,9554,3931,7272,3930,8102,8079,8076,686,4648,7255,9146,9395,8978,3694,3443,8087,7789,3697,9217,61,5265,7197,9567,9457,9559,8137,3686,7203,755,9549,7774,6463,5070,7008,7192,7822,644,7251,69,3040,9569,7212,6236,9216,4941,8082,8561,3448,620,9568,7220,7796,5266,7263,7265,7247,4908,9240,8825,8829,8531,8537,8551,8838,8839,8840,1302,8550,8845,8843,8844,1308,3687,7256,9527,6597,7834,8704,8075,3041,3446,8555,8557,8559,7237,3577,5044,8136,7288,4911,8081,5069,10005,7289,4880,9812,7225,7286,5058,4945,9807,6204,9542,7196,9570,8125,8126,7793,4902,8083,9523,4887,5068,8744,8191,549,7777,651,7278,9394,8084,8072,8720) | 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 (3442,4923,9943,7832,4885,5053,7221,8743,4956,8085,7229,9946,8206,7826,3928,5051,7294,7802,8633,7028,7806,7238,4931,7202,5052,4897,74,8074,8556,9125,8543,8545,8541,7029,8560,8558,630,9192,7290,5038,7019,9548,9337,7010,7015,7011,7007,8086,7216,7241,7773,7009,5036,7783,7810,8078,7240,4397,4932,7814,7274,4398,8080,9554,3931,7272,3930,8102,8079,8076,686,4648,7255,9146,9395,8978,3694,3443,8087,7789,3697,9217,61,5265,7197,9567,9457,9559,8137,3686,7203,755,9549,7774,6463,5070,7008,7192,7822,644,7251,69,3040,9569,7212,6236,9216,4941,8082,8561,3448,620,9568,7220,7796,5266,7263,7265,7247,4908,9240,8825,8829,8531,8537,8551,8838,8839,8840,1302,8550,8845,8843,8844,1308,3687,7256,9527,6597,7834,8704,8075,3041,3446,8555,8557,8559,7237,3577,5044,8136,7288,4911,8081,5069,10005,7289,4880,9812,7225,7286,5058,4945,9807,6204,9542,7196,9570,8125,8126,7793,4902,8083,9523,4887,5068,8744,8191,549,7777,651,7278,9394,8084,8072,8720) | 0.001 | 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 = '7826'
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 = '7826' 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` = '7826' | 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 = '9946'
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 = '9946' 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` = '9946' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9948' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9945' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9949' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9947' | 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 = '3928'
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 = '3928' 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` = '3928' | 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 = '5051'
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 = '5051' 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` = '5050' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5051' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5047' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5048' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5049' | 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 = '7294'
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 = '7294' 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 | 6 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7294' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7297' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7298' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7295' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7293' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7296' | 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 = '7802'
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 = '7802' 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` = '7802' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7805' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7803' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7804' | 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 = '7028'
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 = '7028' 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` = '7028' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7026' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7027' | 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 = '7238'
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 = '7238' 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` = '7238' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7239' | 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 = '7806'
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 = '7806' 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` = '7806' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7809' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7808' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7807' | 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 = '8633'
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 = '8633' 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` = '8633' | 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 = '74'
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 = '74' 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` = '74' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '75' | 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 = '4897'
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 = '4897' 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 | 6 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '4898' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '4900' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '4899' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '4897' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '4896' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '4895' | 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: 122 | 0.036 | 4960 |
(+48) 22 812 90 60
