Queries | Time | Rows |
SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.002 | 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.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` = '86' | 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` = 86 | 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` = '86'
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 (86) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.068 | 536 |
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 (9667,9667,9667,9667,8210,8053,8054,4753,8055,8413,4783,4783,4783,4783,4782,4782,4782,4782,4781,4781,4781,4781,4784,4784,4784,4784,4286,4286,4286,4286,4286,4285,4285,4285,4285,4285,4288,4288,4288,4288,4288,4284,4284,4284,4284,4284,4287,4287,4287,4287,4287,8731,4267,4791,4791,4791,4791,4792,4792,4792,4792,4789,4789,4789,4789,4790,4790,4790,4790,4743,4743,4742,4742,8632,2879,4289,4289,4289,4290,4290,4290,4291,4291,4291,8064,8070,8069,4294,4294,4294,4294,4294,4294,4297,4297,4297,4297,4297,4297,4292,4292,4292,4292,4292,4292,4296,4296,4296,4296,4296,4296,4295,4295,4295,4295,4295,4295,4293,4293,4293,4293,4293,4293,4830,4830,4830,4832,4832,4832,4831,4831,4831,4793,4762,4762,4763,4763,1257,4304,4304,4304,4304,4304,4304,4304,4298,4298,4298,4298,4298,4298,4298,4300,4300,4300,4300,4300,4300,4300,4302,4302,4302,4302,4302,4302,4302,4303,4303,4303,4303,4303,4303,4303,4301,4301,4301,4301,4301,4301,4301,4299,4299,4299,4299,4299,4299,4299,4825,4824,4824,4823,4822,4822,4260,4260,4260,4260,4258,4258,4258,4258,4261,4261,4261,4261,4259,4259,4259,4259,4788,4788,4788,4788,4787,4787,4787,4787,4786,4786,4786,4786,4785,4785,4785,4785,9668,9668,9668,9668,9666,9666,9666,9666,9665,9665,9665,9665,3395,4375,4375,4375,4375,4376,4376,4376,4376,4377,4377,4377,4377,4378,4378,4378,4378,8518,8517,1269,8762,8067,4771,4771,4771,4771,4771,4771,4769,4769,4769,4769,4769,4769,4775,4775,4775,4775,4775,4775,4773,4773,4773,4773,4773,4773,4779,4779,4779,4779,4779,4779,4777,4777,4777,4777,4777,4777,4803,4803,4803,4803,4811,4811,4811,4811,4808,4808,4808,4808,4798,4798,4798,4798,4806,4806,4806,4806,4801,4801,4801,4801,4796,4796,4796,4796,4794,4794,4794,4794,4841,4841,4841,4841,4837,4837,4837,4837,4845,4845,4845,4845,4847,4847,4847,4847,4843,4843,4843,4843,4839,4839,4839,4839,4835,4835,4835,4835,4833,4833,4833,4833,8065,4854,4854,4852,4852,4862,4862,4862,4862,4858,4858,4858,4858,4864,4864,4864,4864,4860,4860,4860,4860,4745,8412,8411,4390,4390,4390,4390,4390,4386,4386,4386,4386,4386,4387,4387,4387,4387,4387,4388,4388,4388,4388,4388,4389,4389,4389,4389,4389,4384,4384,4384,4384,4384,4384,4384,4383,4383,4383,4383,4383,4383,4383,4379,4379,4379,4379,4379,4379,4379,4381,4381,4381,4381,4381,4381,4381,4380,4380,4380,4380,4380,4380,4380,4382,4382,4382,4382,4382,4382,4382,4385,4385,4385,4385,4385,4385,4385,8133,4749,4263,4264,4817,4817,4817,4817,4816,4816,4816,4816,4814,4814,4814,4814,4815,4815,4815,4815,4827,4827,4827,4827,4826,4826,4826,4826,4829,4829,4829,4829,4828,4828,4828,4828,4857,4857,4856,4856,8509,8507,1261,8511,8510,4820,4820,4819,4821,4818,4818,8071,8056,8057,8058,4872,4872,4871,4871,9137,9101,9102,9103,9105,9106,8202,8203,8514,8273,6653,6653,6653,6654,6654,6654,6655,6655,6655,4748) ) as s GROUP BY id_product_ps ) as ss | 0.006 | 82 |
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 (9667,9667,9667,9667,8210,8053,8054,4753,8055,8413,4783,4783,4783,4783,4782,4782,4782,4782,4781,4781,4781,4781,4784,4784,4784,4784,4286,4286,4286,4286,4286,4285,4285,4285,4285,4285,4288,4288,4288,4288,4288,4284,4284,4284,4284,4284,4287,4287,4287,4287,4287,8731,4267,4791,4791,4791,4791,4792,4792,4792,4792,4789,4789,4789,4789,4790,4790,4790,4790,4743,4743,4742,4742,8632,2879,4289,4289,4289,4290,4290,4290,4291,4291,4291,8064,8070,8069,4294,4294,4294,4294,4294,4294,4297,4297,4297,4297,4297,4297,4292,4292,4292,4292,4292,4292,4296,4296,4296,4296,4296,4296,4295,4295,4295,4295,4295,4295,4293,4293,4293,4293,4293,4293,4830,4830,4830,4832,4832,4832,4831,4831,4831,4793,4762,4762,4763,4763,1257,4304,4304,4304,4304,4304,4304,4304,4298,4298,4298,4298,4298,4298,4298,4300,4300,4300,4300,4300,4300,4300,4302,4302,4302,4302,4302,4302,4302,4303,4303,4303,4303,4303,4303,4303,4301,4301,4301,4301,4301,4301,4301,4299,4299,4299,4299,4299,4299,4299,4825,4824,4824,4823,4822,4822,4260,4260,4260,4260,4258,4258,4258,4258,4261,4261,4261,4261,4259,4259,4259,4259,4788,4788,4788,4788,4787,4787,4787,4787,4786,4786,4786,4786,4785,4785,4785,4785,9668,9668,9668,9668,9666,9666,9666,9666,9665,9665,9665,9665,3395,4375,4375,4375,4375,4376,4376,4376,4376,4377,4377,4377,4377,4378,4378,4378,4378,8518,8517,1269,8762,8067,4771,4771,4771,4771,4771,4771,4769,4769,4769,4769,4769,4769,4775,4775,4775,4775,4775,4775,4773,4773,4773,4773,4773,4773,4779,4779,4779,4779,4779,4779,4777,4777,4777,4777,4777,4777,4803,4803,4803,4803,4811,4811,4811,4811,4808,4808,4808,4808,4798,4798,4798,4798,4806,4806,4806,4806,4801,4801,4801,4801,4796,4796,4796,4796,4794,4794,4794,4794,4841,4841,4841,4841,4837,4837,4837,4837,4845,4845,4845,4845,4847,4847,4847,4847,4843,4843,4843,4843,4839,4839,4839,4839,4835,4835,4835,4835,4833,4833,4833,4833,8065,4854,4854,4852,4852,4862,4862,4862,4862,4858,4858,4858,4858,4864,4864,4864,4864,4860,4860,4860,4860,4745,8412,8411,4390,4390,4390,4390,4390,4386,4386,4386,4386,4386,4387,4387,4387,4387,4387,4388,4388,4388,4388,4388,4389,4389,4389,4389,4389,4384,4384,4384,4384,4384,4384,4384,4383,4383,4383,4383,4383,4383,4383,4379,4379,4379,4379,4379,4379,4379,4381,4381,4381,4381,4381,4381,4381,4380,4380,4380,4380,4380,4380,4380,4382,4382,4382,4382,4382,4382,4382,4385,4385,4385,4385,4385,4385,4385,8133,4749,4263,4264,4817,4817,4817,4817,4816,4816,4816,4816,4814,4814,4814,4814,4815,4815,4815,4815,4827,4827,4827,4827,4826,4826,4826,4826,4829,4829,4829,4829,4828,4828,4828,4828,4857,4857,4856,4856,8509,8507,1261,8511,8510,4820,4820,4819,4821,4818,4818,8071,8056,8057,8058,4872,4872,4871,4871,9137,9101,9102,9103,9105,9106,8202,8203,8514,8273,6653,6653,6653,6654,6654,6654,6655,6655,6655,4748) ) 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.009 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (9667,9667,9667,9667,8210,8053,8054,4753,8055,8413,4783,4783,4783,4783,4782,4782,4782,4782,4781,4781,4781,4781,4784,4784,4784,4784,4286,4286,4286,4286,4286,4285,4285,4285,4285,4285,4288,4288,4288,4288,4288,4284,4284,4284,4284,4284,4287,4287,4287,4287,4287,8731,4267,4791,4791,4791,4791,4792,4792,4792,4792,4789,4789,4789,4789,4790,4790,4790,4790,4743,4743,4742,4742,8632,2879,4289,4289,4289,4290,4290,4290,4291,4291,4291,8064,8070,8069,4294,4294,4294,4294,4294,4294,4297,4297,4297,4297,4297,4297,4292,4292,4292,4292,4292,4292,4296,4296,4296,4296,4296,4296,4295,4295,4295,4295,4295,4295,4293,4293,4293,4293,4293,4293,4830,4830,4830,4832,4832,4832,4831,4831,4831,4793,4762,4762,4763,4763,1257,4304,4304,4304,4304,4304,4304,4304,4298,4298,4298,4298,4298,4298,4298,4300,4300,4300,4300,4300,4300,4300,4302,4302,4302,4302,4302,4302,4302,4303,4303,4303,4303,4303,4303,4303,4301,4301,4301,4301,4301,4301,4301,4299,4299,4299,4299,4299,4299,4299,4825,4824,4824,4823,4822,4822,4260,4260,4260,4260,4258,4258,4258,4258,4261,4261,4261,4261,4259,4259,4259,4259,4788,4788,4788,4788,4787,4787,4787,4787,4786,4786,4786,4786,4785,4785,4785,4785,9668,9668,9668,9668,9666,9666,9666,9666,9665,9665,9665,9665,3395,4375,4375,4375,4375,4376,4376,4376,4376,4377,4377,4377,4377,4378,4378,4378,4378,8518,8517,1269,8762,8067,4771,4771,4771,4771,4771,4771,4769,4769,4769,4769,4769,4769,4775,4775,4775,4775,4775,4775,4773,4773,4773,4773,4773,4773,4779,4779,4779,4779,4779,4779,4777,4777,4777,4777,4777,4777,4803,4803,4803,4803,4811,4811,4811,4811,4808,4808,4808,4808,4798,4798,4798,4798,4806,4806,4806,4806,4801,4801,4801,4801,4796,4796,4796,4796,4794,4794,4794,4794,4841,4841,4841,4841,4837,4837,4837,4837,4845,4845,4845,4845,4847,4847,4847,4847,4843,4843,4843,4843,4839,4839,4839,4839,4835,4835,4835,4835,4833,4833,4833,4833,8065,4854,4854,4852,4852,4862,4862,4862,4862,4858,4858,4858,4858,4864,4864,4864,4864,4860,4860,4860,4860,4745,8412,8411,4390,4390,4390,4390,4390,4386,4386,4386,4386,4386,4387,4387,4387,4387,4387,4388,4388,4388,4388,4388,4389,4389,4389,4389,4389,4384,4384,4384,4384,4384,4384,4384,4383,4383,4383,4383,4383,4383,4383,4379,4379,4379,4379,4379,4379,4379,4381,4381,4381,4381,4381,4381,4381,4380,4380,4380,4380,4380,4380,4380,4382,4382,4382,4382,4382,4382,4382,4385,4385,4385,4385,4385,4385,4385,8133,4749,4263,4264,4817,4817,4817,4817,4816,4816,4816,4816,4814,4814,4814,4814,4815,4815,4815,4815,4827,4827,4827,4827,4826,4826,4826,4826,4829,4829,4829,4829,4828,4828,4828,4828,4857,4857,4856,4856,8509,8507,1261,8511,8510,4820,4820,4819,4821,4818,4818,8071,8056,8057,8058,4872,4872,4871,4871,9137,9101,9102,9103,9105,9106,8202,8203,8514,8273,6653,6653,6653,6654,6654,6654,6655,6655,6655,4748) | 0.001 | 536 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (1257,1261,1269,2879,3395,4261,4259,4260,4258,4258,4261,4259,4260,4261,4258,4259,4260,4260,4259,4258,4261,4263,4264,4267,4285,4286,4288,4284,4287,4286,4287,4284,4288,4285,4284,4288,4287,4286,4285,4288,4284,4286,4285,4287,4287,4286,4284,4285,4288,4290,4291,4289,4290,4291,4289,4290,4289,4291,4297,4293,4296,4294,4292,4295,4297,4296,4294,4292,4295,4293,4293,4297,4292,4296,4294,4295,4293,4297,4296,4292,4294,4295,4297,4293,4295,4292,4294,4296,4296,4295,4293,4294,4292,4297,4300,4304,4303,4299,4301,4302,4298,4300,4301,4304,4303,4298,4302,4299,4301,4303,4304,4299,4298,4302,4300,4299,4304,4298,4303,4302,4301,4300,4304,4299,4303,4298,4301,4302,4300,4304,4299,4302,4301,4298,4303,4300,4303,4302,4299,4301,4298,4304,4300,4378,4376,4375,4377,4375,4378,4377,4376,4375,4378,4376,4377,4377,4376,4375,4378,4381,4385,4384,4380,4382,4383,4379,4381,4382,4385,4384,4379,4383,4380,4382,4384,4380,4385,4383,4379,4381,4380,4385,4379,4384,4383,4382,4381,4385,4384,4380,4379,4382,4381,4383,4385,4383,4380,4382,4379,4381,4384,4384,4383,4382,4380,4379,4381,4385,4387,4388,4390,4389,4386,4388,4389,4386,4390,4387,4386,4390,4389,4388,4387,4390,4386,4388,4389,4387,4389,4388,4386,4390,4387,4742,4743,4742,4743,4745,4748,4749,4753,4763,4762,4762,4763,4779,4771,4777,4773,4775,4769,4779,4777,4773,4775,4769,4771,4771,4779,4769,4777,4773,4775,4771,4779,4777,4769,4773,4775,4779,4771,4775,4769,4773,4777,4777,4775,4771,4769,4773,4779,4784,4782,4783,4781,4781,4784,4782,4783,4781,4784,4782,4783,4783,4781,4782,4784,4788,4786,4787,4785,4785,4788,4786,4787,4788,4785,4786,4787,4787,4785,4786,4788,4792,4790,4789,4791,4789,4792,4791,4790,4789,4792,4790,4791,4791,4790,4789,4792,4793,4806,4796,4794,4801,4806,4794,4801,4796,4811,4803,4808,4798,4806,4794,4796,4801,4798,4811,4803,4808,4801,4794,4796,4806,4811,4798,4803,4808,4808,4803,4798,4811,4817,4815,4814,4816,4814,4817,4815,4816,4814,4817,4815,4816,4816,4815,4814,4817,4820,4818,4819,4818,4820,4821,4822,4824,4823,4822,4824,4825,4829,4827,4828,4826,4829,4826,4828,4827,4829,4826,4827,4828,4828,4827,4826,4829,4831,4830,4832,4831,4832,4830,4831,4832,4830,4843,4835,4833,4839,4833,4843,4839,4835,4847,4841,4837,4845,4833,4843,4835,4839,4847,4837,4845,4841,4839,4835,4833,4843,4847,4837,4841,4845,4845,4837,4841,4847,4854,4852,4852,4854,4857,4856,4856,4857,4864,4860,4858,4862,4864,4858,4862,4860,4858,4864,4860,4862,4862,4860,4858,4864,4872,4871,4871,4872,6654,6653,6655,6655,6654,6653,6654,6653,6655,8053,8054,8055,8056,8057,8058,8064,8065,8067,8069,8070,8071,8133,8202,8203,8210,8273,8411,8412,8413,8507,8509,8510,8511,8514,8517,8518,8632,8731,8762,9101,9102,9103,9105,9106,9137,9667,9668,9665,9666,9665,9667,9666,9668,9665,9666,9668,9667,9665,9667,9666,9668) | 0.001 | 536 |
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 (1257,1261,1269,2879,3395,4260,4261,4259,4258,4261,4260,4258,4259,4261,4258,4260,4259,4260,4258,4261,4259,4263,4264,4267,4285,4286,4288,4287,4284,4284,4285,4288,4287,4286,4285,4288,4284,4287,4286,4288,4285,4286,4284,4287,4287,4285,4286,4284,4288,4289,4291,4290,4291,4289,4290,4289,4290,4291,4297,4293,4294,4296,4295,4292,4296,4297,4295,4294,4292,4293,4297,4293,4296,4292,4295,4294,4297,4296,4293,4292,4294,4295,4297,4293,4295,4292,4294,4296,4296,4293,4295,4292,4294,4297,4300,4301,4304,4299,4303,4302,4298,4300,4301,4304,4303,4302,4298,4299,4299,4298,4304,4300,4303,4302,4301,4300,4304,4299,4303,4298,4302,4301,4304,4300,4303,4299,4301,4298,4302,4304,4300,4302,4299,4298,4301,4303,4303,4300,4302,4301,4299,4298,4304,4377,4378,4376,4375,4378,4377,4375,4376,4378,4375,4376,4377,4377,4375,4376,4378,4381,4382,4385,4380,4384,4383,4379,4381,4382,4385,4384,4383,4379,4380,4380,4379,4385,4381,4384,4383,4382,4381,4385,4380,4384,4379,4383,4382,4385,4381,4384,4380,4382,4379,4383,4385,4381,4383,4380,4379,4382,4384,4384,4381,4383,4382,4380,4379,4385,4387,4388,4390,4389,4386,4386,4387,4390,4389,4388,4387,4390,4386,4389,4388,4390,4387,4388,4386,4389,4389,4387,4388,4386,4390,4743,4742,4743,4742,4745,4748,4749,4753,4763,4762,4763,4762,4779,4771,4773,4777,4775,4769,4777,4779,4775,4773,4769,4771,4779,4771,4777,4769,4775,4773,4779,4777,4771,4769,4775,4773,4779,4771,4775,4769,4777,4773,4777,4771,4775,4769,4773,4779,4783,4784,4782,4781,4784,4783,4781,4782,4784,4781,4783,4782,4783,4781,4784,4782,4787,4788,4786,4785,4788,4787,4785,4786,4788,4785,4787,4786,4787,4785,4788,4786,4791,4792,4790,4789,4792,4791,4789,4790,4792,4789,4790,4791,4791,4789,4792,4790,4793,4801,4806,4796,4794,4806,4801,4794,4796,4808,4811,4803,4798,4806,4794,4796,4801,4811,4808,4798,4803,4801,4794,4796,4806,4811,4798,4803,4808,4808,4798,4811,4803,4816,4817,4815,4814,4817,4816,4814,4815,4817,4814,4815,4816,4816,4814,4815,4817,4820,4818,4819,4818,4820,4821,4824,4822,4823,4824,4822,4825,4828,4829,4827,4826,4829,4828,4826,4827,4829,4826,4827,4828,4828,4826,4827,4829,4830,4832,4831,4830,4832,4831,4830,4831,4832,4839,4843,4835,4833,4843,4839,4833,4835,4845,4847,4841,4837,4843,4833,4835,4839,4847,4837,4845,4841,4839,4833,4835,4843,4847,4837,4841,4845,4845,4837,4847,4841,4854,4852,4852,4854,4857,4856,4856,4857,4862,4864,4860,4858,4864,4862,4858,4860,4864,4858,4860,4862,4862,4858,4860,4864,4872,4871,4871,4872,6653,6655,6654,6655,6653,6654,6654,6653,6655,8053,8054,8055,8056,8057,8058,8064,8065,8067,8069,8070,8071,8133,8202,8203,8210,8273,8411,8412,8413,8507,8509,8510,8511,8514,8517,8518,8632,8731,8762,9101,9102,9103,9105,9106,9137,9666,9667,9668,9665,9667,9665,9668,9666,9665,9668,9666,9667,9665,9667,9668,9666)
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` = 86 | 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` = '86'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.001 | 36 |
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 (9667,9667,9667,9667,8210,8053,8054,4753,8055,8413,4783,4783,4783,4783,4782,4782,4782,4782,4781,4781,4781,4781,4784,4784,4784,4784,4286,4286,4286,4286,4286,4285,4285,4285,4285,4285,4288,4288,4288,4288,4288,4284,4284,4284,4284,4284,4287,4287,4287,4287,4287,8731,4267,4791,4791,4791,4791,4792,4792,4792,4792,4789,4789,4789,4789,4790,4790,4790,4790,4743,4743,4742,4742,8632,2879,4289,4289,4289,4290,4290,4290,4291,4291,4291,8064,8070,8069,4294,4294,4294,4294,4294,4294,4297,4297,4297,4297,4297,4297,4292,4292,4292,4292,4292,4292,4296,4296,4296,4296,4296,4296,4295,4295,4295,4295,4295,4295,4293,4293,4293,4293,4293,4293,4830,4830,4830,4832,4832,4832,4831,4831,4831,4793,4762,4762,4763,4763,1257,4304,4304,4304,4304,4304,4304,4304,4298,4298,4298,4298,4298,4298,4298,4300,4300,4300,4300,4300,4300,4300,4302,4302,4302,4302,4302,4302,4302,4303,4303,4303,4303,4303,4303,4303,4301,4301,4301,4301,4301,4301,4301,4299,4299,4299,4299,4299,4299,4299,4825,4824,4824,4823,4822,4822,4260,4260,4260,4260,4258,4258,4258,4258,4261,4261,4261,4261,4259,4259,4259,4259,4788,4788,4788,4788,4787,4787,4787,4787,4786,4786,4786,4786,4785,4785,4785,4785,9668,9668,9668,9668,9666,9666,9666,9666,9665,9665,9665,9665,3395,4375,4375,4375,4375,4376,4376,4376,4376,4377,4377,4377,4377,4378,4378,4378,4378,8518,8517,1269,8762,8067,4771,4771,4771,4771,4771,4771,4769,4769,4769,4769,4769,4769,4775,4775,4775,4775,4775,4775,4773,4773,4773,4773,4773,4773,4779,4779,4779,4779,4779,4779,4777,4777,4777,4777,4777,4777,4803,4803,4803,4803,4811,4811,4811,4811,4808,4808,4808,4808,4798,4798,4798,4798,4806,4806,4806,4806,4801,4801,4801,4801,4796,4796,4796,4796,4794,4794,4794,4794,4841,4841,4841,4841,4837,4837,4837,4837,4845,4845,4845,4845,4847,4847,4847,4847,4843,4843,4843,4843,4839,4839,4839,4839,4835,4835,4835,4835,4833,4833,4833,4833,8065,4854,4854,4852,4852,4862,4862,4862,4862,4858,4858,4858,4858,4864,4864,4864,4864,4860,4860,4860,4860,4745,8412,8411,4390,4390,4390,4390,4390,4386,4386,4386,4386,4386,4387,4387,4387,4387,4387,4388,4388,4388,4388,4388,4389,4389,4389,4389,4389,4384,4384,4384,4384,4384,4384,4384,4383,4383,4383,4383,4383,4383,4383,4379,4379,4379,4379,4379,4379,4379,4381,4381,4381,4381,4381,4381,4381,4380,4380,4380,4380,4380,4380,4380,4382,4382,4382,4382,4382,4382,4382,4385,4385,4385,4385,4385,4385,4385,8133,4749,4263,4264,4817,4817,4817,4817,4816,4816,4816,4816,4814,4814,4814,4814,4815,4815,4815,4815,4827,4827,4827,4827,4826,4826,4826,4826,4829,4829,4829,4829,4828,4828,4828,4828,4857,4857,4856,4856,8509,8507,1261,8511,8510,4820,4820,4819,4821,4818,4818,8071,8056,8057,8058,4872,4872,4871,4871,9137,9101,9102,9103,9105,9106,8202,8203,8514,8273,6653,6653,6653,6654,6654,6654,6655,6655,6655,4748) | 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 (9667,9667,9667,9667,8210,8053,8054,4753,8055,8413,4783,4783,4783,4783,4782,4782,4782,4782,4781,4781,4781,4781,4784,4784,4784,4784,4286,4286,4286,4286,4286,4285,4285,4285,4285,4285,4288,4288,4288,4288,4288,4284,4284,4284,4284,4284,4287,4287,4287,4287,4287,8731,4267,4791,4791,4791,4791,4792,4792,4792,4792,4789,4789,4789,4789,4790,4790,4790,4790,4743,4743,4742,4742,8632,2879,4289,4289,4289,4290,4290,4290,4291,4291,4291,8064,8070,8069,4294,4294,4294,4294,4294,4294,4297,4297,4297,4297,4297,4297,4292,4292,4292,4292,4292,4292,4296,4296,4296,4296,4296,4296,4295,4295,4295,4295,4295,4295,4293,4293,4293,4293,4293,4293,4830,4830,4830,4832,4832,4832,4831,4831,4831,4793,4762,4762,4763,4763,1257,4304,4304,4304,4304,4304,4304,4304,4298,4298,4298,4298,4298,4298,4298,4300,4300,4300,4300,4300,4300,4300,4302,4302,4302,4302,4302,4302,4302,4303,4303,4303,4303,4303,4303,4303,4301,4301,4301,4301,4301,4301,4301,4299,4299,4299,4299,4299,4299,4299,4825,4824,4824,4823,4822,4822,4260,4260,4260,4260,4258,4258,4258,4258,4261,4261,4261,4261,4259,4259,4259,4259,4788,4788,4788,4788,4787,4787,4787,4787,4786,4786,4786,4786,4785,4785,4785,4785,9668,9668,9668,9668,9666,9666,9666,9666,9665,9665,9665,9665,3395,4375,4375,4375,4375,4376,4376,4376,4376,4377,4377,4377,4377,4378,4378,4378,4378,8518,8517,1269,8762,8067,4771,4771,4771,4771,4771,4771,4769,4769,4769,4769,4769,4769,4775,4775,4775,4775,4775,4775,4773,4773,4773,4773,4773,4773,4779,4779,4779,4779,4779,4779,4777,4777,4777,4777,4777,4777,4803,4803,4803,4803,4811,4811,4811,4811,4808,4808,4808,4808,4798,4798,4798,4798,4806,4806,4806,4806,4801,4801,4801,4801,4796,4796,4796,4796,4794,4794,4794,4794,4841,4841,4841,4841,4837,4837,4837,4837,4845,4845,4845,4845,4847,4847,4847,4847,4843,4843,4843,4843,4839,4839,4839,4839,4835,4835,4835,4835,4833,4833,4833,4833,8065,4854,4854,4852,4852,4862,4862,4862,4862,4858,4858,4858,4858,4864,4864,4864,4864,4860,4860,4860,4860,4745,8412,8411,4390,4390,4390,4390,4390,4386,4386,4386,4386,4386,4387,4387,4387,4387,4387,4388,4388,4388,4388,4388,4389,4389,4389,4389,4389,4384,4384,4384,4384,4384,4384,4384,4383,4383,4383,4383,4383,4383,4383,4379,4379,4379,4379,4379,4379,4379,4381,4381,4381,4381,4381,4381,4381,4380,4380,4380,4380,4380,4380,4380,4382,4382,4382,4382,4382,4382,4382,4385,4385,4385,4385,4385,4385,4385,8133,4749,4263,4264,4817,4817,4817,4817,4816,4816,4816,4816,4814,4814,4814,4814,4815,4815,4815,4815,4827,4827,4827,4827,4826,4826,4826,4826,4829,4829,4829,4829,4828,4828,4828,4828,4857,4857,4856,4856,8509,8507,1261,8511,8510,4820,4820,4819,4821,4818,4818,8071,8056,8057,8058,4872,4872,4871,4871,9137,9101,9102,9103,9105,9106,8202,8203,8514,8273,6653,6653,6653,6654,6654,6654,6655,6655,6655,4748) | 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` = '8133' | 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` = '8133'
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` = '4375' | 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` = '4378'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 4 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '9101' | 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` = '9101'
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` = '1257' | 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` = '1257'
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` = '8511' | 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` = '8511'
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` = '2879' | 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` = '2879'
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` = '4749' | 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` = '4749'
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` = '8053' | 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` = '8053'
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` = '8056' | 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` = '8056'
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` = '8057' | 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` = '8057'
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` = '8058' | 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` = '8058'
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` = '4781' | 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` = '4784'
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.103 | 3917 |