| Queries | Time | Rows |
| 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-02-16'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
| SELECT *
FROM (`configuration`) | 0.000 | 65 |
| SELECT *
FROM (`configuration`) | 0.000 | 65 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.001 | 113 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`shop_parameters` AS `p`)
INNER JOIN `shop_parameters_description` AS `pd` ON (`pd`.`parameter_id` = `p`.`id_parameter`)
WHERE `p`.`active` = 'Y' | 0.000 | 1 |
| SELECT `shop_parameters`.*, `shop_product_parameters`.*, `shop_parameters_values`.*
FROM (`shop_parameters`)
LEFT JOIN `shop_product_parameters` ON (`shop_product_parameters`.`parameter_id` = `shop_parameters`.`id_parameter`)
LEFT JOIN `shop_products_parameters` ON (`shop_products_parameters`.`product_id` = `shop_product_parameters`.`product_id`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`id_parameter_value` ASC | 0.003 | 518 |
| SELECT *
FROM (`pages`)
WHERE `lang` = 'pl_PL'
AND `available` = 'Y'
AND `show_in_menu` = 1
AND `page_type` != 'news'
ORDER BY `page_position` DESC, `available` ASC | 0.000 | 5 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '2'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1'
ORDER BY `boxes`.`position` DESC | 0.000 | 4 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '4'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1' | 0.000 | 3 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '106' | 0.000 | 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` 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` = 106 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (12,11)
ORDER BY `level` ASC | 0.000 | 2 |
| SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '106'
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 ptc.category_id IN (106) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.030 | 246 |
| 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 (686,9528,9191,9539,9526,685,7029,9527,9530,9531,9532,9529,4956,630,626,627,628,629,7783,7782,7784,7785,7787,7786,9192,9190,9189,755,757,758,756,644,643,9542,9540,9544,9543,9541,9523,9525,9524,8191,7019,7018,7020,651,652,653,654,655,650,620,618,619) ) as s GROUP BY id_product_ps ) as ss | 0.002 | 15 |
| SELECT ss.* 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 (686,9528,9191,9539,9526,685,7029,9527,9530,9531,9532,9529,4956,630,626,627,628,629,7783,7782,7784,7785,7787,7786,9192,9190,9189,755,757,758,756,644,643,9542,9540,9544,9543,9541,9523,9525,9524,8191,7019,7018,7020,651,652,653,654,655,650,620,618,619) ) as s order by available_now DESC, mainproduct DESC, product_name ASC
) as ss
INNER JOIN (
SELECT id_product_ps, MAX(COALESCE(available_now, 0)) as max_available_now
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 (686,9528,9191,9539,9526,685,7029,9527,9530,9531,9532,9529,4956,630,626,627,628,629,7783,7782,7784,7785,7787,7786,9192,9190,9189,755,757,758,756,644,643,9542,9540,9544,9543,9541,9523,9525,9524,8191,7019,7018,7020,651,652,653,654,655,650,620,618,619) ) as s order by available_now DESC, mainproduct DESC, product_name ASC
) as temp
GROUP BY id_product_ps
) as max_avail ON ss.id_product_ps = max_avail.id_product_ps
AND COALESCE(ss.available_now, 0) = max_avail.max_available_now
GROUP BY ss.id_product_ps order by available_now DESC LIMIT 0 ,12 | 0.005 | 12 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (686,686,9528,9528,9528,9528,9528,9528,9191,9191,9191,9191,9539,9539,9539,9539,9539,9539,9526,9526,9526,9526,685,685,7029,9527,9527,9527,9527,9527,9527,9530,9530,9530,9530,9530,9530,9531,9531,9531,9531,9531,9531,9532,9532,9532,9532,9532,9532,9529,9529,9529,9529,9529,9529,4956,630,630,630,630,630,626,626,626,626,626,627,627,627,627,627,628,628,628,628,628,629,629,629,629,629,7783,7783,7783,7783,7783,7783,7782,7782,7782,7782,7782,7782,7784,7784,7784,7784,7784,7784,7785,7785,7785,7785,7785,7785,7787,7787,7787,7787,7787,7787,7786,7786,7786,7786,7786,7786,9192,9192,9192,9192,9190,9190,9190,9190,9189,9189,9189,9189,755,755,755,755,757,757,757,757,758,758,758,758,756,756,756,756,644,644,643,643,9542,9542,9542,9542,9542,9542,9540,9540,9540,9540,9540,9540,9544,9544,9544,9544,9544,9544,9543,9543,9543,9543,9543,9543,9541,9541,9541,9541,9541,9541,9523,9523,9523,9523,9525,9525,9525,9525,9524,9524,9524,9524,8191,7019,7019,7019,7018,7018,7018,7020,7020,7020,651,651,651,651,651,651,652,652,652,652,652,652,653,653,653,653,653,653,654,654,654,654,654,654,655,655,655,655,655,655,650,650,650,650,650,650,620,620,620,618,618,618,619,619,619) | 0.000 | 246 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (619,620,618,619,620,618,619,620,618,627,628,630,626,629,628,626,629,630,627,626,630,628,629,627,630,626,628,627,629,629,628,626,630,627,643,644,643,644,655,651,654,652,653,650,655,654,650,652,653,651,651,655,650,654,652,653,651,655,654,650,652,653,655,651,653,650,652,654,654,653,651,650,652,655,685,686,685,686,758,756,757,755,758,755,757,756,758,755,756,757,757,755,756,758,4956,7019,7020,7018,7020,7019,7018,7019,7020,7018,7029,7787,7783,7786,7784,7782,7785,7787,7786,7782,7784,7785,7783,7783,7787,7782,7786,7784,7785,7787,7783,7786,7782,7784,7785,7787,7783,7785,7782,7784,7786,7786,7785,7783,7782,7784,7787,8191,9192,9190,9189,9191,9189,9192,9191,9190,9189,9192,9190,9191,9191,9190,9189,9192,9526,9524,9525,9523,9526,9523,9525,9524,9523,9526,9524,9525,9525,9523,9524,9526,9532,9528,9531,9529,9527,9530,9532,9531,9529,9527,9530,9528,9528,9532,9527,9531,9530,9529,9528,9532,9531,9527,9529,9530,9528,9532,9530,9527,9529,9531,9531,9530,9528,9529,9527,9532,9544,9543,9541,9542,9539,9540,9544,9539,9543,9541,9542,9540,9539,9544,9540,9543,9542,9541,9544,9539,9543,9540,9541,9542,9539,9544,9542,9540,9541,9543,9543,9542,9539,9540,9541,9544) | 0.000 | 246 |
| 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 (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,4956,7018,7020,7019,7020,7018,7019,7019,7018,7020,7029,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,8191,9191,9192,9190,9189,9192,9191,9189,9190,9192,9189,9190,9191,9191,9189,9190,9192,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,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)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.000 | 0 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 106 | 0.000 | 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 (106)
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.001 | 14 |
| 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 (686,686,9528,9528,9528,9528,9528,9528,9191,9191,9191,9191,9539,9539,9539,9539,9539,9539,9526,9526,9526,9526,685,685,7029,9527,9527,9527,9527,9527,9527,9530,9530,9530,9530,9530,9530,9531,9531,9531,9531,9531,9531,9532,9532,9532,9532,9532,9532,9529,9529,9529,9529,9529,9529,4956,630,630,630,630,630,626,626,626,626,626,627,627,627,627,627,628,628,628,628,628,629,629,629,629,629,7783,7783,7783,7783,7783,7783,7782,7782,7782,7782,7782,7782,7784,7784,7784,7784,7784,7784,7785,7785,7785,7785,7785,7785,7787,7787,7787,7787,7787,7787,7786,7786,7786,7786,7786,7786,9192,9192,9192,9192,9190,9190,9190,9190,9189,9189,9189,9189,755,755,755,755,757,757,757,757,758,758,758,758,756,756,756,756,644,644,643,643,9542,9542,9542,9542,9542,9542,9540,9540,9540,9540,9540,9540,9544,9544,9544,9544,9544,9544,9543,9543,9543,9543,9543,9543,9541,9541,9541,9541,9541,9541,9523,9523,9523,9523,9525,9525,9525,9525,9524,9524,9524,9524,8191,7019,7019,7019,7018,7018,7018,7020,7020,7020,651,651,651,651,651,651,652,652,652,652,652,652,653,653,653,653,653,653,654,654,654,654,654,654,655,655,655,655,655,655,650,650,650,650,650,650,620,620,620,618,618,618,619,619,619) | 0.000 | 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 (686,686,9528,9528,9528,9528,9528,9528,9191,9191,9191,9191,9539,9539,9539,9539,9539,9539,9526,9526,9526,9526,685,685,7029,9527,9527,9527,9527,9527,9527,9530,9530,9530,9530,9530,9530,9531,9531,9531,9531,9531,9531,9532,9532,9532,9532,9532,9532,9529,9529,9529,9529,9529,9529,4956,630,630,630,630,630,626,626,626,626,626,627,627,627,627,627,628,628,628,628,628,629,629,629,629,629,7783,7783,7783,7783,7783,7783,7782,7782,7782,7782,7782,7782,7784,7784,7784,7784,7784,7784,7785,7785,7785,7785,7785,7785,7787,7787,7787,7787,7787,7787,7786,7786,7786,7786,7786,7786,9192,9192,9192,9192,9190,9190,9190,9190,9189,9189,9189,9189,755,755,755,755,757,757,757,757,758,758,758,758,756,756,756,756,644,644,643,643,9542,9542,9542,9542,9542,9542,9540,9540,9540,9540,9540,9540,9544,9544,9544,9544,9544,9544,9543,9543,9543,9543,9543,9543,9541,9541,9541,9541,9541,9541,9523,9523,9523,9523,9525,9525,9525,9525,9524,9524,9524,9524,8191,7019,7019,7019,7018,7018,7018,7020,7020,7020,651,651,651,651,651,651,652,652,652,652,652,652,653,653,653,653,653,653,654,654,654,654,654,654,655,655,655,655,655,655,650,650,650,650,650,650,620,620,620,618,618,618,619,619,619) | 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, MAX(mq.quantity) 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 = '4956'
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
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 = '4956' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '7787'
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
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 = '7787' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7787' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7782' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7783' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7786' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7784' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7785' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '7019'
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
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 = '7019' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 3 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7019' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7018' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7020' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '7029'
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
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 = '7029' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '9192'
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
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 = '9192' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 4 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9192' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9189' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9190' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9191' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '630'
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
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 = '630' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '630' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '626' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '629' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '627' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '628' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '9540'
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
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 = '9540' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9540' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9539' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9544' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9541' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9543' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9542' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '619'
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
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 = '619' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 3 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '620' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '619' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '618' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '643'
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
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 = '643' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 2 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '644' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '643' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '650'
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
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 = '650' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '650' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '652' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '655' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '653' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '651' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '654' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '686'
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
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 = '686' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 2 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '686' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '685' | 0.000 | 1 |
| SELECT srp.product_id, MAX(mq.quantity) 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 = '755'
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
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 = '755' 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
ORDER BY quantity DESC, spv.parameter_position DESC | 0.000 | 4 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '755' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '756' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '758' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '757' | 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 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'rodo_pdf_link'
LIMIT 0, 1 | 0.000 | 1 |
| Total: 124 | 0.058 | 3052 |
(+48) 22 812 90 60
