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` = '24' | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '2' | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '1' | 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` = 24 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (2,1)
ORDER BY `level` ASC | 0.000 | 2 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '24'
LIMIT 0, 1 | 0.001 | 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 (24) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.042 | 653 |
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 (9989,9989,9989,9989,9989,9989,9302,9302,9302,10001,10001,10001,10001,6649,2236,4368,4368,4369,4369,6572,1899,1899,10119,10119,5102,5102,5102,5103,5103,5103,5101,5101,5101,3052,5065,7431,7147,7147,7147,7147,7144,7144,7144,7144,7145,7145,7145,7145,7146,7146,7146,7146,4586,10004,8690,26,3945,4471,7429,2982,2982,2983,2983,7425,4728,4627,4627,4627,4627,4629,4629,4629,4629,4626,4626,4626,4626,4628,4628,4628,4628,7083,477,3477,3584,7080,7080,7081,7081,3427,7883,7884,8048,9009,9007,8697,9998,3439,9978,9978,9978,9978,9978,9978,9979,9979,9979,9979,9979,9979,9980,9980,9980,9980,9980,9980,9981,9981,9981,9981,9981,9981,9982,9982,9982,9982,9982,9982,5499,5499,5499,5499,5499,5495,5495,5495,5495,5495,5497,5497,5497,5497,5497,5498,5498,5498,5498,5498,5496,5496,5496,5496,5496,8717,8167,4631,4631,4632,4632,3055,4373,8178,4154,4154,4154,4154,4154,4152,4152,4152,4152,4152,4153,4153,4153,4153,4153,4155,4155,4155,4155,4155,4156,4156,4156,4156,4156,4351,4351,4351,4351,4351,4350,4350,4350,4350,4350,4353,4353,4353,4353,4353,4349,4349,4349,4349,4349,4352,4352,4352,4352,4352,8753,9017,9018,8754,8689,8755,8740,5487,3054,7085,5485,4587,3473,3473,3472,3472,7427,7062,7062,7062,7062,7062,7061,7061,7061,7061,7061,7063,7063,7063,7063,7063,7065,7065,7065,7065,7065,7064,7064,7064,7064,7064,8764,2978,2978,2979,2979,2980,2980,2981,2981,5491,4724,4724,4724,4724,4724,4724,4722,4722,4722,4722,4722,4722,4726,4726,4726,4726,4726,4726,4725,4725,4725,4725,4725,4725,4723,4723,4723,4723,4723,4723,4721,4721,4721,4721,4721,4721,4583,4583,4584,4584,8674,7430,8739,9330,9330,9330,9330,9330,9330,9329,9329,9329,9329,9329,9329,9328,9328,9328,9328,9328,9328,9332,9332,9332,9332,9332,9332,9327,9327,9327,9327,9327,9327,9331,9331,9331,9331,9331,9331,7434,6556,6556,6556,6556,6555,6555,6555,6555,6554,6554,6554,6554,6557,6557,6557,6557,9301,9301,9301,9303,9303,9303,9142,10024,3444,9997,7103,8659,5254,5253,6955,9128,7056,7056,7056,7056,7056,7052,7052,7052,7052,7052,7055,7055,7055,7055,7055,7053,7053,7053,7053,7053,7054,7054,7054,7054,7054,7136,8143,7084,8151,10000,10000,10000,10000,10002,10002,10002,10002,10003,10003,10003,10003,3068,7050,7050,7050,7050,7050,7051,7051,7051,7051,7051,7047,7047,7047,7047,7047,7049,7049,7049,7049,7049,7048,7048,7048,7048,7048,7421,7422,7423,7420,7426,7135,6562,6562,6562,6562,6562,6561,6561,6561,6561,6561,6559,6559,6559,6559,6559,6558,6558,6558,6558,6558,6560,6560,6560,6560,6560,4630,7045,7045,7046,7046,8333,8334,8197,8649,5489,9136,9136,8179,8179,6657,6657,6657,6657,6657,6661,6661,6661,6661,6661,6659,6659,6659,6659,6659,6660,6660,6660,6660,6660,6658,6658,6658,6658,6658,3927,7134,7134,7134,7132,7132,7132,7133,7133,7133,7031,7082,7435,7432,7137,7137,7137,7137,7137,7137,7137,7138,7138,7138,7138,7138,7138,7138,7139,7139,7139,7139,7139,7139,7139,7141,7141,7141,7141,7141,7141,7141,7142,7142,7142,7142,7142,7142,7142,7143,7143,7143,7143,7143,7143,7143,7140,7140,7140,7140,7140,7140,7140,5060,5060,5060,5060,5061,5061,5061,5061,5063,5063,5063,5063,5062,5062,5062,5062,3946,8199,8204,4727,8738,8756,7840,7840,7840,7840,7840,7841,7841,7841,7841,7841,7842,7842,7842,7842,7842,7843,7843,7843,7843,7843,7844,7844,7844,7844,7844,4625,4574,4574,4574,4574,4571,4571,4571,4571,4573,4573,4573,4573,4572,4572,4572,4572,9238,9994,3429,9139,9120,9121,8275,7437,8118,8119,8116,8117,3057) ) as s GROUP BY id_product_ps ) as ss | 0.006 | 137 |
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 (9989,9989,9989,9989,9989,9989,9302,9302,9302,10001,10001,10001,10001,6649,2236,4368,4368,4369,4369,6572,1899,1899,10119,10119,5102,5102,5102,5103,5103,5103,5101,5101,5101,3052,5065,7431,7147,7147,7147,7147,7144,7144,7144,7144,7145,7145,7145,7145,7146,7146,7146,7146,4586,10004,8690,26,3945,4471,7429,2982,2982,2983,2983,7425,4728,4627,4627,4627,4627,4629,4629,4629,4629,4626,4626,4626,4626,4628,4628,4628,4628,7083,477,3477,3584,7080,7080,7081,7081,3427,7883,7884,8048,9009,9007,8697,9998,3439,9978,9978,9978,9978,9978,9978,9979,9979,9979,9979,9979,9979,9980,9980,9980,9980,9980,9980,9981,9981,9981,9981,9981,9981,9982,9982,9982,9982,9982,9982,5499,5499,5499,5499,5499,5495,5495,5495,5495,5495,5497,5497,5497,5497,5497,5498,5498,5498,5498,5498,5496,5496,5496,5496,5496,8717,8167,4631,4631,4632,4632,3055,4373,8178,4154,4154,4154,4154,4154,4152,4152,4152,4152,4152,4153,4153,4153,4153,4153,4155,4155,4155,4155,4155,4156,4156,4156,4156,4156,4351,4351,4351,4351,4351,4350,4350,4350,4350,4350,4353,4353,4353,4353,4353,4349,4349,4349,4349,4349,4352,4352,4352,4352,4352,8753,9017,9018,8754,8689,8755,8740,5487,3054,7085,5485,4587,3473,3473,3472,3472,7427,7062,7062,7062,7062,7062,7061,7061,7061,7061,7061,7063,7063,7063,7063,7063,7065,7065,7065,7065,7065,7064,7064,7064,7064,7064,8764,2978,2978,2979,2979,2980,2980,2981,2981,5491,4724,4724,4724,4724,4724,4724,4722,4722,4722,4722,4722,4722,4726,4726,4726,4726,4726,4726,4725,4725,4725,4725,4725,4725,4723,4723,4723,4723,4723,4723,4721,4721,4721,4721,4721,4721,4583,4583,4584,4584,8674,7430,8739,9330,9330,9330,9330,9330,9330,9329,9329,9329,9329,9329,9329,9328,9328,9328,9328,9328,9328,9332,9332,9332,9332,9332,9332,9327,9327,9327,9327,9327,9327,9331,9331,9331,9331,9331,9331,7434,6556,6556,6556,6556,6555,6555,6555,6555,6554,6554,6554,6554,6557,6557,6557,6557,9301,9301,9301,9303,9303,9303,9142,10024,3444,9997,7103,8659,5254,5253,6955,9128,7056,7056,7056,7056,7056,7052,7052,7052,7052,7052,7055,7055,7055,7055,7055,7053,7053,7053,7053,7053,7054,7054,7054,7054,7054,7136,8143,7084,8151,10000,10000,10000,10000,10002,10002,10002,10002,10003,10003,10003,10003,3068,7050,7050,7050,7050,7050,7051,7051,7051,7051,7051,7047,7047,7047,7047,7047,7049,7049,7049,7049,7049,7048,7048,7048,7048,7048,7421,7422,7423,7420,7426,7135,6562,6562,6562,6562,6562,6561,6561,6561,6561,6561,6559,6559,6559,6559,6559,6558,6558,6558,6558,6558,6560,6560,6560,6560,6560,4630,7045,7045,7046,7046,8333,8334,8197,8649,5489,9136,9136,8179,8179,6657,6657,6657,6657,6657,6661,6661,6661,6661,6661,6659,6659,6659,6659,6659,6660,6660,6660,6660,6660,6658,6658,6658,6658,6658,3927,7134,7134,7134,7132,7132,7132,7133,7133,7133,7031,7082,7435,7432,7137,7137,7137,7137,7137,7137,7137,7138,7138,7138,7138,7138,7138,7138,7139,7139,7139,7139,7139,7139,7139,7141,7141,7141,7141,7141,7141,7141,7142,7142,7142,7142,7142,7142,7142,7143,7143,7143,7143,7143,7143,7143,7140,7140,7140,7140,7140,7140,7140,5060,5060,5060,5060,5061,5061,5061,5061,5063,5063,5063,5063,5062,5062,5062,5062,3946,8199,8204,4727,8738,8756,7840,7840,7840,7840,7840,7841,7841,7841,7841,7841,7842,7842,7842,7842,7842,7843,7843,7843,7843,7843,7844,7844,7844,7844,7844,4625,4574,4574,4574,4574,4571,4571,4571,4571,4573,4573,4573,4573,4572,4572,4572,4572,9238,9994,3429,9139,9120,9121,8275,7437,8118,8119,8116,8117,3057) ) 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.008 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (9989,9989,9989,9989,9989,9989,9302,9302,9302,10001,10001,10001,10001,6649,2236,4368,4368,4369,4369,6572,1899,1899,10119,10119,5102,5102,5102,5103,5103,5103,5101,5101,5101,3052,5065,7431,7147,7147,7147,7147,7144,7144,7144,7144,7145,7145,7145,7145,7146,7146,7146,7146,4586,10004,8690,26,3945,4471,7429,2982,2982,2983,2983,7425,4728,4627,4627,4627,4627,4629,4629,4629,4629,4626,4626,4626,4626,4628,4628,4628,4628,7083,477,3477,3584,7080,7080,7081,7081,3427,7883,7884,8048,9009,9007,8697,9998,3439,9978,9978,9978,9978,9978,9978,9979,9979,9979,9979,9979,9979,9980,9980,9980,9980,9980,9980,9981,9981,9981,9981,9981,9981,9982,9982,9982,9982,9982,9982,5499,5499,5499,5499,5499,5495,5495,5495,5495,5495,5497,5497,5497,5497,5497,5498,5498,5498,5498,5498,5496,5496,5496,5496,5496,8717,8167,4631,4631,4632,4632,3055,4373,8178,4154,4154,4154,4154,4154,4152,4152,4152,4152,4152,4153,4153,4153,4153,4153,4155,4155,4155,4155,4155,4156,4156,4156,4156,4156,4351,4351,4351,4351,4351,4350,4350,4350,4350,4350,4353,4353,4353,4353,4353,4349,4349,4349,4349,4349,4352,4352,4352,4352,4352,8753,9017,9018,8754,8689,8755,8740,5487,3054,7085,5485,4587,3473,3473,3472,3472,7427,7062,7062,7062,7062,7062,7061,7061,7061,7061,7061,7063,7063,7063,7063,7063,7065,7065,7065,7065,7065,7064,7064,7064,7064,7064,8764,2978,2978,2979,2979,2980,2980,2981,2981,5491,4724,4724,4724,4724,4724,4724,4722,4722,4722,4722,4722,4722,4726,4726,4726,4726,4726,4726,4725,4725,4725,4725,4725,4725,4723,4723,4723,4723,4723,4723,4721,4721,4721,4721,4721,4721,4583,4583,4584,4584,8674,7430,8739,9330,9330,9330,9330,9330,9330,9329,9329,9329,9329,9329,9329,9328,9328,9328,9328,9328,9328,9332,9332,9332,9332,9332,9332,9327,9327,9327,9327,9327,9327,9331,9331,9331,9331,9331,9331,7434,6556,6556,6556,6556,6555,6555,6555,6555,6554,6554,6554,6554,6557,6557,6557,6557,9301,9301,9301,9303,9303,9303,9142,10024,3444,9997,7103,8659,5254,5253,6955,9128,7056,7056,7056,7056,7056,7052,7052,7052,7052,7052,7055,7055,7055,7055,7055,7053,7053,7053,7053,7053,7054,7054,7054,7054,7054,7136,8143,7084,8151,10000,10000,10000,10000,10002,10002,10002,10002,10003,10003,10003,10003,3068,7050,7050,7050,7050,7050,7051,7051,7051,7051,7051,7047,7047,7047,7047,7047,7049,7049,7049,7049,7049,7048,7048,7048,7048,7048,7421,7422,7423,7420,7426,7135,6562,6562,6562,6562,6562,6561,6561,6561,6561,6561,6559,6559,6559,6559,6559,6558,6558,6558,6558,6558,6560,6560,6560,6560,6560,4630,7045,7045,7046,7046,8333,8334,8197,8649,5489,9136,9136,8179,8179,6657,6657,6657,6657,6657,6661,6661,6661,6661,6661,6659,6659,6659,6659,6659,6660,6660,6660,6660,6660,6658,6658,6658,6658,6658,3927,7134,7134,7134,7132,7132,7132,7133,7133,7133,7031,7082,7435,7432,7137,7137,7137,7137,7137,7137,7137,7138,7138,7138,7138,7138,7138,7138,7139,7139,7139,7139,7139,7139,7139,7141,7141,7141,7141,7141,7141,7141,7142,7142,7142,7142,7142,7142,7142,7143,7143,7143,7143,7143,7143,7143,7140,7140,7140,7140,7140,7140,7140,5060,5060,5060,5060,5061,5061,5061,5061,5063,5063,5063,5063,5062,5062,5062,5062,3946,8199,8204,4727,8738,8756,7840,7840,7840,7840,7840,7841,7841,7841,7841,7841,7842,7842,7842,7842,7842,7843,7843,7843,7843,7843,7844,7844,7844,7844,7844,4625,4574,4574,4574,4574,4571,4571,4571,4571,4573,4573,4573,4573,4572,4572,4572,4572,9238,9994,3429,9139,9120,9121,8275,7437,8118,8119,8116,8117,3057) | 0.001 | 653 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (26,477,10119,1899,2236,2978,2979,2978,2979,2980,2981,2980,2981,2982,2983,2982,2983,3052,3054,3055,3057,3068,3427,3429,3439,3444,3473,3472,3472,3473,3477,3584,3927,3945,3946,4153,4154,4156,4152,4155,4154,4155,4152,4156,4153,4152,4156,4155,4154,4153,4156,4152,4154,4155,4153,4155,4154,4152,4156,4153,4350,4351,4353,4352,4349,4351,4352,4349,4353,4350,4349,4353,4351,4352,4350,4353,4349,4351,4350,4352,4352,4351,4349,4350,4353,4368,4369,4368,4369,4373,4471,4574,4572,4571,4573,4574,4571,4573,4572,4574,4571,4572,4573,4573,4572,4571,4574,4584,4583,4583,4584,4586,4587,4625,4629,4627,4626,4628,4626,4629,4628,4627,4626,4629,4627,4628,4628,4626,4627,4629,4630,4631,4632,4631,4632,4726,4722,4725,4723,4721,4724,4726,4725,4723,4721,4724,4722,4722,4726,4721,4725,4723,4724,4726,4722,4725,4721,4723,4724,4722,4726,4724,4721,4723,4725,4725,4724,4722,4723,4721,4726,4727,4728,5063,5061,5062,5060,5063,5060,5062,5061,5063,5060,5061,5062,5062,5060,5061,5063,5065,5102,5103,5101,5103,5102,5101,5102,5103,5101,5253,5254,5485,5487,5489,5491,5496,5497,5499,5498,5495,5497,5495,5498,5499,5496,5495,5499,5498,5497,5496,5499,5497,5495,5496,5498,5498,5497,5495,5496,5499,6557,6555,6556,6554,6554,6557,6556,6555,6554,6557,6555,6556,6556,6554,6555,6557,6559,6560,6562,6558,6561,6560,6558,6561,6562,6559,6558,6562,6560,6561,6559,6562,6560,6558,6561,6559,6561,6560,6558,6559,6562,6572,6649,6658,6659,6661,6657,6660,6659,6660,6657,6661,6658,6657,6661,6659,6660,6658,6661,6657,6659,6658,6660,6660,6659,6657,6661,6658,6955,7031,7045,7046,7045,7046,7048,7049,7051,7047,7050,7049,7050,7047,7051,7048,7047,7051,7049,7050,7048,7051,7047,7049,7048,7050,7050,7049,7047,7048,7051,7053,7054,7056,7055,7052,7054,7055,7052,7056,7053,7052,7056,7055,7054,7053,7056,7054,7052,7055,7053,7055,7054,7052,7056,7053,7062,7063,7065,7064,7061,7063,7064,7061,7065,7062,7061,7065,7064,7063,7062,7065,7063,7061,7062,7064,7064,7063,7061,7062,7065,7080,7081,7080,7081,7082,7083,7084,7085,7103,7133,7134,7132,7134,7133,7132,7133,7134,7132,7135,7136,7139,7143,7142,7138,7140,7141,7137,7139,7140,7143,7142,7137,7141,7138,7140,7142,7138,7143,7141,7137,7139,7138,7143,7137,7142,7141,7140,7139,7143,7138,7142,7140,7137,7141,7139,7143,7141,7138,7140,7137,7139,7142,7142,7141,7138,7140,7137,7143,7139,7147,7145,7146,7144,7147,7144,7146,7145,7147,7144,7145,7146,7146,7145,7144,7147,7420,7421,7422,7423,7425,7426,7427,7429,7430,7431,7432,7434,7435,7437,7841,7842,7844,7840,7843,7842,7843,7840,7844,7841,7840,7844,7843,7842,7841,7844,7842,7840,7843,7841,7843,7842,7840,7841,7844,7883,7884,8048,8116,8117,8118,8119,8143,8151,8167,8178,9136,8179,8197,8199,8204,8275,8333,8334,8649,8659,8674,8689,8690,8697,8717,8738,8739,8740,8753,8754,8755,8756,8764,9007,9009,9017,9018,9120,9121,9128,8179,9136,9139,9142,9238,9302,9303,9301,9302,9303,9301,9302,9301,9303,9332,9328,9331,9329,9330,9327,9332,9331,9327,9329,9330,9328,9328,9332,9327,9331,9329,9330,9328,9332,9331,9327,9329,9330,9332,9328,9330,9327,9329,9331,9331,9328,9330,9327,9329,9332,9989,9979,9982,9980,9978,9981,9989,9982,9980,9978,9981,9979,9979,9989,9978,9982,9980,9981,9979,9989,9982,9978,9980,9981,9979,9989,9981,9978,9980,9982,9982,9981,9979,9978,9980,9989,9994,9997,9998,10003,10001,10000,10002,10003,10000,10001,10002,10003,10000,10001,10002,10002,10000,10001,10003,10004,10024,10119,1899) | 0.001 | 653 |
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 (26,477,10119,1899,2236,2979,2978,2979,2978,2981,2980,2981,2980,2983,2982,2983,2982,3052,3054,3055,3057,3068,3427,3429,3439,3444,3473,3472,3472,3473,3477,3584,3927,3945,3946,4153,4154,4156,4155,4152,4152,4153,4156,4155,4154,4153,4156,4152,4155,4154,4156,4153,4154,4152,4155,4155,4153,4154,4152,4156,4350,4351,4353,4352,4349,4349,4350,4353,4352,4351,4350,4353,4349,4352,4351,4353,4350,4351,4349,4352,4352,4350,4351,4349,4353,4369,4368,4368,4369,4373,4471,4573,4574,4572,4571,4574,4571,4573,4572,4574,4571,4572,4573,4573,4571,4574,4572,4584,4583,4583,4584,4586,4587,4625,4628,4629,4627,4626,4629,4628,4626,4627,4629,4626,4627,4628,4628,4626,4629,4627,4630,4632,4631,4631,4632,4726,4722,4723,4725,4724,4721,4725,4726,4724,4723,4721,4722,4726,4722,4725,4721,4724,4723,4726,4725,4722,4721,4724,4723,4726,4722,4724,4721,4725,4723,4725,4724,4722,4721,4723,4726,4727,4728,5062,5063,5061,5060,5063,5060,5062,5061,5063,5060,5061,5062,5062,5060,5061,5063,5065,5101,5103,5102,5103,5101,5102,5102,5101,5103,5253,5254,5485,5487,5489,5491,5496,5497,5499,5498,5495,5495,5496,5499,5498,5497,5496,5499,5495,5498,5497,5499,5496,5497,5495,5498,5498,5496,5497,5495,5499,6556,6557,6555,6554,6557,6556,6554,6555,6557,6554,6555,6556,6556,6554,6555,6557,6559,6560,6562,6561,6558,6558,6559,6562,6561,6560,6559,6562,6558,6561,6560,6562,6559,6560,6558,6561,6561,6559,6560,6558,6562,6572,6649,6658,6659,6661,6660,6657,6657,6658,6661,6660,6659,6658,6661,6657,6660,6659,6661,6658,6659,6657,6660,6660,6658,6659,6657,6661,6955,7031,7046,7045,7046,7045,7048,7049,7051,7050,7047,7047,7048,7051,7050,7049,7048,7051,7047,7050,7049,7051,7048,7049,7047,7050,7050,7048,7049,7047,7051,7053,7054,7056,7055,7052,7052,7053,7056,7055,7054,7053,7056,7052,7055,7054,7056,7053,7054,7052,7055,7055,7053,7054,7052,7056,7062,7063,7065,7064,7061,7061,7062,7065,7064,7063,7062,7065,7061,7064,7063,7065,7062,7063,7061,7064,7064,7062,7063,7061,7065,7081,7080,7081,7080,7082,7083,7084,7085,7103,7132,7134,7133,7132,7134,7133,7133,7132,7134,7135,7136,7139,7140,7143,7138,7142,7141,7137,7139,7140,7143,7142,7141,7137,7138,7138,7137,7143,7139,7142,7141,7140,7139,7143,7138,7142,7137,7141,7140,7143,7139,7142,7138,7140,7137,7141,7143,7139,7138,7141,7137,7140,7142,7142,7139,7141,7140,7138,7137,7143,7146,7147,7145,7144,7147,7144,7146,7145,7147,7144,7145,7146,7146,7144,7145,7147,7420,7421,7422,7423,7425,7426,7427,7429,7430,7431,7432,7434,7435,7437,7841,7842,7844,7843,7840,7840,7844,7841,7843,7842,7841,7844,7840,7843,7842,7844,7841,7842,7840,7843,7843,7841,7842,7840,7844,7883,7884,8048,8116,8117,8118,8119,8143,8151,8167,8178,8179,9136,8197,8199,8204,8275,8333,8334,8649,8659,8674,8689,8690,8697,8717,8738,8739,8740,8753,8754,8755,8756,8764,9007,9009,9017,9018,9120,9121,9128,8179,9136,9139,9142,9238,9301,9303,9302,9303,9301,9302,9301,9302,9303,9332,9328,9329,9331,9330,9327,9331,9332,9330,9329,9327,9328,9332,9328,9331,9327,9330,9329,9332,9331,9328,9327,9330,9329,9332,9328,9330,9327,9331,9329,9331,9330,9328,9327,9329,9332,9989,9979,9980,9982,9981,9978,9982,9989,9981,9980,9978,9979,9989,9979,9982,9978,9981,9980,9989,9982,9979,9978,9980,9981,9989,9979,9981,9978,9980,9982,9982,9981,9979,9978,9980,9989,9994,9997,9998,10002,10003,10001,10000,10003,10000,10002,10001,10003,10000,10002,10001,10002,10000,10001,10003,10004,10024,1899,10119)
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` = 24 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 2 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 1 | 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` = '24'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.002 | 33 |
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 (9989,9989,9989,9989,9989,9989,9302,9302,9302,10001,10001,10001,10001,6649,2236,4368,4368,4369,4369,6572,1899,1899,10119,10119,5102,5102,5102,5103,5103,5103,5101,5101,5101,3052,5065,7431,7147,7147,7147,7147,7144,7144,7144,7144,7145,7145,7145,7145,7146,7146,7146,7146,4586,10004,8690,26,3945,4471,7429,2982,2982,2983,2983,7425,4728,4627,4627,4627,4627,4629,4629,4629,4629,4626,4626,4626,4626,4628,4628,4628,4628,7083,477,3477,3584,7080,7080,7081,7081,3427,7883,7884,8048,9009,9007,8697,9998,3439,9978,9978,9978,9978,9978,9978,9979,9979,9979,9979,9979,9979,9980,9980,9980,9980,9980,9980,9981,9981,9981,9981,9981,9981,9982,9982,9982,9982,9982,9982,5499,5499,5499,5499,5499,5495,5495,5495,5495,5495,5497,5497,5497,5497,5497,5498,5498,5498,5498,5498,5496,5496,5496,5496,5496,8717,8167,4631,4631,4632,4632,3055,4373,8178,4154,4154,4154,4154,4154,4152,4152,4152,4152,4152,4153,4153,4153,4153,4153,4155,4155,4155,4155,4155,4156,4156,4156,4156,4156,4351,4351,4351,4351,4351,4350,4350,4350,4350,4350,4353,4353,4353,4353,4353,4349,4349,4349,4349,4349,4352,4352,4352,4352,4352,8753,9017,9018,8754,8689,8755,8740,5487,3054,7085,5485,4587,3473,3473,3472,3472,7427,7062,7062,7062,7062,7062,7061,7061,7061,7061,7061,7063,7063,7063,7063,7063,7065,7065,7065,7065,7065,7064,7064,7064,7064,7064,8764,2978,2978,2979,2979,2980,2980,2981,2981,5491,4724,4724,4724,4724,4724,4724,4722,4722,4722,4722,4722,4722,4726,4726,4726,4726,4726,4726,4725,4725,4725,4725,4725,4725,4723,4723,4723,4723,4723,4723,4721,4721,4721,4721,4721,4721,4583,4583,4584,4584,8674,7430,8739,9330,9330,9330,9330,9330,9330,9329,9329,9329,9329,9329,9329,9328,9328,9328,9328,9328,9328,9332,9332,9332,9332,9332,9332,9327,9327,9327,9327,9327,9327,9331,9331,9331,9331,9331,9331,7434,6556,6556,6556,6556,6555,6555,6555,6555,6554,6554,6554,6554,6557,6557,6557,6557,9301,9301,9301,9303,9303,9303,9142,10024,3444,9997,7103,8659,5254,5253,6955,9128,7056,7056,7056,7056,7056,7052,7052,7052,7052,7052,7055,7055,7055,7055,7055,7053,7053,7053,7053,7053,7054,7054,7054,7054,7054,7136,8143,7084,8151,10000,10000,10000,10000,10002,10002,10002,10002,10003,10003,10003,10003,3068,7050,7050,7050,7050,7050,7051,7051,7051,7051,7051,7047,7047,7047,7047,7047,7049,7049,7049,7049,7049,7048,7048,7048,7048,7048,7421,7422,7423,7420,7426,7135,6562,6562,6562,6562,6562,6561,6561,6561,6561,6561,6559,6559,6559,6559,6559,6558,6558,6558,6558,6558,6560,6560,6560,6560,6560,4630,7045,7045,7046,7046,8333,8334,8197,8649,5489,9136,9136,8179,8179,6657,6657,6657,6657,6657,6661,6661,6661,6661,6661,6659,6659,6659,6659,6659,6660,6660,6660,6660,6660,6658,6658,6658,6658,6658,3927,7134,7134,7134,7132,7132,7132,7133,7133,7133,7031,7082,7435,7432,7137,7137,7137,7137,7137,7137,7137,7138,7138,7138,7138,7138,7138,7138,7139,7139,7139,7139,7139,7139,7139,7141,7141,7141,7141,7141,7141,7141,7142,7142,7142,7142,7142,7142,7142,7143,7143,7143,7143,7143,7143,7143,7140,7140,7140,7140,7140,7140,7140,5060,5060,5060,5060,5061,5061,5061,5061,5063,5063,5063,5063,5062,5062,5062,5062,3946,8199,8204,4727,8738,8756,7840,7840,7840,7840,7840,7841,7841,7841,7841,7841,7842,7842,7842,7842,7842,7843,7843,7843,7843,7843,7844,7844,7844,7844,7844,4625,4574,4574,4574,4574,4571,4571,4571,4571,4573,4573,4573,4573,4572,4572,4572,4572,9238,9994,3429,9139,9120,9121,8275,7437,8118,8119,8116,8117,3057) | 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 (9989,9989,9989,9989,9989,9989,9302,9302,9302,10001,10001,10001,10001,6649,2236,4368,4368,4369,4369,6572,1899,1899,10119,10119,5102,5102,5102,5103,5103,5103,5101,5101,5101,3052,5065,7431,7147,7147,7147,7147,7144,7144,7144,7144,7145,7145,7145,7145,7146,7146,7146,7146,4586,10004,8690,26,3945,4471,7429,2982,2982,2983,2983,7425,4728,4627,4627,4627,4627,4629,4629,4629,4629,4626,4626,4626,4626,4628,4628,4628,4628,7083,477,3477,3584,7080,7080,7081,7081,3427,7883,7884,8048,9009,9007,8697,9998,3439,9978,9978,9978,9978,9978,9978,9979,9979,9979,9979,9979,9979,9980,9980,9980,9980,9980,9980,9981,9981,9981,9981,9981,9981,9982,9982,9982,9982,9982,9982,5499,5499,5499,5499,5499,5495,5495,5495,5495,5495,5497,5497,5497,5497,5497,5498,5498,5498,5498,5498,5496,5496,5496,5496,5496,8717,8167,4631,4631,4632,4632,3055,4373,8178,4154,4154,4154,4154,4154,4152,4152,4152,4152,4152,4153,4153,4153,4153,4153,4155,4155,4155,4155,4155,4156,4156,4156,4156,4156,4351,4351,4351,4351,4351,4350,4350,4350,4350,4350,4353,4353,4353,4353,4353,4349,4349,4349,4349,4349,4352,4352,4352,4352,4352,8753,9017,9018,8754,8689,8755,8740,5487,3054,7085,5485,4587,3473,3473,3472,3472,7427,7062,7062,7062,7062,7062,7061,7061,7061,7061,7061,7063,7063,7063,7063,7063,7065,7065,7065,7065,7065,7064,7064,7064,7064,7064,8764,2978,2978,2979,2979,2980,2980,2981,2981,5491,4724,4724,4724,4724,4724,4724,4722,4722,4722,4722,4722,4722,4726,4726,4726,4726,4726,4726,4725,4725,4725,4725,4725,4725,4723,4723,4723,4723,4723,4723,4721,4721,4721,4721,4721,4721,4583,4583,4584,4584,8674,7430,8739,9330,9330,9330,9330,9330,9330,9329,9329,9329,9329,9329,9329,9328,9328,9328,9328,9328,9328,9332,9332,9332,9332,9332,9332,9327,9327,9327,9327,9327,9327,9331,9331,9331,9331,9331,9331,7434,6556,6556,6556,6556,6555,6555,6555,6555,6554,6554,6554,6554,6557,6557,6557,6557,9301,9301,9301,9303,9303,9303,9142,10024,3444,9997,7103,8659,5254,5253,6955,9128,7056,7056,7056,7056,7056,7052,7052,7052,7052,7052,7055,7055,7055,7055,7055,7053,7053,7053,7053,7053,7054,7054,7054,7054,7054,7136,8143,7084,8151,10000,10000,10000,10000,10002,10002,10002,10002,10003,10003,10003,10003,3068,7050,7050,7050,7050,7050,7051,7051,7051,7051,7051,7047,7047,7047,7047,7047,7049,7049,7049,7049,7049,7048,7048,7048,7048,7048,7421,7422,7423,7420,7426,7135,6562,6562,6562,6562,6562,6561,6561,6561,6561,6561,6559,6559,6559,6559,6559,6558,6558,6558,6558,6558,6560,6560,6560,6560,6560,4630,7045,7045,7046,7046,8333,8334,8197,8649,5489,9136,9136,8179,8179,6657,6657,6657,6657,6657,6661,6661,6661,6661,6661,6659,6659,6659,6659,6659,6660,6660,6660,6660,6660,6658,6658,6658,6658,6658,3927,7134,7134,7134,7132,7132,7132,7133,7133,7133,7031,7082,7435,7432,7137,7137,7137,7137,7137,7137,7137,7138,7138,7138,7138,7138,7138,7138,7139,7139,7139,7139,7139,7139,7139,7141,7141,7141,7141,7141,7141,7141,7142,7142,7142,7142,7142,7142,7142,7143,7143,7143,7143,7143,7143,7143,7140,7140,7140,7140,7140,7140,7140,5060,5060,5060,5060,5061,5061,5061,5061,5063,5063,5063,5063,5062,5062,5062,5062,3946,8199,8204,4727,8738,8756,7840,7840,7840,7840,7840,7841,7841,7841,7841,7841,7842,7842,7842,7842,7842,7843,7843,7843,7843,7843,7844,7844,7844,7844,7844,4625,4574,4574,4574,4574,4571,4571,4571,4571,4573,4573,4573,4573,4572,4572,4572,4572,9238,9994,3429,9139,9120,9121,8275,7437,8118,8119,8116,8117,3057) | 0.001 | 1 |
SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`shop_configuration`) | 0.000 | 8 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-text'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'header-phone'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_1'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'social_link_2'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_domain'
LIMIT 0, 1 | 0.000 | 1 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '7423' | 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` = '7423'
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` = '7429' | 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` = '7429'
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` = '7430' | 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` = '7430'
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` = '6649' | 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` = '6649'
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` = '8764' | 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` = '8764'
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` = '7135' | 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` = '7135'
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` = '4727' | 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` = '4727'
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` = '7422' | 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` = '7422'
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` = '7431' | 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` = '7431'
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` = '7434' | 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` = '7434'
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` = '8689' | 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` = '8689'
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` = '4571' | 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` = '4574'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 4 |
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: 86 | 0.076 | 4315 |