| 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 | 75 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_base_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_auth_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_secret'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_token'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_developer_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `parameter_value` FROM `shop_parameters_values` | 0.000 | 542 |
| SELECT `attribute_value` FROM `shop_attributes_values_description` | 0.000 | 221 |
| SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 1
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_currencies`)
ORDER BY `id_currency` ASC | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`calendar`)
LEFT JOIN `calendar_info` ON (`calendar_info`.`calendar_day_id` = `calendar`.`id_calendar_day`)
WHERE `calendar_lang` = 'pl_PL'
AND `calendar_date` >= '2025-06-15'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
| SELECT *
FROM (`configuration`) | 0.000 | 65 |
| SELECT *
FROM (`configuration`) | 0.000 | 65 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.001 | 113 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`shop_parameters` AS `p`)
INNER JOIN `shop_parameters_description` AS `pd` ON (`pd`.`parameter_id` = `p`.`id_parameter`)
WHERE `p`.`active` = 'Y' | 0.000 | 1 |
| SELECT `shop_parameters`.*, `shop_product_parameters`.*, `shop_parameters_values`.*
FROM (`shop_parameters`)
LEFT JOIN `shop_product_parameters` ON (`shop_product_parameters`.`parameter_id` = `shop_parameters`.`id_parameter`)
LEFT JOIN `shop_products_parameters` ON (`shop_products_parameters`.`product_id` = `shop_product_parameters`.`product_id`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`id_parameter_value` ASC | 0.006 | 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` = '89' | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '7' | 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` = 89 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (7,4)
ORDER BY `level` ASC | 0.000 | 2 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '89'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| Select * from( Select * from( SELECT p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo FROM (shop_products AS `p`)
LEFT JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y' GROUP BY product_id) AS `pi` ON (`pi`.`product_id` = `p`.`id_product`)
INNER JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `p`.`id_product`)
JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `p`.`id_product`)
LEFT JOIN shop_products_tags AS `pt` ON (`pt`.`product_id` = `p`.`id_product`)
LEFT JOIN shop_taxes AS `st` ON (`st`.`id_tax` = `p`.`tax_id`)
LEFT JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
LEFT JOIN shop_products_tags_dict AS `ptd` ON (`ptd`.`id_tag_dict` = `pt`.`tag_dict_id`)
LEFT JOIN shop_related_products AS `srp` ON (`srp`.`related_product_id` = `p`.`id_product`)
WHERE p.active = 'Y' AND pd.product_name IS NOT NULL AND category_id IN (89) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.085 | 357 |
| Select * from ( Select COUNT(*) AS count from ( SELECT sptv.variant_id,p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo , (CASE WHEN LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) = 99999999 THEN 0.00 ELSE LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) END) AS `min_price`, `magazyn`.`quantity` AS `available_now` FROM (shop_product_to_variant AS `sptv`)
left JOIN shop_products AS `p` ON (`sptv`.`product_id` = `p`.`id_product`)
left JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y') AS `pi` ON (`pi`.`product_id` = `sptv`.`product_id`)
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `sptv`.`product_id`)
left JOIN shop_products_parameters AS `spp` ON (`spp`.`product_id`=`sptv`.`product_id`)
left JOIN shop_parameters AS `sp` ON (`spp`.`parameter_id` = `sp`.`id_parameter`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
left JOIN shop_attributes AS `sa` ON (`sa`.`id_attribute`=`sptv`.`attr_id`)
LEFT JOIN shop_products_prices AS `prices` ON (`prices`.`product_id` = `p`.`id_product` AND `prices`.`variant_id` = `sptv`.`variant_id`)
LEFT JOIN magazyn_quantity AS `magazyn` ON (`magazyn`.`product_id` = `p`.`id_product` AND `magazyn`.`product_variant_id` = `sptv`.`variant_id` AND `magazyn`.`magazyn_id` = 1)
inner JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `sptv`.`product_id`) WHERE p.active = 'Y' and sptv.active='Y' AND p.id_product IN (5559,5559,5559,5559,5559,5559,5559,5559,5559,5559,5557,5557,5557,5557,5557,5557,5557,5557,5557,5557,10087,10087,10087,10087,10087,10087,10087,10087,10087,10087,5561,5561,5561,5561,5561,5561,5561,5560,5560,5560,5560,5560,5560,5560,5562,5562,5562,5562,5562,5562,5562,5530,5530,5531,5531,9032,9032,9032,9032,9032,5565,5565,5565,5565,5565,5563,5563,5563,5563,5563,5554,5554,5554,5554,5554,5554,5554,5554,5554,5554,5555,5555,5555,5555,5555,5555,5555,5555,5555,5555,9029,9029,9029,9029,9029,9029,9029,9029,9029,9029,5577,5577,5577,5577,5576,5576,5576,5576,5575,5575,5575,5575,573,573,573,573,572,572,572,572,571,571,571,571,584,584,584,584,584,584,585,585,585,585,585,585,583,583,583,583,583,583,586,586,586,586,586,586,5535,5535,5535,5535,5535,5535,5535,5535,5534,5534,5534,5534,5534,5534,5534,5534,5532,5532,5532,5532,5532,5532,5532,5532,5536,5536,5536,5536,5536,5536,5536,5536,5533,5533,5533,5533,5533,5533,5533,5533,574,574,575,575,5644,5644,5644,5646,5646,5646,5645,5645,5645,5574,5574,5574,5574,5572,5572,5572,5572,5573,5573,5573,5573,5553,5553,5553,5552,5552,5552,568,568,568,568,568,569,569,569,569,569,570,570,570,570,570,5567,5567,5567,5567,5567,5567,5567,5567,5567,5566,5566,5566,5566,5566,5566,5566,5566,5566,5569,5569,5569,5569,5569,5569,5569,5569,5569,5568,5568,5568,5568,5568,5568,5568,5568,5568,5571,5571,5571,5571,5571,5571,5571,5571,5571,5570,5570,5570,5570,5570,5570,5570,5570,5570,5650,5650,5650,5650,5651,5651,5651,5651,5649,5649,5649,5649,605,605,605,606,606,606,607,607,607,5640,5640,5640,5640,5643,5643,5643,5643,5642,5642,5642,5642,5641,5641,5641,5641,581,581,581,581,580,580,580,580,579,579,579,579,602,602,602,602,602,604,604,604,604,604,603,603,603,603,603,601,601,601,601,601) ) as s GROUP BY id_product_ps ) as ss | 0.017 | 20 |
| Select * from( Select * from( SELECT sptv.variant_id,p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo , (CASE WHEN LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) = 99999999 THEN 0.00 ELSE LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) END) AS `min_price`, `magazyn`.`quantity` AS `available_now` FROM (shop_product_to_variant AS `sptv`)
left JOIN shop_products AS `p` ON (`sptv`.`product_id` = `p`.`id_product`)
left JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y') AS `pi` ON (`pi`.`product_id` = `sptv`.`product_id`)
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `sptv`.`product_id`)
left JOIN shop_products_parameters AS `spp` ON (`spp`.`product_id`=`sptv`.`product_id`)
left JOIN shop_parameters AS `sp` ON (`spp`.`parameter_id` = `sp`.`id_parameter`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
left JOIN shop_attributes AS `sa` ON (`sa`.`id_attribute`=`sptv`.`attr_id`)
LEFT JOIN shop_products_prices AS `prices` ON (`prices`.`product_id` = `p`.`id_product` AND `prices`.`variant_id` = `sptv`.`variant_id`)
LEFT JOIN magazyn_quantity AS `magazyn` ON (`magazyn`.`product_id` = `p`.`id_product` AND `magazyn`.`product_variant_id` = `sptv`.`variant_id` AND `magazyn`.`magazyn_id` = 1)
inner JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `sptv`.`product_id`) WHERE p.active = 'Y' and sptv.active='Y' AND p.id_product IN (5559,5559,5559,5559,5559,5559,5559,5559,5559,5559,5557,5557,5557,5557,5557,5557,5557,5557,5557,5557,10087,10087,10087,10087,10087,10087,10087,10087,10087,10087,5561,5561,5561,5561,5561,5561,5561,5560,5560,5560,5560,5560,5560,5560,5562,5562,5562,5562,5562,5562,5562,5530,5530,5531,5531,9032,9032,9032,9032,9032,5565,5565,5565,5565,5565,5563,5563,5563,5563,5563,5554,5554,5554,5554,5554,5554,5554,5554,5554,5554,5555,5555,5555,5555,5555,5555,5555,5555,5555,5555,9029,9029,9029,9029,9029,9029,9029,9029,9029,9029,5577,5577,5577,5577,5576,5576,5576,5576,5575,5575,5575,5575,573,573,573,573,572,572,572,572,571,571,571,571,584,584,584,584,584,584,585,585,585,585,585,585,583,583,583,583,583,583,586,586,586,586,586,586,5535,5535,5535,5535,5535,5535,5535,5535,5534,5534,5534,5534,5534,5534,5534,5534,5532,5532,5532,5532,5532,5532,5532,5532,5536,5536,5536,5536,5536,5536,5536,5536,5533,5533,5533,5533,5533,5533,5533,5533,574,574,575,575,5644,5644,5644,5646,5646,5646,5645,5645,5645,5574,5574,5574,5574,5572,5572,5572,5572,5573,5573,5573,5573,5553,5553,5553,5552,5552,5552,568,568,568,568,568,569,569,569,569,569,570,570,570,570,570,5567,5567,5567,5567,5567,5567,5567,5567,5567,5566,5566,5566,5566,5566,5566,5566,5566,5566,5569,5569,5569,5569,5569,5569,5569,5569,5569,5568,5568,5568,5568,5568,5568,5568,5568,5568,5571,5571,5571,5571,5571,5571,5571,5571,5571,5570,5570,5570,5570,5570,5570,5570,5570,5570,5650,5650,5650,5650,5651,5651,5651,5651,5649,5649,5649,5649,605,605,605,606,606,606,607,607,607,5640,5640,5640,5640,5643,5643,5643,5643,5642,5642,5642,5642,5641,5641,5641,5641,581,581,581,581,580,580,580,580,579,579,579,579,602,602,602,602,602,604,604,604,604,604,603,603,603,603,603,601,601,601,601,601) ) as s order by available_now DESC, mainproduct DESC, product_name ASC ) as ss GROUP BY id_product_ps order by available_now DESC LIMIT 12 ,12 | 0.020 | 8 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (5559,5559,5559,5559,5559,5559,5559,5559,5559,5559,5557,5557,5557,5557,5557,5557,5557,5557,5557,5557,10087,10087,10087,10087,10087,10087,10087,10087,10087,10087,5561,5561,5561,5561,5561,5561,5561,5560,5560,5560,5560,5560,5560,5560,5562,5562,5562,5562,5562,5562,5562,5530,5530,5531,5531,9032,9032,9032,9032,9032,5565,5565,5565,5565,5565,5563,5563,5563,5563,5563,5554,5554,5554,5554,5554,5554,5554,5554,5554,5554,5555,5555,5555,5555,5555,5555,5555,5555,5555,5555,9029,9029,9029,9029,9029,9029,9029,9029,9029,9029,5577,5577,5577,5577,5576,5576,5576,5576,5575,5575,5575,5575,573,573,573,573,572,572,572,572,571,571,571,571,584,584,584,584,584,584,585,585,585,585,585,585,583,583,583,583,583,583,586,586,586,586,586,586,5535,5535,5535,5535,5535,5535,5535,5535,5534,5534,5534,5534,5534,5534,5534,5534,5532,5532,5532,5532,5532,5532,5532,5532,5536,5536,5536,5536,5536,5536,5536,5536,5533,5533,5533,5533,5533,5533,5533,5533,574,574,575,575,5644,5644,5644,5646,5646,5646,5645,5645,5645,5574,5574,5574,5574,5572,5572,5572,5572,5573,5573,5573,5573,5553,5553,5553,5552,5552,5552,568,568,568,568,568,569,569,569,569,569,570,570,570,570,570,5567,5567,5567,5567,5567,5567,5567,5567,5567,5566,5566,5566,5566,5566,5566,5566,5566,5566,5569,5569,5569,5569,5569,5569,5569,5569,5569,5568,5568,5568,5568,5568,5568,5568,5568,5568,5571,5571,5571,5571,5571,5571,5571,5571,5571,5570,5570,5570,5570,5570,5570,5570,5570,5570,5650,5650,5650,5650,5651,5651,5651,5651,5649,5649,5649,5649,605,605,605,606,606,606,607,607,607,5640,5640,5640,5640,5643,5643,5643,5643,5642,5642,5642,5642,5641,5641,5641,5641,581,581,581,581,580,580,580,580,579,579,579,579,602,602,602,602,602,604,604,604,604,604,603,603,603,603,603,601,601,601,601,601) | 0.001 | 357 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (9862,9861,569,568,570,570,568,9862,9861,569,568,9862,9861,570,569,8808,572,571,573,571,8808,573,572,8808,571,572,573,575,574,574,575,8810,580,581,579,8810,579,580,581,579,8810,580,581,9863,585,8811,584,583,586,9863,585,8811,583,584,586,9863,584,8811,583,586,585,584,9863,583,8811,585,586,9971,602,603,604,601,603,604,601,9971,602,601,9971,604,603,602,9971,603,601,604,602,606,607,605,606,607,605,606,605,607,5530,5531,5530,5531,9906,5534,9905,5533,9026,5536,5535,5532,9906,5534,5532,9905,9026,5536,5535,5533,9906,5533,9905,5532,9026,5536,5534,5535,9906,5533,9905,5532,9026,5536,5534,5535,5533,9906,5532,9905,9026,5535,5534,5536,5553,9917,5552,5553,9917,5552,9819,9925,5556,9921,9920,5555,9919,9029,9918,5554,9819,9925,5556,9921,9920,5554,9919,9029,5555,9918,9924,5559,5558,9923,9922,10087,9030,9824,5557,9821,5558,9924,9923,5557,9922,10087,9030,9824,5559,9821,9926,9823,5561,9031,9822,5562,5560,5562,5560,9926,9031,9823,9822,5561,5560,9926,9031,9823,5562,9822,5561,9927,5565,9032,5563,5564,9927,5564,9032,5563,5565,9928,5569,9826,9825,5568,5567,5571,5566,5570,9928,9826,5569,5568,9825,5570,5571,5567,5566,9928,5569,9826,5567,9825,5571,5566,5570,5568,5570,9928,5568,9826,5567,9825,5566,5571,5569,5568,5566,5567,9928,9826,9825,5570,5571,5569,9928,9826,5568,5567,9825,5570,5566,5571,5569,9033,5574,5573,5572,9033,5574,5572,5573,9033,5573,5572,5574,9930,5576,5575,5577,9930,5575,5576,5577,9930,5575,5577,5576,5643,5641,5642,5640,5643,5640,5642,5641,5640,5643,5641,5642,5640,5641,5643,5642,5645,5646,5644,5646,5645,5644,5645,5644,5646,9039,5651,5649,5650,9039,5651,5649,5650,5650,9039,5649,5651,9819,9925,5556,9921,9920,5555,5554,9919,9029,9918,9927,5563,5565,5564,9032,9924,5559,5558,9923,9922,5557,9030,9824,10087,9821) | 0.055 | 598 |
| 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 (570,9862,569,9861,568,9862,568,569,9861,570,569,568,9862,570,9861,572,8808,573,571,571,8808,573,572,571,8808,572,573,575,574,574,575,580,8810,581,579,579,8810,581,580,579,8810,580,581,585,9863,584,8811,586,583,585,9863,583,8811,586,584,584,9863,583,8811,586,585,9863,584,8811,583,585,586,603,9971,602,604,601,601,9971,602,604,603,602,604,601,9971,603,602,9971,603,601,604,605,607,606,607,605,606,605,606,607,5531,5530,5530,5531,5534,9906,5533,9905,5536,9026,5535,5532,5534,9906,5532,9905,5536,9026,5535,5533,5533,9906,5532,9905,5536,9026,5535,5534,5533,9906,5532,9905,5536,9026,5535,5534,5533,9906,5532,9905,9026,5535,5536,5534,5552,9917,5553,5552,5553,9917,9819,9925,5556,9921,5555,9920,9029,9919,5554,9918,9819,9925,5556,9921,9920,5554,9029,9919,5555,9918,5555,9920,5554,9919,9918,9029,9819,5556,5559,9924,5558,9923,10087,9922,9030,9824,5557,9821,5559,5557,10087,9924,9923,9922,9824,9821,9030,5558,5558,9924,5557,9923,10087,9922,9030,9824,5559,9821,5562,9926,5561,9823,9031,9822,5560,5560,9926,9031,9823,5561,9822,5562,5561,5560,9926,9031,9823,5562,9822,5564,9927,9032,5565,5563,5565,5564,9032,5563,5563,9927,9032,5564,5565,5570,9928,5569,9826,5568,9825,5571,5567,5566,5568,9928,5569,9826,5570,9825,5571,5566,5567,5570,9928,5569,9826,5567,9825,5566,5571,5568,5568,9928,9826,5567,5566,9825,5569,5571,5570,5569,5567,5568,9928,5571,9826,9825,5570,5566,5569,9928,5568,9826,5567,9825,5566,5570,5571,5574,9033,5573,5572,5574,9033,5572,5573,9033,5573,5572,5574,5576,9930,5575,5577,5575,9930,5576,5577,5575,9930,5577,5576,5641,5642,5643,5640,5643,5640,5642,5641,5643,5640,5642,5641,5641,5640,5642,5643,5644,5646,5645,5644,5646,5645,5645,5644,5646,5651,9039,5650,5649,5651,9039,5649,5650,5650,9039,5651,5649,572,571,573,8808,580,579,581,8810,585,583,584,8811,586,5533,5532,5534,5536,5535,9026,9819,9925,5556,9921,5555,9920,5554,9919,9029,9918,5558,10087,5559,5557,9030,5560,5561,5562,9031,5564,9927,5565,5563,9032,5572,5574,5573,9033,5650,5649,5651,9039,5554,5555,5556,9819,9029,9821,5558,9030,10087,5557,5559,5560,9031,9822,5561,9823,5562,5560,5561,5562,9822,9031,9823,9924,9923,9922,5559,10087,5557,9821,5558,9030,9824,5568,5567,9825,5569,5566,5571,5570,5568,5569,5567,9826,5566,5571,5570,9825,568,569,9862,570,9861,568,569,9861,570,9862,584,585,583,9863,586,8811,5534,5532,5533,5536,5535,9026,9905,5533,5534,5532,5536,5535,9905,9026,9906,5552,9917,5553,9918,9920,9919,9819,5556,5554,9029,5555,5555,9920,9918,9819,5556,9029,9919,5554,5555,5554,9029,9919,9918,9819,5556,9920,5555,5554,9029,9920,9919,9918,9819,5556,9921,9923,9824,5559,9821,5558,10087,5557,9030,9922,9923,5559,5557,10087,9922,9824,9821,5558,9030,5559,5557,10087,9923,9922,9824,9821,5558,9030,9924,5555,5554,9029,9921,9920,9919,9918,9819,5556,9925,5560,5561,9823,9822,9031,9926,5562,9032,5563,5564,5565,9927,5568,5569,5567,5566,5571,9826,9825,9928,5570,5575,5576,5577,9930,601,604,602,603,9971,5559,9924,5558,9923,5557,9922,9030,9824,10087,9821)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 19 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 89 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 7 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 4 | 0.000 | 1 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`parameter_value2`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products_to_categories` AS `sptc`)
LEFT JOIN `shop_products` AS `sp` ON (`sp`.`id_product` = `sptc`.`product_id`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sptc`.`product_id`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
WHERE `sptc`.`category_id` = '89'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.001 | 22 |
| select max(NULLIF(`do_99` *(1)*1, 0)) AS max99, max(NULLIF(`od_50` *(1)*1, 0)) AS max50, max(NULLIF(`od_100` *(1)*1, 0)) AS max100, max(NULLIF(`od_250` *(1)*1, 0)) AS max250, max(NULLIF(`od_500` *(1)*1, 0)) AS max500, max(NULLIF(`od_1000` *(1)*1, 0)) AS max1000 from shop_products_prices where product_id in (5559,5559,5559,5559,5559,5559,5559,5559,5559,5559,5557,5557,5557,5557,5557,5557,5557,5557,5557,5557,10087,10087,10087,10087,10087,10087,10087,10087,10087,10087,5561,5561,5561,5561,5561,5561,5561,5560,5560,5560,5560,5560,5560,5560,5562,5562,5562,5562,5562,5562,5562,5530,5530,5531,5531,9032,9032,9032,9032,9032,5565,5565,5565,5565,5565,5563,5563,5563,5563,5563,5554,5554,5554,5554,5554,5554,5554,5554,5554,5554,5555,5555,5555,5555,5555,5555,5555,5555,5555,5555,9029,9029,9029,9029,9029,9029,9029,9029,9029,9029,5577,5577,5577,5577,5576,5576,5576,5576,5575,5575,5575,5575,573,573,573,573,572,572,572,572,571,571,571,571,584,584,584,584,584,584,585,585,585,585,585,585,583,583,583,583,583,583,586,586,586,586,586,586,5535,5535,5535,5535,5535,5535,5535,5535,5534,5534,5534,5534,5534,5534,5534,5534,5532,5532,5532,5532,5532,5532,5532,5532,5536,5536,5536,5536,5536,5536,5536,5536,5533,5533,5533,5533,5533,5533,5533,5533,574,574,575,575,5644,5644,5644,5646,5646,5646,5645,5645,5645,5574,5574,5574,5574,5572,5572,5572,5572,5573,5573,5573,5573,5553,5553,5553,5552,5552,5552,568,568,568,568,568,569,569,569,569,569,570,570,570,570,570,5567,5567,5567,5567,5567,5567,5567,5567,5567,5566,5566,5566,5566,5566,5566,5566,5566,5566,5569,5569,5569,5569,5569,5569,5569,5569,5569,5568,5568,5568,5568,5568,5568,5568,5568,5568,5571,5571,5571,5571,5571,5571,5571,5571,5571,5570,5570,5570,5570,5570,5570,5570,5570,5570,5650,5650,5650,5650,5651,5651,5651,5651,5649,5649,5649,5649,605,605,605,606,606,606,607,607,607,5640,5640,5640,5640,5643,5643,5643,5643,5642,5642,5642,5642,5641,5641,5641,5641,581,581,581,581,580,580,580,580,579,579,579,579,602,602,602,602,602,604,604,604,604,604,603,603,603,603,603,601,601,601,601,601) | 0.001 | 1 |
| select MIN(NULLIF(`do_99`*(1)*1, 0)) AS min99, MIN(NULLIF(`od_50`*(1)*1, 0)) AS min50, MIN(NULLIF(`od_100`*(1)*1, 0)) AS min100, MIN(NULLIF(`od_250`*(1)*1, 0)) AS min250, MIN(NULLIF(`od_500`*(1)*1, 0)) AS min500, MIN(NULLIF(`od_1000`*(1)*1, 0)) AS min1000 from shop_products_prices where product_id in (5559,5559,5559,5559,5559,5559,5559,5559,5559,5559,5557,5557,5557,5557,5557,5557,5557,5557,5557,5557,10087,10087,10087,10087,10087,10087,10087,10087,10087,10087,5561,5561,5561,5561,5561,5561,5561,5560,5560,5560,5560,5560,5560,5560,5562,5562,5562,5562,5562,5562,5562,5530,5530,5531,5531,9032,9032,9032,9032,9032,5565,5565,5565,5565,5565,5563,5563,5563,5563,5563,5554,5554,5554,5554,5554,5554,5554,5554,5554,5554,5555,5555,5555,5555,5555,5555,5555,5555,5555,5555,9029,9029,9029,9029,9029,9029,9029,9029,9029,9029,5577,5577,5577,5577,5576,5576,5576,5576,5575,5575,5575,5575,573,573,573,573,572,572,572,572,571,571,571,571,584,584,584,584,584,584,585,585,585,585,585,585,583,583,583,583,583,583,586,586,586,586,586,586,5535,5535,5535,5535,5535,5535,5535,5535,5534,5534,5534,5534,5534,5534,5534,5534,5532,5532,5532,5532,5532,5532,5532,5532,5536,5536,5536,5536,5536,5536,5536,5536,5533,5533,5533,5533,5533,5533,5533,5533,574,574,575,575,5644,5644,5644,5646,5646,5646,5645,5645,5645,5574,5574,5574,5574,5572,5572,5572,5572,5573,5573,5573,5573,5553,5553,5553,5552,5552,5552,568,568,568,568,568,569,569,569,569,569,570,570,570,570,570,5567,5567,5567,5567,5567,5567,5567,5567,5567,5566,5566,5566,5566,5566,5566,5566,5566,5566,5569,5569,5569,5569,5569,5569,5569,5569,5569,5568,5568,5568,5568,5568,5568,5568,5568,5568,5571,5571,5571,5571,5571,5571,5571,5571,5571,5570,5570,5570,5570,5570,5570,5570,5570,5570,5650,5650,5650,5650,5651,5651,5651,5651,5649,5649,5649,5649,605,605,605,606,606,606,607,607,607,5640,5640,5640,5640,5643,5643,5643,5643,5642,5642,5642,5642,5641,5641,5641,5641,581,581,581,581,580,580,580,580,579,579,579,579,602,602,602,602,602,604,604,604,604,604,603,603,603,603,603,601,601,601,601,601) | 0.001 | 1 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`shop_configuration`) | 0.000 | 8 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-text'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_1'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_2'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_domain'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '5649' | 0.000 | 4 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '9039'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 3 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '574' | 0.000 | 2 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '575'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 2 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '579' | 0.000 | 4 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '8810'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 3 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '583' | 0.000 | 6 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '9863'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 4 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '601' | 0.000 | 5 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '9971'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 4 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '605' | 0.000 | 3 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '606'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 3 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '5552' | 0.000 | 3 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '5553'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 2 |
| SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '5554' | 0.000 | 10 |
| SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '9819'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 3 |
| SELECT `name`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
| SELECT `description`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'footer_text'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'rodo_pdf_link'
LIMIT 0, 1 | 0.000 | 1 |
| Total: 78 | 0.197 | 3586 |
(+48) 22 812 90 60
