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.001 | 113 |
SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
SELECT *
FROM (`shop_parameters` AS `p`)
INNER JOIN `shop_parameters_description` AS `pd` ON (`pd`.`parameter_id` = `p`.`id_parameter`)
WHERE `p`.`active` = 'Y' | 0.000 | 1 |
SELECT `shop_parameters`.*, `shop_product_parameters`.*, `shop_parameters_values`.*
FROM (`shop_parameters`)
LEFT JOIN `shop_product_parameters` ON (`shop_product_parameters`.`parameter_id` = `shop_parameters`.`id_parameter`)
LEFT JOIN `shop_products_parameters` ON (`shop_products_parameters`.`product_id` = `shop_product_parameters`.`product_id`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`id_parameter_value` ASC | 0.005 | 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` = '47' | 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` = 47 | 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` = '47'
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 (47) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.084 | 548 |
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 (9566,9566,9566,9566,9566,9566,9566,9566,9551,9551,9551,9551,9551,9548,9548,9548,9548,9548,9571,9571,9571,9571,9571,9571,4401,4401,4401,4401,4401,9558,9558,9558,9558,9558,7015,7015,7015,7016,7016,7016,7017,7017,7017,9125,8978,8633,8829,8829,8829,8825,8830,8830,8830,8528,8528,8528,8531,8537,8551,1302,8839,8838,8550,8840,8845,8845,8845,1308,8841,8841,8841,8844,8843,8842,8842,8842,3442,3442,3441,3441,3443,7789,7789,7789,7789,7788,7788,7788,7788,7790,7790,7790,7790,7791,7791,7791,7791,6598,6598,6598,6598,6598,6598,6598,6602,6602,6602,6602,6602,6602,6602,6597,6597,6597,6597,6597,6597,6597,6599,6599,6599,6599,6599,6599,6599,6601,6601,6601,6601,6601,6601,6601,6600,6600,6600,6600,6600,6600,6600,6603,6603,6603,6603,6603,6603,6603,7806,7806,7806,7806,7807,7807,7807,7807,7808,7808,7808,7808,7809,7809,7809,7809,9559,9559,9559,9559,9559,9559,9559,9559,9560,9560,9560,9560,9560,9560,9560,9560,9561,9561,9561,9561,9561,9561,9561,9561,9563,9563,9563,9563,9563,9563,9563,9563,9564,9564,9564,9564,9564,9564,9564,9564,9562,9562,9562,9562,9562,9562,9562,9562,9565,9565,9565,9565,9565,9565,9565,9565,9549,9549,9549,9549,9549,9550,9550,9550,9550,9550,9552,9552,9552,9552,9552,9553,9553,9553,9553,9553,7810,7810,7810,7810,7811,7811,7811,7811,7812,7812,7812,7812,7813,7813,7813,7813,7774,7774,7774,7775,7775,7775,7776,7776,7776,8078,9547,9547,9547,9547,9547,9546,9546,9546,9546,9546,9545,9545,9545,9545,9545,9533,9533,9533,9533,9533,7240,4945,4945,4945,4945,4945,4945,4945,4946,4946,4946,4946,4946,4946,4946,4949,4949,4949,4949,4949,4949,4949,4943,4943,4943,4943,4943,4943,4943,4944,4944,4944,4944,4944,4944,4944,4948,4948,4948,4948,4948,4948,4948,4947,4947,4947,4947,4947,4947,4947,6204,6204,6205,6205,9570,9570,9570,9570,9570,9570,9572,9572,9572,9572,9572,9572,9573,9573,9573,9573,9573,9573,9574,9574,9574,9574,9574,9574,9581,9581,9581,9581,9581,9581,7814,7814,7814,7814,7814,7814,7815,7815,7815,7815,7815,7815,7816,7816,7816,7816,7816,7816,7817,7817,7817,7817,7817,7817,7818,7818,7818,7818,7818,7818,7819,7819,7819,7819,7819,7819,8206,4398,4398,4398,4398,4398,4399,4399,4399,4399,4399,4400,4400,4400,4400,4400,4402,4402,4402,4402,4402,4941,4941,4941,4941,4941,4939,4939,4939,4939,4939,4940,4940,4940,4940,4940,4942,4942,4942,4942,4942,4938,4938,4938,4938,4938,9554,9554,9554,9554,9554,9555,9555,9555,9555,9555,9556,9556,9556,9556,9556,9557,9557,9557,9557,9557,7777,7777,7777,7777,7777,7778,7778,7778,7778,7778,7779,7779,7779,7779,7779,7780,7780,7780,7780,7780,7781,7781,7781,7781,7781,7802,7802,7802,7802,7803,7803,7803,7803,7804,7804,7804,7804,7805,7805,7805,7805,7796,7796,7796,7796,7796,7796,7798,7798,7798,7798,7798,7798,7797,7797,7797,7797,7797,7797,7800,7800,7800,7800,7800,7800,7799,7799,7799,7799,7799,7799,7801,7801,7801,7801,7801,7801,8079) ) as s GROUP BY id_product_ps ) as ss | 0.006 | 42 |
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 (9566,9566,9566,9566,9566,9566,9566,9566,9551,9551,9551,9551,9551,9548,9548,9548,9548,9548,9571,9571,9571,9571,9571,9571,4401,4401,4401,4401,4401,9558,9558,9558,9558,9558,7015,7015,7015,7016,7016,7016,7017,7017,7017,9125,8978,8633,8829,8829,8829,8825,8830,8830,8830,8528,8528,8528,8531,8537,8551,1302,8839,8838,8550,8840,8845,8845,8845,1308,8841,8841,8841,8844,8843,8842,8842,8842,3442,3442,3441,3441,3443,7789,7789,7789,7789,7788,7788,7788,7788,7790,7790,7790,7790,7791,7791,7791,7791,6598,6598,6598,6598,6598,6598,6598,6602,6602,6602,6602,6602,6602,6602,6597,6597,6597,6597,6597,6597,6597,6599,6599,6599,6599,6599,6599,6599,6601,6601,6601,6601,6601,6601,6601,6600,6600,6600,6600,6600,6600,6600,6603,6603,6603,6603,6603,6603,6603,7806,7806,7806,7806,7807,7807,7807,7807,7808,7808,7808,7808,7809,7809,7809,7809,9559,9559,9559,9559,9559,9559,9559,9559,9560,9560,9560,9560,9560,9560,9560,9560,9561,9561,9561,9561,9561,9561,9561,9561,9563,9563,9563,9563,9563,9563,9563,9563,9564,9564,9564,9564,9564,9564,9564,9564,9562,9562,9562,9562,9562,9562,9562,9562,9565,9565,9565,9565,9565,9565,9565,9565,9549,9549,9549,9549,9549,9550,9550,9550,9550,9550,9552,9552,9552,9552,9552,9553,9553,9553,9553,9553,7810,7810,7810,7810,7811,7811,7811,7811,7812,7812,7812,7812,7813,7813,7813,7813,7774,7774,7774,7775,7775,7775,7776,7776,7776,8078,9547,9547,9547,9547,9547,9546,9546,9546,9546,9546,9545,9545,9545,9545,9545,9533,9533,9533,9533,9533,7240,4945,4945,4945,4945,4945,4945,4945,4946,4946,4946,4946,4946,4946,4946,4949,4949,4949,4949,4949,4949,4949,4943,4943,4943,4943,4943,4943,4943,4944,4944,4944,4944,4944,4944,4944,4948,4948,4948,4948,4948,4948,4948,4947,4947,4947,4947,4947,4947,4947,6204,6204,6205,6205,9570,9570,9570,9570,9570,9570,9572,9572,9572,9572,9572,9572,9573,9573,9573,9573,9573,9573,9574,9574,9574,9574,9574,9574,9581,9581,9581,9581,9581,9581,7814,7814,7814,7814,7814,7814,7815,7815,7815,7815,7815,7815,7816,7816,7816,7816,7816,7816,7817,7817,7817,7817,7817,7817,7818,7818,7818,7818,7818,7818,7819,7819,7819,7819,7819,7819,8206,4398,4398,4398,4398,4398,4399,4399,4399,4399,4399,4400,4400,4400,4400,4400,4402,4402,4402,4402,4402,4941,4941,4941,4941,4941,4939,4939,4939,4939,4939,4940,4940,4940,4940,4940,4942,4942,4942,4942,4942,4938,4938,4938,4938,4938,9554,9554,9554,9554,9554,9555,9555,9555,9555,9555,9556,9556,9556,9556,9556,9557,9557,9557,9557,9557,7777,7777,7777,7777,7777,7778,7778,7778,7778,7778,7779,7779,7779,7779,7779,7780,7780,7780,7780,7780,7781,7781,7781,7781,7781,7802,7802,7802,7802,7803,7803,7803,7803,7804,7804,7804,7804,7805,7805,7805,7805,7796,7796,7796,7796,7796,7796,7798,7798,7798,7798,7798,7798,7797,7797,7797,7797,7797,7797,7800,7800,7800,7800,7800,7800,7799,7799,7799,7799,7799,7799,7801,7801,7801,7801,7801,7801,8079) ) 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 36 ,12 | 0.008 | 6 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (9566,9566,9566,9566,9566,9566,9566,9566,9551,9551,9551,9551,9551,9548,9548,9548,9548,9548,9571,9571,9571,9571,9571,9571,4401,4401,4401,4401,4401,9558,9558,9558,9558,9558,7015,7015,7015,7016,7016,7016,7017,7017,7017,9125,8978,8633,8829,8829,8829,8825,8830,8830,8830,8528,8528,8528,8531,8537,8551,1302,8839,8838,8550,8840,8845,8845,8845,1308,8841,8841,8841,8844,8843,8842,8842,8842,3442,3442,3441,3441,3443,7789,7789,7789,7789,7788,7788,7788,7788,7790,7790,7790,7790,7791,7791,7791,7791,6598,6598,6598,6598,6598,6598,6598,6602,6602,6602,6602,6602,6602,6602,6597,6597,6597,6597,6597,6597,6597,6599,6599,6599,6599,6599,6599,6599,6601,6601,6601,6601,6601,6601,6601,6600,6600,6600,6600,6600,6600,6600,6603,6603,6603,6603,6603,6603,6603,7806,7806,7806,7806,7807,7807,7807,7807,7808,7808,7808,7808,7809,7809,7809,7809,9559,9559,9559,9559,9559,9559,9559,9559,9560,9560,9560,9560,9560,9560,9560,9560,9561,9561,9561,9561,9561,9561,9561,9561,9563,9563,9563,9563,9563,9563,9563,9563,9564,9564,9564,9564,9564,9564,9564,9564,9562,9562,9562,9562,9562,9562,9562,9562,9565,9565,9565,9565,9565,9565,9565,9565,9549,9549,9549,9549,9549,9550,9550,9550,9550,9550,9552,9552,9552,9552,9552,9553,9553,9553,9553,9553,7810,7810,7810,7810,7811,7811,7811,7811,7812,7812,7812,7812,7813,7813,7813,7813,7774,7774,7774,7775,7775,7775,7776,7776,7776,8078,9547,9547,9547,9547,9547,9546,9546,9546,9546,9546,9545,9545,9545,9545,9545,9533,9533,9533,9533,9533,7240,4945,4945,4945,4945,4945,4945,4945,4946,4946,4946,4946,4946,4946,4946,4949,4949,4949,4949,4949,4949,4949,4943,4943,4943,4943,4943,4943,4943,4944,4944,4944,4944,4944,4944,4944,4948,4948,4948,4948,4948,4948,4948,4947,4947,4947,4947,4947,4947,4947,6204,6204,6205,6205,9570,9570,9570,9570,9570,9570,9572,9572,9572,9572,9572,9572,9573,9573,9573,9573,9573,9573,9574,9574,9574,9574,9574,9574,9581,9581,9581,9581,9581,9581,7814,7814,7814,7814,7814,7814,7815,7815,7815,7815,7815,7815,7816,7816,7816,7816,7816,7816,7817,7817,7817,7817,7817,7817,7818,7818,7818,7818,7818,7818,7819,7819,7819,7819,7819,7819,8206,4398,4398,4398,4398,4398,4399,4399,4399,4399,4399,4400,4400,4400,4400,4400,4402,4402,4402,4402,4402,4941,4941,4941,4941,4941,4939,4939,4939,4939,4939,4940,4940,4940,4940,4940,4942,4942,4942,4942,4942,4938,4938,4938,4938,4938,9554,9554,9554,9554,9554,9555,9555,9555,9555,9555,9556,9556,9556,9556,9556,9557,9557,9557,9557,9557,7777,7777,7777,7777,7777,7778,7778,7778,7778,7778,7779,7779,7779,7779,7779,7780,7780,7780,7780,7780,7781,7781,7781,7781,7781,7802,7802,7802,7802,7803,7803,7803,7803,7804,7804,7804,7804,7805,7805,7805,7805,7796,7796,7796,7796,7796,7796,7798,7798,7798,7798,7798,7798,7797,7797,7797,7797,7797,7797,7800,7800,7800,7800,7800,7800,7799,7799,7799,7799,7799,7799,7801,7801,7801,7801,7801,7801,8079) | 0.001 | 548 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (1302,1308,3441,3442,3441,3442,3443,4399,4400,4402,4401,4398,4400,4398,4401,4402,4399,4398,4402,4401,4400,4399,4402,4400,4398,4401,4399,4401,4400,4398,4402,4399,4939,4940,4942,4941,4938,4940,4941,4942,4938,4939,4938,4942,4940,4941,4939,4942,4938,4940,4941,4939,4941,4940,4938,4942,4939,4945,4949,4948,4944,4946,4947,4943,4945,4946,4949,4948,4943,4947,4944,4946,4948,4944,4949,4943,4947,4945,4944,4949,4943,4948,4947,4946,4945,4949,4944,4948,4943,4946,4947,4945,4949,4944,4947,4946,4943,4948,4945,4948,4947,4944,4946,4943,4949,4945,6204,6205,6204,6205,6599,6603,6602,6598,6600,6597,6601,6599,6600,6603,6597,6602,6601,6598,6600,6602,6598,6603,6597,6601,6599,6598,6603,6597,6602,6601,6600,6599,6603,6598,6602,6597,6600,6601,6599,6603,6598,6601,6597,6600,6599,6602,6602,6601,6600,6598,6597,6599,6603,7016,7015,7017,7017,7016,7015,7016,7017,7015,7240,7775,7774,7776,7776,7775,7774,7775,7776,7774,7778,7779,7781,7777,7780,7779,7780,7777,7781,7778,7777,7781,7779,7780,7778,7781,7779,7777,7780,7778,7780,7779,7777,7781,7778,7791,7789,7788,7790,7791,7788,7790,7789,7788,7791,7789,7790,7790,7789,7788,7791,7801,7797,7800,7798,7796,7799,7801,7800,7796,7798,7799,7797,7797,7801,7796,7800,7799,7798,7797,7801,7800,7796,7798,7799,7797,7801,7799,7796,7798,7800,7800,7799,7797,7798,7796,7801,7805,7803,7804,7802,7805,7802,7804,7803,7805,7802,7803,7804,7804,7802,7803,7805,7809,7807,7808,7806,7809,7806,7808,7807,7806,7809,7807,7808,7808,7807,7806,7809,7813,7811,7812,7810,7813,7810,7812,7811,7810,7813,7811,7812,7812,7811,7810,7813,7819,7815,7818,7816,7814,7817,7819,7818,7814,7816,7817,7815,7815,7819,7814,7818,7816,7817,7815,7819,7818,7814,7816,7817,7815,7819,7817,7814,7816,7818,7818,7817,7815,7816,7814,7819,8078,8079,8206,8830,8829,8528,8531,8537,8550,8551,8633,8825,8830,8829,8528,8528,8830,8829,8838,8839,8840,8842,8841,8845,8842,8845,8841,8843,8844,8842,8841,8845,8978,9125,9545,9546,9548,9533,9547,9546,9547,9533,9548,9545,9533,9548,9546,9547,9545,9548,9533,9546,9545,9547,9547,9546,9533,9545,9548,9550,9551,9553,9549,9552,9551,9549,9552,9553,9550,9549,9553,9551,9552,9550,9553,9551,9549,9550,9552,9552,9551,9549,9553,9550,9555,9556,9558,9554,9557,9556,9557,9554,9558,9555,9554,9558,9557,9556,9555,9558,9556,9554,9555,9557,9557,9556,9554,9555,9558,9566,9561,9565,9560,9564,9562,9559,9563,9566,9561,9565,9562,9564,9559,9563,9560,9566,9565,9564,9560,9562,9563,9559,9561,9561,9560,9566,9565,9559,9564,9563,9562,9566,9561,9565,9564,9560,9559,9562,9563,9561,9566,9565,9560,9563,9559,9562,9564,9566,9561,9564,9560,9563,9559,9562,9565,9565,9564,9561,9563,9560,9562,9559,9566,9581,9571,9574,9572,9570,9573,9581,9574,9570,9572,9573,9571,9571,9581,9570,9574,9572,9573,9581,9571,9574,9570,9572,9573,9581,9571,9573,9570,9572,9574,9574,9571,9573,9572,9570,9581) | 0.001 | 548 |
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 (1302,1308,3442,3441,3441,3442,3443,4399,4400,4402,4401,4398,4398,4399,4402,4401,4400,4399,4402,4398,4401,4400,4402,4399,4400,4398,4401,4401,4399,4400,4398,4402,4939,4940,4942,4941,4938,4938,4939,4942,4941,4940,4939,4942,4938,4941,4940,4942,4939,4940,4938,4941,4941,4939,4940,4938,4942,4945,4946,4949,4944,4948,4947,4943,4945,4946,4949,4948,4947,4943,4944,4944,4943,4949,4945,4948,4947,4946,4945,4949,4944,4948,4943,4947,4946,4949,4945,4948,4944,4946,4943,4947,4949,4945,4944,4947,4943,4946,4948,4948,4945,4947,4946,4944,4943,4949,6205,6204,6204,6205,6599,6600,6603,6598,6602,6601,6597,6599,6600,6603,6602,6601,6597,6598,6598,6597,6603,6599,6602,6601,6600,6599,6603,6598,6602,6597,6601,6600,6603,6599,6602,6598,6600,6597,6601,6603,6599,6601,6598,6597,6600,6602,6602,6599,6601,6600,6598,6597,6603,7015,7017,7016,7017,7015,7016,7015,7016,7017,7240,7774,7776,7775,7776,7774,7775,7775,7774,7776,7778,7779,7781,7780,7777,7777,7778,7781,7780,7779,7778,7781,7777,7780,7779,7781,7778,7779,7777,7780,7780,7778,7779,7777,7781,7790,7791,7789,7788,7791,7790,7788,7789,7791,7788,7789,7790,7790,7788,7789,7791,7801,7797,7798,7800,7799,7796,7800,7801,7799,7798,7796,7797,7801,7797,7800,7796,7799,7798,7801,7800,7797,7796,7798,7799,7801,7797,7799,7796,7798,7800,7800,7797,7799,7796,7798,7801,7804,7805,7803,7802,7805,7804,7802,7803,7805,7802,7803,7804,7804,7802,7805,7803,7808,7809,7807,7806,7809,7808,7806,7807,7809,7806,7807,7808,7808,7806,7809,7807,7812,7813,7811,7810,7813,7812,7810,7811,7813,7810,7811,7812,7812,7810,7811,7813,7819,7815,7816,7818,7817,7814,7818,7819,7817,7816,7814,7815,7819,7815,7818,7814,7817,7816,7819,7818,7815,7814,7816,7817,7819,7815,7817,7814,7816,7818,7818,7815,7817,7816,7814,7819,8078,8079,8206,8830,8829,8528,8531,8537,8550,8551,8633,8825,8829,8528,8830,8528,8829,8830,8838,8839,8840,8841,8845,8842,8841,8845,8842,8843,8844,8842,8841,8845,8978,9125,9545,9546,9548,9547,9533,9533,9545,9548,9547,9546,9545,9548,9533,9547,9546,9548,9545,9546,9533,9547,9547,9545,9546,9533,9548,9550,9551,9553,9552,9549,9549,9550,9553,9552,9551,9550,9553,9549,9552,9551,9553,9550,9551,9549,9552,9552,9550,9551,9549,9553,9555,9556,9558,9557,9554,9554,9555,9558,9557,9556,9555,9558,9554,9557,9556,9558,9555,9556,9554,9557,9557,9555,9556,9554,9558,9566,9565,9561,9562,9560,9564,9563,9559,9566,9561,9565,9564,9562,9563,9559,9560,9565,9566,9564,9562,9563,9560,9559,9561,9566,9561,9560,9565,9564,9559,9563,9562,9566,9565,9561,9564,9560,9559,9562,9563,9566,9565,9561,9560,9563,9559,9564,9562,9566,9561,9564,9560,9563,9559,9562,9565,9565,9561,9564,9563,9560,9559,9566,9562,9581,9571,9572,9574,9573,9570,9574,9581,9572,9573,9570,9571,9581,9571,9574,9570,9573,9572,9581,9574,9571,9570,9573,9572,9581,9571,9573,9570,9572,9574,9574,9571,9573,9570,9572,9581)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 47 | 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` = '47'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.001 | 28 |
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 (9566,9566,9566,9566,9566,9566,9566,9566,9551,9551,9551,9551,9551,9548,9548,9548,9548,9548,9571,9571,9571,9571,9571,9571,4401,4401,4401,4401,4401,9558,9558,9558,9558,9558,7015,7015,7015,7016,7016,7016,7017,7017,7017,9125,8978,8633,8829,8829,8829,8825,8830,8830,8830,8528,8528,8528,8531,8537,8551,1302,8839,8838,8550,8840,8845,8845,8845,1308,8841,8841,8841,8844,8843,8842,8842,8842,3442,3442,3441,3441,3443,7789,7789,7789,7789,7788,7788,7788,7788,7790,7790,7790,7790,7791,7791,7791,7791,6598,6598,6598,6598,6598,6598,6598,6602,6602,6602,6602,6602,6602,6602,6597,6597,6597,6597,6597,6597,6597,6599,6599,6599,6599,6599,6599,6599,6601,6601,6601,6601,6601,6601,6601,6600,6600,6600,6600,6600,6600,6600,6603,6603,6603,6603,6603,6603,6603,7806,7806,7806,7806,7807,7807,7807,7807,7808,7808,7808,7808,7809,7809,7809,7809,9559,9559,9559,9559,9559,9559,9559,9559,9560,9560,9560,9560,9560,9560,9560,9560,9561,9561,9561,9561,9561,9561,9561,9561,9563,9563,9563,9563,9563,9563,9563,9563,9564,9564,9564,9564,9564,9564,9564,9564,9562,9562,9562,9562,9562,9562,9562,9562,9565,9565,9565,9565,9565,9565,9565,9565,9549,9549,9549,9549,9549,9550,9550,9550,9550,9550,9552,9552,9552,9552,9552,9553,9553,9553,9553,9553,7810,7810,7810,7810,7811,7811,7811,7811,7812,7812,7812,7812,7813,7813,7813,7813,7774,7774,7774,7775,7775,7775,7776,7776,7776,8078,9547,9547,9547,9547,9547,9546,9546,9546,9546,9546,9545,9545,9545,9545,9545,9533,9533,9533,9533,9533,7240,4945,4945,4945,4945,4945,4945,4945,4946,4946,4946,4946,4946,4946,4946,4949,4949,4949,4949,4949,4949,4949,4943,4943,4943,4943,4943,4943,4943,4944,4944,4944,4944,4944,4944,4944,4948,4948,4948,4948,4948,4948,4948,4947,4947,4947,4947,4947,4947,4947,6204,6204,6205,6205,9570,9570,9570,9570,9570,9570,9572,9572,9572,9572,9572,9572,9573,9573,9573,9573,9573,9573,9574,9574,9574,9574,9574,9574,9581,9581,9581,9581,9581,9581,7814,7814,7814,7814,7814,7814,7815,7815,7815,7815,7815,7815,7816,7816,7816,7816,7816,7816,7817,7817,7817,7817,7817,7817,7818,7818,7818,7818,7818,7818,7819,7819,7819,7819,7819,7819,8206,4398,4398,4398,4398,4398,4399,4399,4399,4399,4399,4400,4400,4400,4400,4400,4402,4402,4402,4402,4402,4941,4941,4941,4941,4941,4939,4939,4939,4939,4939,4940,4940,4940,4940,4940,4942,4942,4942,4942,4942,4938,4938,4938,4938,4938,9554,9554,9554,9554,9554,9555,9555,9555,9555,9555,9556,9556,9556,9556,9556,9557,9557,9557,9557,9557,7777,7777,7777,7777,7777,7778,7778,7778,7778,7778,7779,7779,7779,7779,7779,7780,7780,7780,7780,7780,7781,7781,7781,7781,7781,7802,7802,7802,7802,7803,7803,7803,7803,7804,7804,7804,7804,7805,7805,7805,7805,7796,7796,7796,7796,7796,7796,7798,7798,7798,7798,7798,7798,7797,7797,7797,7797,7797,7797,7800,7800,7800,7800,7800,7800,7799,7799,7799,7799,7799,7799,7801,7801,7801,7801,7801,7801,8079) | 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 (9566,9566,9566,9566,9566,9566,9566,9566,9551,9551,9551,9551,9551,9548,9548,9548,9548,9548,9571,9571,9571,9571,9571,9571,4401,4401,4401,4401,4401,9558,9558,9558,9558,9558,7015,7015,7015,7016,7016,7016,7017,7017,7017,9125,8978,8633,8829,8829,8829,8825,8830,8830,8830,8528,8528,8528,8531,8537,8551,1302,8839,8838,8550,8840,8845,8845,8845,1308,8841,8841,8841,8844,8843,8842,8842,8842,3442,3442,3441,3441,3443,7789,7789,7789,7789,7788,7788,7788,7788,7790,7790,7790,7790,7791,7791,7791,7791,6598,6598,6598,6598,6598,6598,6598,6602,6602,6602,6602,6602,6602,6602,6597,6597,6597,6597,6597,6597,6597,6599,6599,6599,6599,6599,6599,6599,6601,6601,6601,6601,6601,6601,6601,6600,6600,6600,6600,6600,6600,6600,6603,6603,6603,6603,6603,6603,6603,7806,7806,7806,7806,7807,7807,7807,7807,7808,7808,7808,7808,7809,7809,7809,7809,9559,9559,9559,9559,9559,9559,9559,9559,9560,9560,9560,9560,9560,9560,9560,9560,9561,9561,9561,9561,9561,9561,9561,9561,9563,9563,9563,9563,9563,9563,9563,9563,9564,9564,9564,9564,9564,9564,9564,9564,9562,9562,9562,9562,9562,9562,9562,9562,9565,9565,9565,9565,9565,9565,9565,9565,9549,9549,9549,9549,9549,9550,9550,9550,9550,9550,9552,9552,9552,9552,9552,9553,9553,9553,9553,9553,7810,7810,7810,7810,7811,7811,7811,7811,7812,7812,7812,7812,7813,7813,7813,7813,7774,7774,7774,7775,7775,7775,7776,7776,7776,8078,9547,9547,9547,9547,9547,9546,9546,9546,9546,9546,9545,9545,9545,9545,9545,9533,9533,9533,9533,9533,7240,4945,4945,4945,4945,4945,4945,4945,4946,4946,4946,4946,4946,4946,4946,4949,4949,4949,4949,4949,4949,4949,4943,4943,4943,4943,4943,4943,4943,4944,4944,4944,4944,4944,4944,4944,4948,4948,4948,4948,4948,4948,4948,4947,4947,4947,4947,4947,4947,4947,6204,6204,6205,6205,9570,9570,9570,9570,9570,9570,9572,9572,9572,9572,9572,9572,9573,9573,9573,9573,9573,9573,9574,9574,9574,9574,9574,9574,9581,9581,9581,9581,9581,9581,7814,7814,7814,7814,7814,7814,7815,7815,7815,7815,7815,7815,7816,7816,7816,7816,7816,7816,7817,7817,7817,7817,7817,7817,7818,7818,7818,7818,7818,7818,7819,7819,7819,7819,7819,7819,8206,4398,4398,4398,4398,4398,4399,4399,4399,4399,4399,4400,4400,4400,4400,4400,4402,4402,4402,4402,4402,4941,4941,4941,4941,4941,4939,4939,4939,4939,4939,4940,4940,4940,4940,4940,4942,4942,4942,4942,4942,4938,4938,4938,4938,4938,9554,9554,9554,9554,9554,9555,9555,9555,9555,9555,9556,9556,9556,9556,9556,9557,9557,9557,9557,9557,7777,7777,7777,7777,7777,7778,7778,7778,7778,7778,7779,7779,7779,7779,7779,7780,7780,7780,7780,7780,7781,7781,7781,7781,7781,7802,7802,7802,7802,7803,7803,7803,7803,7804,7804,7804,7804,7805,7805,7805,7805,7796,7796,7796,7796,7796,7796,7798,7798,7798,7798,7798,7798,7797,7797,7797,7797,7797,7797,7800,7800,7800,7800,7800,7800,7799,7799,7799,7799,7799,7799,7801,7801,7801,7801,7801,7801,8079) | 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-termiczne/47?page=4' | 0.000 | 1 |
UPDATE `missing_labels` SET `count` = 6 WHERE `label_key` = 'attribute.attrib_cat-11' AND `module` = 'attribute' AND `language` = 'pl_PL' AND `url` = '/kategoria/kubki-termiczne/47?page=4' | 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` = '8843' | 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` = '8843'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.007 | 0 |
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` = '8844' | 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` = '8844'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 0 |
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` = '1308' | 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` = '1308'
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` = '9533' | 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` = '9545'
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` = '9566' | 0.000 | 8 |
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` = '9565'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 8 |
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` = '9570' | 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` = '9581'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 6 |
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: 76 | 0.125 | 3909 |