| Queries | Time | Rows |
| SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.002 | 77 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`languages`) | 0.000 | 2 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_base_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_auth_api_url'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_secret'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_token'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_developer_id'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `parameter_value` FROM `shop_parameters_values` | 0.000 | 542 |
| SELECT `attribute_value` FROM `shop_attributes_values_description` | 0.000 | 221 |
| SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 1
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_currencies`)
ORDER BY `id_currency` ASC | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`calendar`)
LEFT JOIN `calendar_info` ON (`calendar_info`.`calendar_day_id` = `calendar`.`id_calendar_day`)
WHERE `calendar_lang` = 'pl_PL'
AND `calendar_date` >= '2026-04-07'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
| SELECT *
FROM (`configuration`) | 0.000 | 66 |
| SELECT *
FROM (`configuration`) | 0.000 | 66 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 113 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`shop_parameters` AS `p`)
INNER JOIN `shop_parameters_description` AS `pd` ON (`pd`.`parameter_id` = `p`.`id_parameter`)
WHERE `p`.`active` = 'Y' | 0.000 | 1 |
| SELECT `shop_parameters`.*, `shop_product_parameters`.*, `shop_parameters_values`.*
FROM (`shop_parameters`)
LEFT JOIN `shop_product_parameters` ON (`shop_product_parameters`.`parameter_id` = `shop_parameters`.`id_parameter`)
LEFT JOIN `shop_products_parameters` ON (`shop_products_parameters`.`product_id` = `shop_product_parameters`.`product_id`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`id_parameter_value` ASC | 0.003 | 518 |
| SELECT *
FROM (`pages`)
WHERE `lang` = 'pl_PL'
AND `available` = 'Y'
AND `show_in_menu` = 1
AND `page_type` != 'news'
ORDER BY `page_position` DESC, `available` ASC | 0.000 | 5 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '2'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1'
ORDER BY `boxes`.`position` DESC | 0.000 | 4 |
| SELECT `boxes`.*
FROM (`pages_elements`)
LEFT JOIN `elements` ON (`elements`.`id_element` = `pages_elements`.`element_id`)
LEFT JOIN `boxes_set` ON (`boxes_set`.`element_id` = `pages_elements`.`element_id`)
LEFT JOIN `boxes` ON (`boxes`.`boxes_set_id` = `boxes_set`.`id_boxes_set`)
WHERE `pages_elements`.`page_id` = '4'
AND `elements`.`type` = 'boxes'
AND `boxes`.`active` = '1' | 0.000 | 3 |
| SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '46' | 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` = 46 | 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` = '46'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
| SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (9943,7229,9946,5051,4931,7202,7773,7272,9146,7203,8075,5044) | 0.000 | 37 |
| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (4930,4929,4927,4928,4926,4931,5042,5046,5044,5045,5043,5050,5049,5047,5048,5051,7202,7203,7230,7231,7233,7232,7229,7272,7773,8075,9333,9334,9145,9335,9146,9943,9947,9948,9945,9949,9946) | 0.000 | 167 |
| 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 (4931,4927,4928,4930,4929,4926,4930,4931,4929,4928,4926,4927,4931,4927,4930,4926,4929,4928,4931,4930,4927,4926,4928,4929,4931,4927,4929,4926,4930,4928,4930,4929,4927,4926,4928,4931,5043,5044,5046,5045,5042,5042,5043,5046,5045,5044,5043,5046,5042,5045,5044,5046,5043,5044,5042,5045,5045,5043,5044,5042,5046,5048,5049,5051,5050,5047,5047,5048,5051,5050,5049,5048,5051,5047,5050,5049,5051,5048,5049,5047,5050,5050,5048,5049,5047,5051,7202,7203,7230,7231,7233,7232,7229,7229,7230,7233,7232,7231,7230,7233,7229,7232,7231,7233,7230,7231,7229,7232,7232,7230,7231,7229,7233,7272,7773,8075,9146,9333,9335,9334,9145,9145,9335,9146,9334,9333,9146,9335,9145,9333,9334,9335,9146,9333,9145,9334,9334,9146,9333,9145,9335,9943,9946,9947,9949,9948,9945,9945,9946,9949,9948,9947,9946,9949,9945,9948,9947,9949,9946,9947,9945,9948,9948,9946,9947,9945,9949)
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` = 46 | 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 (46)
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 15 |
| select max(NULLIF(`do_99` *(1)*1, 0)) AS max99, max(NULLIF(`od_25` *(1)*1, 0)) AS max25, max(NULLIF(`od_50` *(1)*1, 0)) AS max50, max(NULLIF(`od_100` *(1)*1, 0)) AS max100, max(NULLIF(`od_250` *(1)*1, 0)) AS max250, max(NULLIF(`od_500` *(1)*1, 0)) AS max500, max(NULLIF(`od_1000` *(1)*1, 0)) AS max1000 from shop_products_prices where product_id in (9943,7229,9946,5051,4931,7202,7773,7272,9146,7203,8075,5044) | 0.000 | 1 |
| select MIN(NULLIF(`do_99`*(1)*1, 0)) AS min99, MIN(NULLIF(`od_25`*(1)*1, 0)) AS min25, MIN(NULLIF(`od_50`*(1)*1, 0)) AS min50, MIN(NULLIF(`od_100`*(1)*1, 0)) AS min100, MIN(NULLIF(`od_250`*(1)*1, 0)) AS min250, MIN(NULLIF(`od_500`*(1)*1, 0)) AS min500, MIN(NULLIF(`od_1000`*(1)*1, 0)) AS min1000 from shop_products_prices where product_id in (9943,7229,9946,5051,4931,7202,7773,7272,9146,7203,8075,5044) | 0.000 | 1 |
| SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
| SELECT *
FROM (`shop_configuration`) | 0.000 | 8 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-text'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_1'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_2'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT *
FROM (`configuration`)
WHERE `key` = 'page_domain'
LIMIT 0, 1 | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '9943'
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 = '9943' 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` = '9943' | 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 = '7229'
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 = '7229' 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` = '7230' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7231' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7233' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7229' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '7232' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '9946'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '9946' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9946' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9948' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9945' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9949' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9947' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5051'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5051' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5050' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5051' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5047' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5048' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5049' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '4931'
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 = '4931' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 6 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '4926' | 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 = '7202'
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 = '7202' 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` = '7202' | 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 = '7272'
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 = '7272' 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` = '7272' | 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 = '7773'
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 = '7773' 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` = '7773' | 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 = '7203'
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 = '7203' 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` = '7203' | 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 = '9146'
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 = '9146' 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` = '9145' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9333' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9146' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9334' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '9335' | 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 = '8075'
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 = '8075' 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` = '8075' | 0.000 | 1 |
| SELECT srp.product_id, SUM(COALESCE(mq.quantity, 0)) as quantity
FROM shop_related_products AS srp
INNER JOIN shop_products_description AS spd ON (spd.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5044'
GROUP BY srp.product_id
ORDER BY quantity DESC | 0.000 | 1 |
| SELECT sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, MAX(mq.quantity) as quantity, COALESCE(sp.sum_quantity_mag1, 0) as sum_quantity
FROM shop_products AS sp
LEFT JOIN shop_parameters_values AS spv ON (spv.id_parameter_value = sp.id_attr_ps)
LEFT JOIN shop_related_products AS srp ON (srp.related_product_id = sp.id_product)
LEFT JOIN shop_parameters_description AS spd ON (spd.parameter_id = spv.parameter_id)
INNER JOIN shop_products_description AS spdesc ON (spdesc.product_id = srp.related_product_id)
LEFT JOIN magazyn_quantity AS mq ON (mq.product_id = srp.related_product_id AND mq.magazyn_id = 1)
WHERE srp.product_id = '5044' AND spv.active = 'Y' AND sp.active = 'Y'
GROUP BY sp.id_attr_ps, sp.id_product, spv.parameter_value, spv.parameter_value_name, spv.en_US_parameter_value_name, spv.parameter_img, spv.parameter_value2, spv.parameter_parent, spv.parameter_img, spd.parameter_name, spv.id_parameter_value, sp.sum_quantity_mag1
ORDER BY sum_quantity DESC, spv.parameter_position DESC | 0.000 | 5 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5043' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5045' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5042' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5046' | 0.000 | 1 |
| SELECT *
FROM (`shop_products_description`)
WHERE `product_id` = '5044' | 0.000 | 1 |
| SELECT `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: 115 | 0.018 | 2672 |
(+48) 22 812 90 60
