Queries | Time | Rows |
SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.001 | 75 |
SELECT *
FROM (`languages`) | 0.000 | 2 |
SELECT *
FROM (`languages`) | 0.000 | 2 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_base_api_url'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_auth_api_url'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_id'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_secret'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_token'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_developer_id'
LIMIT 0, 1 | 0.000 | 1 |
SELECT `parameter_value` FROM `shop_parameters_values` | 0.000 | 542 |
SELECT `attribute_value` FROM `shop_attributes_values_description` | 0.000 | 221 |
SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 1
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 6 |
SELECT *
FROM (`shop_currencies`)
ORDER BY `id_currency` ASC | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`calendar`)
LEFT JOIN `calendar_info` ON (`calendar_info`.`calendar_day_id` = `calendar`.`id_calendar_day`)
WHERE `calendar_lang` = 'pl_PL'
AND `calendar_date` >= '2025-06-15'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
SELECT *
FROM (`configuration`) | 0.000 | 65 |
SELECT *
FROM (`configuration`) | 0.000 | 65 |
SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.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` = '44' | 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` = 44 | 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` = '44'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`) | 0.000 | 113 |
Select * from( Select * from( SELECT p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo FROM (shop_products AS `p`)
LEFT JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y' GROUP BY product_id) AS `pi` ON (`pi`.`product_id` = `p`.`id_product`)
INNER JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `p`.`id_product`)
JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `p`.`id_product`)
LEFT JOIN shop_products_tags AS `pt` ON (`pt`.`product_id` = `p`.`id_product`)
LEFT JOIN shop_taxes AS `st` ON (`st`.`id_tax` = `p`.`tax_id`)
LEFT JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
LEFT JOIN shop_products_tags_dict AS `ptd` ON (`ptd`.`id_tag_dict` = `pt`.`tag_dict_id`)
LEFT JOIN shop_related_products AS `srp` ON (`srp`.`related_product_id` = `p`.`id_product`)
WHERE p.active = 'Y' AND pd.product_name IS NOT NULL AND category_id IN (44) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.033 | 580 |
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 (7263,7263,7263,7263,9337,9337,9337,9337,9337,9337,9337,9337,9337,7265,7265,7265,7265,7265,7265,7265,7247,7247,7247,7247,7247,8743,4908,4908,4908,4908,4908,4906,4906,4906,4906,4906,4907,4907,4907,4907,4907,4909,4909,4909,4909,4909,4910,4910,4910,4910,4910,7262,7262,7262,7262,7261,7261,7261,7261,7264,7264,7264,7264,7255,8074,8543,8545,8541,7256,7256,7256,7256,7256,7258,7258,7258,7258,7258,7257,7257,7257,7257,7257,7259,7259,7259,7259,7259,7260,7260,7260,7260,7260,7241,7241,7241,7241,7241,7242,7242,7242,7242,7242,7243,7243,7243,7243,7243,7245,7245,7245,7245,7245,7244,7244,7244,7244,7244,7237,7237,7237,7237,7235,7235,7235,7235,7236,7236,7236,7236,7234,7234,7234,7234,7197,7197,7197,7197,7197,7198,7198,7198,7198,7198,7199,7199,7199,7199,7199,7200,7200,7200,7200,7200,7201,7201,7201,7201,7201,4911,4911,4911,4911,4911,4911,4912,4912,4912,4912,4912,4912,4914,4914,4914,4914,4914,4914,4915,4915,4915,4915,4915,4915,4916,4916,4916,4916,4916,4916,4913,4913,4913,4913,4913,4913,8081,7290,7290,7290,7291,7291,7291,7292,7292,7292,7289,4880,7225,9343,9343,9343,9343,9343,9343,9343,9343,9343,9339,9339,9339,9339,9339,9339,9339,9339,9339,9341,9341,9341,9341,9341,9341,9341,9341,9341,9336,9336,9336,9336,9336,9336,9336,9336,9336,7192,7286,7286,7286,7286,7286,7283,7283,7283,7283,7283,7284,7284,7284,7284,7284,7285,7285,7285,7285,7285,7287,7287,7287,7287,7287,4885,4885,4885,4885,4885,4885,4884,4884,4884,4884,4884,4884,4883,4883,4883,4883,4883,4883,4881,4881,4881,4881,4881,4881,4886,4886,4886,4886,4886,4886,4882,4882,4882,4882,4882,4882,5052,7238,7238,7239,7239,7266,7266,7266,7266,7266,7266,7266,7267,7267,7267,7267,7267,7267,7267,7270,7270,7270,7270,7270,7270,7270,7271,7271,7271,7271,7271,7271,7271,7268,7268,7268,7268,7268,7268,7268,7269,7269,7269,7269,7269,7269,7269,7249,7249,7249,7249,7249,7248,7248,7248,7248,7248,7246,7246,7246,7246,7246,7250,7250,7250,7250,7250,7294,7294,7294,7294,7294,7294,7298,7298,7298,7298,7298,7298,7293,7293,7293,7293,7293,7293,7297,7297,7297,7297,7297,7297,7295,7295,7295,7295,7295,7295,7296,7296,7296,7296,7296,7296,7196,7196,7196,7196,7193,7193,7193,7193,7194,7194,7194,7194,7195,7195,7195,7195,7251,7251,7251,7251,7253,7253,7253,7253,7254,7254,7254,7254,7252,7252,7252,7252,5053,4902,4902,4902,4902,4903,4903,4903,4903,4904,4904,4904,4904,4905,4905,4905,4905,4897,4897,4897,4897,4897,4897,4895,4895,4895,4895,4895,4895,4896,4896,4896,4896,4896,4896,4898,4898,4898,4898,4898,4898,4899,4899,4899,4899,4899,4899,4900,4900,4900,4900,4900,4900,7212,7212,7212,7212,7212,7211,7211,7211,7211,7211,7213,7213,7213,7213,7213,7214,7214,7214,7214,7214,7215,7215,7215,7215,7215,4887,7274,7274,7274,7274,7274,7277,7277,7277,7277,7277,7275,7275,7275,7275,7275,7276,7276,7276,7276,7276,7273,7273,7273,7273,7273,4923,4923,4924,4924,8744,7278,7278,7278,7278,7278,7279,7279,7279,7279,7279,7282,7282,7282,7282,7282,7280,7280,7280,7280,7280,7281,7281,7281,7281,7281,8072,74,74,75,75) ) as s GROUP BY id_product_ps ) as ss | 0.004 | 40 |
Select * from( Select * from( SELECT sptv.variant_id,p.*, pd.*, pi.filename, pi.realfilename, prod.producer_logo , (CASE WHEN LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) = 99999999 THEN 0.00 ELSE LEAST(
CASE WHEN `prices`.`do_99` = 0.00 THEN 99999999 ELSE `prices`.`do_99` END,
CASE WHEN `prices`.`od_50` = 0.00 THEN 99999999 ELSE `prices`.`od_50` END,
CASE WHEN `prices`.`od_100` = 0.00 THEN 99999999 ELSE `prices`.`od_100` END,
CASE WHEN `prices`.`od_250` = 0.00 THEN 99999999 ELSE `prices`.`od_250` END,
CASE WHEN `prices`.`od_500` = 0.00 THEN 99999999 ELSE `prices`.`od_500` END,
CASE WHEN `prices`.`od_1000` = 0.00 THEN 99999999 ELSE `prices`.`od_1000` END,
CASE WHEN `prices`.`od_1500` = 0.00 THEN 99999999 ELSE `prices`.`od_1500` END,
CASE WHEN `prices`.`od_3000` = 0.00 THEN 99999999 ELSE `prices`.`od_3000` END,
CASE WHEN `prices`.`od_5000` = 0.00 THEN 99999999 ELSE `prices`.`od_5000` END,
CASE WHEN `prices`.`od_10000` = 0.00 THEN 99999999 ELSE `prices`.`od_10000` END
) END) AS `min_price`, `magazyn`.`quantity` AS `available_now` FROM (shop_product_to_variant AS `sptv`)
left JOIN shop_products AS `p` ON (`sptv`.`product_id` = `p`.`id_product`)
left JOIN ( SELECT * FROM shop_products_images WHERE mainimage='Y') AS `pi` ON (`pi`.`product_id` = `sptv`.`product_id`)
inner JOIN shop_products_description AS `pd` ON (`pd`.`product_id` = `sptv`.`product_id`)
left JOIN shop_products_parameters AS `spp` ON (`spp`.`product_id`=`sptv`.`product_id`)
left JOIN shop_parameters AS `sp` ON (`spp`.`parameter_id` = `sp`.`id_parameter`)
left JOIN shop_producers AS `prod` ON (`prod`.`id_producer` = `p`.`producer_id`)
left JOIN shop_attributes AS `sa` ON (`sa`.`id_attribute`=`sptv`.`attr_id`)
LEFT JOIN shop_products_prices AS `prices` ON (`prices`.`product_id` = `p`.`id_product` AND `prices`.`variant_id` = `sptv`.`variant_id`)
LEFT JOIN magazyn_quantity AS `magazyn` ON (`magazyn`.`product_id` = `p`.`id_product` AND `magazyn`.`product_variant_id` = `sptv`.`variant_id` AND `magazyn`.`magazyn_id` = 1)
inner JOIN ( SELECT * FROM shop_products_to_categories ) AS `ptc` ON (`ptc`.`product_id` = `sptv`.`product_id`) WHERE p.active = 'Y' and sptv.active='Y' AND p.id_product IN (7263,7263,7263,7263,9337,9337,9337,9337,9337,9337,9337,9337,9337,7265,7265,7265,7265,7265,7265,7265,7247,7247,7247,7247,7247,8743,4908,4908,4908,4908,4908,4906,4906,4906,4906,4906,4907,4907,4907,4907,4907,4909,4909,4909,4909,4909,4910,4910,4910,4910,4910,7262,7262,7262,7262,7261,7261,7261,7261,7264,7264,7264,7264,7255,8074,8543,8545,8541,7256,7256,7256,7256,7256,7258,7258,7258,7258,7258,7257,7257,7257,7257,7257,7259,7259,7259,7259,7259,7260,7260,7260,7260,7260,7241,7241,7241,7241,7241,7242,7242,7242,7242,7242,7243,7243,7243,7243,7243,7245,7245,7245,7245,7245,7244,7244,7244,7244,7244,7237,7237,7237,7237,7235,7235,7235,7235,7236,7236,7236,7236,7234,7234,7234,7234,7197,7197,7197,7197,7197,7198,7198,7198,7198,7198,7199,7199,7199,7199,7199,7200,7200,7200,7200,7200,7201,7201,7201,7201,7201,4911,4911,4911,4911,4911,4911,4912,4912,4912,4912,4912,4912,4914,4914,4914,4914,4914,4914,4915,4915,4915,4915,4915,4915,4916,4916,4916,4916,4916,4916,4913,4913,4913,4913,4913,4913,8081,7290,7290,7290,7291,7291,7291,7292,7292,7292,7289,4880,7225,9343,9343,9343,9343,9343,9343,9343,9343,9343,9339,9339,9339,9339,9339,9339,9339,9339,9339,9341,9341,9341,9341,9341,9341,9341,9341,9341,9336,9336,9336,9336,9336,9336,9336,9336,9336,7192,7286,7286,7286,7286,7286,7283,7283,7283,7283,7283,7284,7284,7284,7284,7284,7285,7285,7285,7285,7285,7287,7287,7287,7287,7287,4885,4885,4885,4885,4885,4885,4884,4884,4884,4884,4884,4884,4883,4883,4883,4883,4883,4883,4881,4881,4881,4881,4881,4881,4886,4886,4886,4886,4886,4886,4882,4882,4882,4882,4882,4882,5052,7238,7238,7239,7239,7266,7266,7266,7266,7266,7266,7266,7267,7267,7267,7267,7267,7267,7267,7270,7270,7270,7270,7270,7270,7270,7271,7271,7271,7271,7271,7271,7271,7268,7268,7268,7268,7268,7268,7268,7269,7269,7269,7269,7269,7269,7269,7249,7249,7249,7249,7249,7248,7248,7248,7248,7248,7246,7246,7246,7246,7246,7250,7250,7250,7250,7250,7294,7294,7294,7294,7294,7294,7298,7298,7298,7298,7298,7298,7293,7293,7293,7293,7293,7293,7297,7297,7297,7297,7297,7297,7295,7295,7295,7295,7295,7295,7296,7296,7296,7296,7296,7296,7196,7196,7196,7196,7193,7193,7193,7193,7194,7194,7194,7194,7195,7195,7195,7195,7251,7251,7251,7251,7253,7253,7253,7253,7254,7254,7254,7254,7252,7252,7252,7252,5053,4902,4902,4902,4902,4903,4903,4903,4903,4904,4904,4904,4904,4905,4905,4905,4905,4897,4897,4897,4897,4897,4897,4895,4895,4895,4895,4895,4895,4896,4896,4896,4896,4896,4896,4898,4898,4898,4898,4898,4898,4899,4899,4899,4899,4899,4899,4900,4900,4900,4900,4900,4900,7212,7212,7212,7212,7212,7211,7211,7211,7211,7211,7213,7213,7213,7213,7213,7214,7214,7214,7214,7214,7215,7215,7215,7215,7215,4887,7274,7274,7274,7274,7274,7277,7277,7277,7277,7277,7275,7275,7275,7275,7275,7276,7276,7276,7276,7276,7273,7273,7273,7273,7273,4923,4923,4924,4924,8744,7278,7278,7278,7278,7278,7279,7279,7279,7279,7279,7282,7282,7282,7282,7282,7280,7280,7280,7280,7280,7281,7281,7281,7281,7281,8072,74,74,75,75) ) as s order by available_now DESC, mainproduct DESC, product_name ASC ) as ss GROUP BY id_product_ps order by available_now DESC LIMIT 12 ,12 | 0.006 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (7263,7263,7263,7263,9337,9337,9337,9337,9337,9337,9337,9337,9337,7265,7265,7265,7265,7265,7265,7265,7247,7247,7247,7247,7247,8743,4908,4908,4908,4908,4908,4906,4906,4906,4906,4906,4907,4907,4907,4907,4907,4909,4909,4909,4909,4909,4910,4910,4910,4910,4910,7262,7262,7262,7262,7261,7261,7261,7261,7264,7264,7264,7264,7255,8074,8543,8545,8541,7256,7256,7256,7256,7256,7258,7258,7258,7258,7258,7257,7257,7257,7257,7257,7259,7259,7259,7259,7259,7260,7260,7260,7260,7260,7241,7241,7241,7241,7241,7242,7242,7242,7242,7242,7243,7243,7243,7243,7243,7245,7245,7245,7245,7245,7244,7244,7244,7244,7244,7237,7237,7237,7237,7235,7235,7235,7235,7236,7236,7236,7236,7234,7234,7234,7234,7197,7197,7197,7197,7197,7198,7198,7198,7198,7198,7199,7199,7199,7199,7199,7200,7200,7200,7200,7200,7201,7201,7201,7201,7201,4911,4911,4911,4911,4911,4911,4912,4912,4912,4912,4912,4912,4914,4914,4914,4914,4914,4914,4915,4915,4915,4915,4915,4915,4916,4916,4916,4916,4916,4916,4913,4913,4913,4913,4913,4913,8081,7290,7290,7290,7291,7291,7291,7292,7292,7292,7289,4880,7225,9343,9343,9343,9343,9343,9343,9343,9343,9343,9339,9339,9339,9339,9339,9339,9339,9339,9339,9341,9341,9341,9341,9341,9341,9341,9341,9341,9336,9336,9336,9336,9336,9336,9336,9336,9336,7192,7286,7286,7286,7286,7286,7283,7283,7283,7283,7283,7284,7284,7284,7284,7284,7285,7285,7285,7285,7285,7287,7287,7287,7287,7287,4885,4885,4885,4885,4885,4885,4884,4884,4884,4884,4884,4884,4883,4883,4883,4883,4883,4883,4881,4881,4881,4881,4881,4881,4886,4886,4886,4886,4886,4886,4882,4882,4882,4882,4882,4882,5052,7238,7238,7239,7239,7266,7266,7266,7266,7266,7266,7266,7267,7267,7267,7267,7267,7267,7267,7270,7270,7270,7270,7270,7270,7270,7271,7271,7271,7271,7271,7271,7271,7268,7268,7268,7268,7268,7268,7268,7269,7269,7269,7269,7269,7269,7269,7249,7249,7249,7249,7249,7248,7248,7248,7248,7248,7246,7246,7246,7246,7246,7250,7250,7250,7250,7250,7294,7294,7294,7294,7294,7294,7298,7298,7298,7298,7298,7298,7293,7293,7293,7293,7293,7293,7297,7297,7297,7297,7297,7297,7295,7295,7295,7295,7295,7295,7296,7296,7296,7296,7296,7296,7196,7196,7196,7196,7193,7193,7193,7193,7194,7194,7194,7194,7195,7195,7195,7195,7251,7251,7251,7251,7253,7253,7253,7253,7254,7254,7254,7254,7252,7252,7252,7252,5053,4902,4902,4902,4902,4903,4903,4903,4903,4904,4904,4904,4904,4905,4905,4905,4905,4897,4897,4897,4897,4897,4897,4895,4895,4895,4895,4895,4895,4896,4896,4896,4896,4896,4896,4898,4898,4898,4898,4898,4898,4899,4899,4899,4899,4899,4899,4900,4900,4900,4900,4900,4900,7212,7212,7212,7212,7212,7211,7211,7211,7211,7211,7213,7213,7213,7213,7213,7214,7214,7214,7214,7214,7215,7215,7215,7215,7215,4887,7274,7274,7274,7274,7274,7277,7277,7277,7277,7277,7275,7275,7275,7275,7275,7276,7276,7276,7276,7276,7273,7273,7273,7273,7273,4923,4923,4924,4924,8744,7278,7278,7278,7278,7278,7279,7279,7279,7279,7279,7282,7282,7282,7282,7282,7280,7280,7280,7280,7280,7281,7281,7281,7281,7281,8072,74,74,75,75) | 0.001 | 580 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (74,75,74,75,4880,4886,4882,4885,4883,4881,4884,4886,4885,4881,4883,4884,4882,4882,4886,4881,4885,4884,4883,4886,4882,4885,4881,4883,4884,4886,4882,4884,4881,4883,4885,4885,4882,4884,4883,4881,4886,4887,4900,4896,4899,4897,4898,4895,4900,4899,4895,4897,4898,4896,4896,4900,4895,4899,4898,4897,4896,4900,4899,4895,4897,4898,4900,4896,4898,4895,4897,4899,4899,4898,4896,4895,4897,4900,4905,4903,4902,4904,4905,4902,4904,4903,4902,4905,4903,4904,4904,4903,4902,4905,4907,4908,4910,4909,4906,4908,4906,4909,4910,4907,4906,4910,4909,4908,4907,4910,4908,4906,4909,4907,4909,4908,4906,4910,4907,4916,4912,4915,4913,4914,4911,4916,4915,4913,4911,4914,4912,4912,4916,4911,4915,4914,4913,4916,4912,4915,4911,4913,4914,4916,4912,4914,4911,4913,4915,4915,4914,4912,4911,4913,4916,4923,4924,4923,4924,5052,5053,7192,7196,7194,7193,7195,7193,7196,7195,7194,7193,7196,7194,7195,7195,7193,7194,7196,7198,7199,7201,7197,7200,7199,7200,7197,7201,7198,7197,7201,7199,7200,7198,7201,7199,7197,7198,7200,7200,7199,7197,7198,7201,7212,7213,7215,7211,7214,7213,7211,7214,7215,7212,7211,7215,7213,7214,7212,7215,7213,7211,7212,7214,7214,7213,7211,7212,7215,7225,7237,7235,7234,7236,7237,7234,7236,7235,7237,7234,7235,7236,7236,7234,7235,7237,7238,7239,7238,7239,7242,7243,7245,7244,7241,7243,7244,7245,7241,7242,7241,7245,7244,7243,7242,7245,7243,7241,7244,7242,7244,7243,7241,7242,7245,7247,7248,7250,7246,7249,7248,7249,7246,7250,7247,7246,7250,7248,7249,7247,7250,7246,7248,7249,7247,7249,7248,7246,7247,7250,7254,7252,7251,7253,7251,7254,7252,7253,7251,7254,7252,7253,7253,7252,7251,7254,7255,7257,7258,7260,7256,7259,7258,7256,7259,7260,7257,7256,7260,7259,7258,7257,7260,7258,7256,7257,7259,7259,7258,7256,7260,7257,7264,7262,7261,7263,7264,7261,7263,7262,7264,7261,7262,7263,7263,7261,7262,7264,7267,7271,7270,7266,7268,7265,7269,7267,7268,7271,7265,7270,7269,7266,7268,7266,7270,7271,7269,7265,7267,7266,7271,7265,7270,7268,7269,7267,7271,7270,7266,7265,7268,7269,7267,7271,7266,7269,7268,7265,7267,7270,7270,7269,7266,7268,7265,7267,7271,7274,7275,7277,7276,7273,7275,7273,7276,7277,7274,7273,7277,7276,7275,7274,7277,7273,7275,7276,7274,7276,7275,7273,7274,7277,7279,7280,7282,7278,7281,7280,7281,7278,7282,7279,7278,7282,7280,7281,7279,7282,7278,7280,7279,7281,7281,7280,7278,7282,7279,7284,7285,7287,7283,7286,7285,7283,7286,7287,7284,7283,7287,7285,7286,7284,7287,7283,7285,7284,7286,7286,7285,7283,7284,7287,7289,7291,7290,7292,7292,7291,7290,7291,7290,7292,7298,7294,7297,7295,7293,7296,7298,7297,7295,7293,7296,7294,7294,7298,7293,7297,7296,7295,7294,7298,7297,7293,7295,7296,7298,7294,7296,7293,7295,7297,7297,7294,7296,7295,7293,7298,8072,8074,8081,8541,8543,8545,8743,8744,9344,9343,9339,9338,9342,9341,9337,9340,9336,9344,9343,9339,9338,9342,9341,9336,9337,9340,9344,9338,9343,9341,9337,9342,9336,9339,9340,9344,9338,9343,9337,9342,9340,9336,9339,9341,9344,9338,9342,9341,9337,9340,9336,9343,9339) | 0.001 | 610 |
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 (75,74,75,74,4880,4886,4882,4883,4885,4884,4881,4885,4886,4884,4883,4881,4882,4886,4882,4885,4881,4884,4883,4886,4885,4882,4881,4884,4883,4886,4882,4884,4881,4883,4885,4885,4884,4882,4881,4883,4886,4887,4900,4896,4897,4899,4898,4895,4899,4900,4898,4897,4895,4896,4900,4896,4899,4895,4898,4897,4900,4899,4896,4895,4897,4898,4900,4896,4898,4895,4899,4897,4899,4896,4898,4895,4900,4897,4904,4905,4903,4902,4905,4904,4902,4903,4905,4902,4903,4904,4904,4902,4903,4905,4907,4908,4910,4909,4906,4906,4907,4910,4909,4908,4907,4910,4906,4909,4908,4910,4907,4908,4906,4909,4909,4907,4908,4906,4910,4916,4912,4913,4915,4914,4911,4915,4916,4914,4913,4911,4912,4916,4912,4915,4911,4914,4913,4916,4915,4912,4911,4914,4913,4916,4912,4914,4911,4913,4915,4915,4914,4912,4911,4916,4913,4924,4923,4924,4923,5052,5053,7192,7195,7196,7194,7193,7196,7195,7193,7194,7196,7193,7195,7194,7195,7193,7196,7194,7198,7199,7201,7200,7197,7197,7198,7201,7200,7199,7198,7201,7197,7200,7199,7201,7198,7199,7197,7200,7200,7198,7199,7197,7201,7212,7213,7215,7214,7211,7211,7212,7215,7214,7213,7212,7215,7211,7214,7213,7215,7212,7213,7211,7214,7214,7212,7213,7211,7215,7225,7236,7237,7235,7234,7237,7236,7234,7235,7237,7234,7235,7236,7236,7234,7237,7235,7239,7238,7239,7238,7242,7243,7245,7244,7241,7241,7242,7245,7244,7243,7242,7245,7241,7244,7243,7245,7242,7243,7241,7244,7244,7242,7243,7241,7245,7247,7248,7250,7249,7246,7246,7247,7250,7249,7248,7247,7250,7246,7249,7248,7250,7247,7248,7246,7249,7249,7247,7248,7246,7250,7253,7254,7252,7251,7254,7251,7253,7252,7254,7251,7252,7253,7253,7251,7254,7252,7255,7257,7258,7260,7259,7256,7256,7257,7260,7259,7258,7257,7260,7256,7259,7258,7260,7257,7258,7256,7259,7259,7257,7258,7256,7260,7263,7264,7262,7261,7264,7263,7261,7262,7264,7261,7262,7263,7263,7261,7262,7264,7267,7268,7271,7266,7270,7269,7265,7267,7268,7271,7270,7269,7265,7266,7266,7265,7271,7267,7270,7269,7268,7267,7271,7266,7270,7265,7269,7268,7271,7267,7270,7266,7268,7265,7269,7271,7267,7269,7266,7265,7268,7270,7270,7267,7269,7268,7266,7265,7271,7274,7275,7277,7276,7273,7273,7274,7277,7276,7275,7274,7277,7273,7276,7275,7277,7274,7275,7273,7276,7276,7274,7275,7273,7277,7279,7280,7282,7281,7278,7278,7279,7282,7281,7280,7279,7282,7278,7281,7280,7282,7279,7280,7278,7281,7281,7279,7280,7278,7282,7284,7285,7287,7286,7283,7283,7284,7287,7286,7285,7284,7287,7283,7286,7285,7287,7284,7285,7283,7286,7286,7284,7285,7283,7287,7289,7290,7292,7291,7292,7290,7291,7291,7290,7292,7298,7294,7295,7297,7296,7293,7297,7298,7296,7295,7293,7294,7298,7294,7297,7293,7296,7295,7298,7297,7294,7293,7295,7296,7298,7294,7296,7293,7295,7297,7297,7296,7294,7293,7298,7295,8072,8074,8081,8541,8543,8545,8743,8744,9340,9344,9343,9339,9338,9342,9337,9341,9336,9340,9344,9339,9343,9338,9342,9341,9336,9337,9339,9343,9341,9337,9336,9338,9340,9344,9338,9337,9342,9336,9343,9341,9339,9343,9338,9340,9341,9339,9337,9336,9339,9343,9344,9338,9342,9337,9340,9336,9341,9343,9339,9337,9340,9338,9342,9336,9341,9339,9344,9338,9342,9341,9337,9336,9340,9343,9339,9336,9343,9337,9341,9342,9340,9338,9344)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 0 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 44 | 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 `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`parameter_value2`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products_to_categories` AS `sptc`)
LEFT JOIN `shop_products` AS `sp` ON (`sp`.`id_product` = `sptc`.`product_id`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sptc`.`product_id`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
WHERE `sptc`.`category_id` = '44'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.001 | 31 |
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 (7263,7263,7263,7263,9337,9337,9337,9337,9337,9337,9337,9337,9337,7265,7265,7265,7265,7265,7265,7265,7247,7247,7247,7247,7247,8743,4908,4908,4908,4908,4908,4906,4906,4906,4906,4906,4907,4907,4907,4907,4907,4909,4909,4909,4909,4909,4910,4910,4910,4910,4910,7262,7262,7262,7262,7261,7261,7261,7261,7264,7264,7264,7264,7255,8074,8543,8545,8541,7256,7256,7256,7256,7256,7258,7258,7258,7258,7258,7257,7257,7257,7257,7257,7259,7259,7259,7259,7259,7260,7260,7260,7260,7260,7241,7241,7241,7241,7241,7242,7242,7242,7242,7242,7243,7243,7243,7243,7243,7245,7245,7245,7245,7245,7244,7244,7244,7244,7244,7237,7237,7237,7237,7235,7235,7235,7235,7236,7236,7236,7236,7234,7234,7234,7234,7197,7197,7197,7197,7197,7198,7198,7198,7198,7198,7199,7199,7199,7199,7199,7200,7200,7200,7200,7200,7201,7201,7201,7201,7201,4911,4911,4911,4911,4911,4911,4912,4912,4912,4912,4912,4912,4914,4914,4914,4914,4914,4914,4915,4915,4915,4915,4915,4915,4916,4916,4916,4916,4916,4916,4913,4913,4913,4913,4913,4913,8081,7290,7290,7290,7291,7291,7291,7292,7292,7292,7289,4880,7225,9343,9343,9343,9343,9343,9343,9343,9343,9343,9339,9339,9339,9339,9339,9339,9339,9339,9339,9341,9341,9341,9341,9341,9341,9341,9341,9341,9336,9336,9336,9336,9336,9336,9336,9336,9336,7192,7286,7286,7286,7286,7286,7283,7283,7283,7283,7283,7284,7284,7284,7284,7284,7285,7285,7285,7285,7285,7287,7287,7287,7287,7287,4885,4885,4885,4885,4885,4885,4884,4884,4884,4884,4884,4884,4883,4883,4883,4883,4883,4883,4881,4881,4881,4881,4881,4881,4886,4886,4886,4886,4886,4886,4882,4882,4882,4882,4882,4882,5052,7238,7238,7239,7239,7266,7266,7266,7266,7266,7266,7266,7267,7267,7267,7267,7267,7267,7267,7270,7270,7270,7270,7270,7270,7270,7271,7271,7271,7271,7271,7271,7271,7268,7268,7268,7268,7268,7268,7268,7269,7269,7269,7269,7269,7269,7269,7249,7249,7249,7249,7249,7248,7248,7248,7248,7248,7246,7246,7246,7246,7246,7250,7250,7250,7250,7250,7294,7294,7294,7294,7294,7294,7298,7298,7298,7298,7298,7298,7293,7293,7293,7293,7293,7293,7297,7297,7297,7297,7297,7297,7295,7295,7295,7295,7295,7295,7296,7296,7296,7296,7296,7296,7196,7196,7196,7196,7193,7193,7193,7193,7194,7194,7194,7194,7195,7195,7195,7195,7251,7251,7251,7251,7253,7253,7253,7253,7254,7254,7254,7254,7252,7252,7252,7252,5053,4902,4902,4902,4902,4903,4903,4903,4903,4904,4904,4904,4904,4905,4905,4905,4905,4897,4897,4897,4897,4897,4897,4895,4895,4895,4895,4895,4895,4896,4896,4896,4896,4896,4896,4898,4898,4898,4898,4898,4898,4899,4899,4899,4899,4899,4899,4900,4900,4900,4900,4900,4900,7212,7212,7212,7212,7212,7211,7211,7211,7211,7211,7213,7213,7213,7213,7213,7214,7214,7214,7214,7214,7215,7215,7215,7215,7215,4887,7274,7274,7274,7274,7274,7277,7277,7277,7277,7277,7275,7275,7275,7275,7275,7276,7276,7276,7276,7276,7273,7273,7273,7273,7273,4923,4923,4924,4924,8744,7278,7278,7278,7278,7278,7279,7279,7279,7279,7279,7282,7282,7282,7282,7282,7280,7280,7280,7280,7280,7281,7281,7281,7281,7281,8072,74,74,75,75) | 0.001 | 1 |
select MIN(NULLIF(`do_99`*(1)*1, 0)) AS min99, MIN(NULLIF(`od_50`*(1)*1, 0)) AS min50, MIN(NULLIF(`od_100`*(1)*1, 0)) AS min100, MIN(NULLIF(`od_250`*(1)*1, 0)) AS min250, MIN(NULLIF(`od_500`*(1)*1, 0)) AS min500, MIN(NULLIF(`od_1000`*(1)*1, 0)) AS min1000 from shop_products_prices where product_id in (7263,7263,7263,7263,9337,9337,9337,9337,9337,9337,9337,9337,9337,7265,7265,7265,7265,7265,7265,7265,7247,7247,7247,7247,7247,8743,4908,4908,4908,4908,4908,4906,4906,4906,4906,4906,4907,4907,4907,4907,4907,4909,4909,4909,4909,4909,4910,4910,4910,4910,4910,7262,7262,7262,7262,7261,7261,7261,7261,7264,7264,7264,7264,7255,8074,8543,8545,8541,7256,7256,7256,7256,7256,7258,7258,7258,7258,7258,7257,7257,7257,7257,7257,7259,7259,7259,7259,7259,7260,7260,7260,7260,7260,7241,7241,7241,7241,7241,7242,7242,7242,7242,7242,7243,7243,7243,7243,7243,7245,7245,7245,7245,7245,7244,7244,7244,7244,7244,7237,7237,7237,7237,7235,7235,7235,7235,7236,7236,7236,7236,7234,7234,7234,7234,7197,7197,7197,7197,7197,7198,7198,7198,7198,7198,7199,7199,7199,7199,7199,7200,7200,7200,7200,7200,7201,7201,7201,7201,7201,4911,4911,4911,4911,4911,4911,4912,4912,4912,4912,4912,4912,4914,4914,4914,4914,4914,4914,4915,4915,4915,4915,4915,4915,4916,4916,4916,4916,4916,4916,4913,4913,4913,4913,4913,4913,8081,7290,7290,7290,7291,7291,7291,7292,7292,7292,7289,4880,7225,9343,9343,9343,9343,9343,9343,9343,9343,9343,9339,9339,9339,9339,9339,9339,9339,9339,9339,9341,9341,9341,9341,9341,9341,9341,9341,9341,9336,9336,9336,9336,9336,9336,9336,9336,9336,7192,7286,7286,7286,7286,7286,7283,7283,7283,7283,7283,7284,7284,7284,7284,7284,7285,7285,7285,7285,7285,7287,7287,7287,7287,7287,4885,4885,4885,4885,4885,4885,4884,4884,4884,4884,4884,4884,4883,4883,4883,4883,4883,4883,4881,4881,4881,4881,4881,4881,4886,4886,4886,4886,4886,4886,4882,4882,4882,4882,4882,4882,5052,7238,7238,7239,7239,7266,7266,7266,7266,7266,7266,7266,7267,7267,7267,7267,7267,7267,7267,7270,7270,7270,7270,7270,7270,7270,7271,7271,7271,7271,7271,7271,7271,7268,7268,7268,7268,7268,7268,7268,7269,7269,7269,7269,7269,7269,7269,7249,7249,7249,7249,7249,7248,7248,7248,7248,7248,7246,7246,7246,7246,7246,7250,7250,7250,7250,7250,7294,7294,7294,7294,7294,7294,7298,7298,7298,7298,7298,7298,7293,7293,7293,7293,7293,7293,7297,7297,7297,7297,7297,7297,7295,7295,7295,7295,7295,7295,7296,7296,7296,7296,7296,7296,7196,7196,7196,7196,7193,7193,7193,7193,7194,7194,7194,7194,7195,7195,7195,7195,7251,7251,7251,7251,7253,7253,7253,7253,7254,7254,7254,7254,7252,7252,7252,7252,5053,4902,4902,4902,4902,4903,4903,4903,4903,4904,4904,4904,4904,4905,4905,4905,4905,4897,4897,4897,4897,4897,4897,4895,4895,4895,4895,4895,4895,4896,4896,4896,4896,4896,4896,4898,4898,4898,4898,4898,4898,4899,4899,4899,4899,4899,4899,4900,4900,4900,4900,4900,4900,7212,7212,7212,7212,7212,7211,7211,7211,7211,7211,7213,7213,7213,7213,7213,7214,7214,7214,7214,7214,7215,7215,7215,7215,7215,4887,7274,7274,7274,7274,7274,7277,7277,7277,7277,7277,7275,7275,7275,7275,7275,7276,7276,7276,7276,7276,7273,7273,7273,7273,7273,4923,4923,4924,4924,8744,7278,7278,7278,7278,7278,7279,7279,7279,7279,7279,7282,7282,7282,7282,7282,7280,7280,7280,7280,7280,7281,7281,7281,7281,7281,8072,74,74,75,75) | 0.001 | 1 |
SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`shop_configuration`) | 0.000 | 8 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-text'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_1'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_2'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_domain'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`missing_labels`)
WHERE `label_key` = 'attribute.attrib_cat-11'
AND `module` = 'attribute'
AND `language` = 'pl_PL'
AND `url` = '/kategoria/kubki-ceramiczne/44?page=2' | 0.000 | 1 |
UPDATE `missing_labels` SET `count` = 5 WHERE `label_key` = 'attribute.attrib_cat-11' AND `module` = 'attribute' AND `language` = 'pl_PL' AND `url` = '/kategoria/kubki-ceramiczne/44?page=2' | 0.000 | 1 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '74' | 0.000 | 2 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '74'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 2 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '8074' | 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`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '8074'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '8541' | 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`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '8541'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '8543' | 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`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '8543'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '8545' | 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`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '8545'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '7197' | 0.000 | 5 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '7198'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 5 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '7293' | 0.000 | 6 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '7298'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 6 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '4880' | 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`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '4880'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '9336' | 0.000 | 9 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '9344'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 5 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '7192' | 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`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '7192'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 1 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '7193' | 0.000 | 4 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '7196'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 4 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '7241' | 0.000 | 5 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '7242'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 5 |
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: 88 | 0.062 | 4069 |