| Queries | Time | Rows |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.001 | 77 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_base_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_auth_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_secret'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_token'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_developer_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `parameter_value` FROM `shop_parameters_values` | 0.000 | 542 |
| SELECT `attribute_value` FROM `shop_attributes_values_description` | 0.000 | 221 |
| SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 1
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_currencies`)
ORDER BY `id_currency` ASC | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`calendar`)
LEFT JOIN `calendar_info` ON (`calendar_info`.`calendar_day_id` = `calendar`.`id_calendar_day`)
WHERE `calendar_lang` = 'pl_PL'
AND `calendar_date` >= '2026-04-06'
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`.`level` = '1'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 26 |
| 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( SELECT p.id_product_ps 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')
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 1 GROUP BY p.id_product_ps ) as s | 0.032 | 2746 |
| 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 1 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 0 ,12 | 0.244 | 12 |
| 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 | 0.006 | 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 | 0.006 | 1 |
| SELECT *
FROM (`shop_products_parameters`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`parameter_value` ASC | 0.033 | 8352 |
| SELECT `attr_id`
FROM (`shop_product_to_variant`) | 0.002 | 23726 |
| SELECT *
FROM (`shop_attributes` AS `a`)
INNER JOIN `shop_attributes_description` AS `ad` ON (`a`.`id_attribute` = `ad`.`attribute_id`)
INNER JOIN `shop_attributes_values` AS `av` ON (`av`.`attribute_id` = `a`.`id_attribute`)
INNER JOIN `shop_attributes_values_description` AS `avd` ON (`avd`.`attribute_value_id` = `av`.`id_attribute_value`)
WHERE `attribute_language` = 'pl_PL'
AND `attribute_value_id` IN (0,2467,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2479,2480,2481,2482,2483,2484,2485,2486,2487,2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2499,2500,2501,2510,2512,2513,2514,2515,2516,2517,2518,2519,2520,2521,2522,2523,2524,2525,2534,2535,2536,2537,2543,2544,2545,2546,2550,2553,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2569,2570,2579,2580,2581,2582,2583,2589,2590,2591,2592,2597,2598,2599,2604,2605,2606,2607,2608,2609,2610,2611,2612,2615,2617,2618,2620,2621,2622,2625,2626,2627,2630,2632,2644,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2674,2675,2676,2677,2678,2679,2681,2682,2684,2685,2686)
ORDER BY `avd`.`attribute_position` ASC | 0.001 | 141 |
| 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 = '2405'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.001 | 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 = '2405' 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.002 | 29 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2405' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2408' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2423' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2406' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2407' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2422' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2411' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2420' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2412' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2416' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2419' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2424' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2427' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2421' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2409' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2410' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2426' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2425' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2430' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2432' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2417' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2433' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2431' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2418' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2429' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2428' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2413' | 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 = '24'
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 = '24' 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 | 9 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '24' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1866' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1872' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1871' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1867' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1869' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1868' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1870' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1873' | 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 = '1986'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.001 | 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 = '1986' 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.001 | 24 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1986' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1987' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2007' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1993' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1989' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1994' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1997' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2002' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1991' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1995' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2001' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1996' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2003' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2000' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1992' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1988' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2006' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1998' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2008' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1999' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2005' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1990' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2004' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2009' | 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 = '1'
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 = '1' 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.001 | 11 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '11' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '6' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '8' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '10' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '3' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '12' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '4' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '13' | 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 = '2273'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.001 | 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 = '2273' 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.002 | 32 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2273' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2274' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2276' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2287' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2286' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2288' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2290' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2284' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2279' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2281' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2275' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2277' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2285' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2299' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2291' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2278' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2300' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2302' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2282' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2304' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2301' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2295' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2280' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2292' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2293' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2298' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2297' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2303' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2289' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2296' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2283' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2294' | 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 = '8050'
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 = '8050' 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` = '8050' | 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 = '2491'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.001 | 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 = '2491' 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.001 | 22 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2491' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2492' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2495' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2494' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2493' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2512' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2497' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2498' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2507' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2510' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2504' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2503' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2496' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2511' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2508' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2499' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2505' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2509' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2506' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2501' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2502' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2500' | 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 = '2381'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.001 | 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 = '2381' 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.001 | 21 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2382' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2381' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2384' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2395' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2386' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2388' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2393' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2394' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2383' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2390' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2397' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2398' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2385' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2387' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2392' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2400' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2389' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2391' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2401' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2399' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2396' | 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 = '2200'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.001 | 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 = '2200' 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.001 | 20 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2200' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2217' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2203' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2210' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2201' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2209' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2216' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2204' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2212' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2219' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2202' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2207' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2208' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2211' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2206' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2218' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2215' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '2205' | 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 = '1395'
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 = '1395' 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 | 11 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1396' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1395' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1402' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1398' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1399' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1403' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1404' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1397' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1401' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1400' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '1405' | 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 = '9113'
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 = '9113' 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` = '8207' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9113' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9112' | 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 = '5525'
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 = '5525' 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` = '5525' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5527' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5529' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5526' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5528' | 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: 254 | 0.364 | 37170 |
(+48) 22 812 90 60
