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` = '20' | 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` = 20 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (11)
ORDER BY `level` ASC | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '20'
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 (20) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.071 | 1570 |
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 (9535,9535,9535,9535,9535,642,642,642,642,642,642,9188,9188,9188,9188,9188,9188,625,625,625,625,625,617,617,617,617,617,9511,9511,9511,9511,9511,9511,9942,9942,664,664,664,664,664,664,9515,9515,9515,9515,9515,9515,9515,659,659,659,659,659,9988,9988,9988,9988,9988,9988,4952,4952,4952,4952,4953,4953,4953,4953,4954,4954,4954,4954,4955,4955,4955,4955,4993,4993,4993,4993,4992,4992,4992,4992,4994,4994,4994,4994,4991,4991,4991,4991,4988,4988,4988,4988,4988,4987,4987,4987,4987,4987,4989,4989,4989,4989,4989,4990,4990,4990,4990,4990,4986,4986,4986,4986,4986,4999,4999,4999,4999,4999,4999,5000,5000,5000,5000,5000,5000,4995,4995,4995,4995,4995,4995,4997,4997,4997,4997,4997,4997,4996,4996,4996,4996,4996,4996,4998,4998,4998,4998,4998,4998,8331,721,721,721,721,721,721,721,720,720,720,720,720,720,720,726,726,726,726,726,726,726,722,722,722,722,722,722,722,724,724,724,724,724,724,724,725,725,725,725,725,725,725,723,723,723,723,723,723,723,5015,5015,5015,5015,5015,5019,5019,5019,5019,5019,5017,5017,5017,5017,5017,5018,5018,5018,5018,5018,5016,5016,5016,5016,5016,9538,9538,9538,9538,9538,9536,9536,9536,9536,9536,9534,9534,9534,9534,9534,9537,9537,9537,9537,9537,754,8539,4970,4970,4970,4970,4973,4973,4973,4973,4972,4972,4972,4972,4971,4971,4971,4971,15,8549,8548,1284,8833,8832,8834,8831,8530,1276,1276,8828,8827,8827,8826,8524,8527,8526,8525,8523,8522,8521,8533,1287,8836,8836,8836,8835,8835,8835,8535,8534,8536,8837,8837,8837,4974,4974,4974,4974,4974,4974,4974,4974,4976,4976,4976,4976,4976,4976,4976,4976,4979,4979,4979,4979,4979,4979,4979,4979,4980,4980,4980,4980,4980,4980,4980,4980,4977,4977,4977,4977,4977,4977,4977,4977,4975,4975,4975,4975,4975,4975,4975,4975,4978,4978,4978,4978,4978,4978,4978,4978,4981,4981,4981,4981,4981,4981,4981,4981,5026,5026,5026,5026,5026,5026,5026,5027,5027,5027,5027,5027,5027,5027,5029,5029,5029,5029,5029,5029,5029,5030,5030,5030,5030,5030,5030,5030,5031,5031,5031,5031,5031,5031,5031,5032,5032,5032,5032,5032,5032,5032,5028,5028,5028,5028,5028,5028,5028,769,8338,4985,4985,4985,4985,4984,4984,4984,4984,4983,4983,4983,4983,4982,4982,4982,4982,735,735,735,735,735,735,736,736,736,736,736,736,737,737,737,737,737,737,738,738,738,738,738,738,739,739,739,739,739,739,740,740,740,740,740,740,638,638,638,638,638,638,637,637,637,637,637,637,639,639,639,639,639,639,640,640,640,640,640,640,641,641,641,641,641,641,9496,9496,9496,9496,9496,9496,9496,9497,9497,9497,9497,9497,9497,9497,9498,9498,9498,9498,9498,9498,9498,9519,9519,9519,9519,9519,9519,9519,9520,9520,9520,9520,9520,9520,9520,9521,9521,9521,9521,9521,9521,9521,9522,9522,9522,9522,9522,9522,9522,3591,3591,3591,3590,3590,3590,3592,3592,3592,768,8538,9187,9187,9187,9187,9187,9187,9186,9186,9186,9186,9186,9186,9185,9185,9185,9185,9185,9185,9184,9184,9184,9184,9184,9184,9183,9183,9183,9183,9183,9183,7831,714,714,714,715,715,715,716,716,716,704,780,780,780,780,780,780,776,776,776,776,776,776,777,777,777,777,777,777,778,778,778,778,778,778,779,779,779,779,779,779,775,775,775,775,775,775,741,667,667,667,667,667,667,668,668,668,668,668,668,669,669,669,669,669,669,670,670,670,670,670,670,671,671,671,671,671,671,672,672,672,672,672,672,622,622,622,622,622,621,621,621,621,621,623,623,623,623,623,624,624,624,624,624,770,770,770,770,770,771,771,771,771,771,772,772,772,772,772,774,774,774,774,774,773,773,773,773,773,613,613,613,613,613,614,614,614,614,614,615,615,615,615,615,616,616,616,616,616,753,753,753,753,753,753,751,751,751,751,751,751,748,748,748,748,748,748,750,750,750,750,750,750,752,752,752,752,752,752,749,749,749,749,749,749,690,690,690,690,688,688,688,688,687,687,687,687,689,689,689,689,9506,9506,9506,9506,9506,9506,9507,9507,9507,9507,9507,9507,9508,9508,9508,9508,9508,9508,9509,9509,9509,9509,9509,9509,9510,9510,9510,9510,9510,9510,3589,5023,5023,5023,5023,5023,5021,5021,5021,5021,5021,5024,5024,5024,5024,5024,5022,5022,5022,5022,5022,5020,5020,5020,5020,5020,9941,9941,5471,5471,5471,5472,5472,5472,5473,5473,5473,8122,7827,7827,7827,7827,7828,7828,7828,7828,7829,7829,7829,7829,7830,7830,7830,7830,717,717,717,719,719,719,718,718,718,4919,4919,4919,4919,4919,4917,4917,4917,4917,4917,4918,4918,4918,4918,4918,4920,4920,4920,4920,4920,4921,4921,4921,4921,4921,631,631,631,631,631,631,635,635,635,635,635,635,632,632,632,632,632,632,633,633,633,633,633,633,634,634,634,634,634,634,636,636,636,636,636,636,645,645,645,645,645,648,648,648,648,648,649,649,649,649,649,646,646,646,646,646,647,647,647,647,647,661,661,661,661,661,661,662,662,662,662,662,662,663,663,663,663,663,663,665,665,665,665,665,665,666,666,666,666,666,666,9944,781,781,781,781,781,781,782,782,782,782,782,782,786,786,786,786,786,786,785,785,785,785,785,785,784,784,784,784,784,784,783,783,783,783,783,783,675,675,675,675,675,675,673,673,673,673,673,673,674,674,674,674,674,674,676,676,676,676,676,676,677,677,677,677,677,677,678,678,678,678,678,678,7022,7022,7022,7022,7022,7025,7025,7025,7025,7025,7021,7021,7021,7021,7021,7023,7023,7023,7023,7023,7024,7024,7024,7024,7024,707,707,707,707,707,707,708,708,708,708,708,708,709,709,709,709,709,709,710,710,710,710,710,710,706,706,706,706,706,706,705,705,705,705,705,705,767,8340,742,8339,9513,9513,9513,9513,9513,9513,9513,9514,9514,9514,9514,9514,9514,9514,9516,9516,9516,9516,9516,9516,9516,9517,9517,9517,9517,9517,9517,9517,9518,9518,9518,9518,9518,9518,9518,9512,9512,9512,9512,9512,9512,9512,730,730,730,730,730,730,730,730,730,729,729,729,729,729,729,729,729,729,733,733,733,733,733,733,733,733,733,727,727,727,727,727,727,727,727,727,734,734,734,734,734,734,734,734,734,732,732,732,732,732,732,732,732,732,731,731,731,731,731,731,731,731,731,728,728,728,728,728,728,728,728,728,9950,9950,9950,9950,9950,9950,9950,9950,9950,761,761,761,761,761,761,761,760,760,760,760,760,760,760,763,763,763,763,763,763,763,764,764,764,764,764,764,764,765,765,765,765,765,765,765,762,762,762,762,762,762,762,766,766,766,766,766,766,766,9503,9503,9503,9503,9503,9503,9503,9500,9500,9500,9500,9500,9500,9500,9499,9499,9499,9499,9499,9499,9499,9501,9501,9501,9501,9501,9501,9501,9502,9502,9502,9502,9502,9502,9502,9504,9504,9504,9504,9504,9504,9504,9505,9505,9505,9505,9505,9505,9505,743,743,743,743,745,745,745,745,744,744,744,744,746,746,746,746,8077,692,692,692,692,692,692,693,693,693,693,693,693,695,695,695,695,695,695,696,696,696,696,696,696,697,697,697,697,697,697,694,694,694,694,694,694,9138,8272,658,658,658,658,658,656,656,656,656,656,657,657,657,657,657,660,660,660,660,660,4888,4888,4888,4888,4888,4888,4891,4891,4891,4891,4891,4891,4889,4889,4889,4889,4889,4889,4890,4890,4890,4890,4890,4890,4892,4892,4892,4892,4892,4892,4893,4893,4893,4893,4893,4893,699,699,699,699,699,699,702,702,702,702,702,702,703,703,703,703,703,703,700,700,700,700,700,700,701,701,701,701,701,701,698,698,698,698,698,698,9983,9983,9983,9983,9983,9983,9984,9984,9984,9984,9984,9984,9985,9985,9985,9985,9985,9985,9986,9986,9986,9986,9986,9986,9987,9987,9987,9987,9987,9987,680,680,680,680,680,680,681,681,681,681,681,681,684,684,684,684,684,684,682,682,682,682,682,682,683,683,683,683,683,683,679,679,679,679,679,679) ) as s GROUP BY id_product_ps ) as ss | 0.012 | 94 |
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 (9535,9535,9535,9535,9535,642,642,642,642,642,642,9188,9188,9188,9188,9188,9188,625,625,625,625,625,617,617,617,617,617,9511,9511,9511,9511,9511,9511,9942,9942,664,664,664,664,664,664,9515,9515,9515,9515,9515,9515,9515,659,659,659,659,659,9988,9988,9988,9988,9988,9988,4952,4952,4952,4952,4953,4953,4953,4953,4954,4954,4954,4954,4955,4955,4955,4955,4993,4993,4993,4993,4992,4992,4992,4992,4994,4994,4994,4994,4991,4991,4991,4991,4988,4988,4988,4988,4988,4987,4987,4987,4987,4987,4989,4989,4989,4989,4989,4990,4990,4990,4990,4990,4986,4986,4986,4986,4986,4999,4999,4999,4999,4999,4999,5000,5000,5000,5000,5000,5000,4995,4995,4995,4995,4995,4995,4997,4997,4997,4997,4997,4997,4996,4996,4996,4996,4996,4996,4998,4998,4998,4998,4998,4998,8331,721,721,721,721,721,721,721,720,720,720,720,720,720,720,726,726,726,726,726,726,726,722,722,722,722,722,722,722,724,724,724,724,724,724,724,725,725,725,725,725,725,725,723,723,723,723,723,723,723,5015,5015,5015,5015,5015,5019,5019,5019,5019,5019,5017,5017,5017,5017,5017,5018,5018,5018,5018,5018,5016,5016,5016,5016,5016,9538,9538,9538,9538,9538,9536,9536,9536,9536,9536,9534,9534,9534,9534,9534,9537,9537,9537,9537,9537,754,8539,4970,4970,4970,4970,4973,4973,4973,4973,4972,4972,4972,4972,4971,4971,4971,4971,15,8549,8548,1284,8833,8832,8834,8831,8530,1276,1276,8828,8827,8827,8826,8524,8527,8526,8525,8523,8522,8521,8533,1287,8836,8836,8836,8835,8835,8835,8535,8534,8536,8837,8837,8837,4974,4974,4974,4974,4974,4974,4974,4974,4976,4976,4976,4976,4976,4976,4976,4976,4979,4979,4979,4979,4979,4979,4979,4979,4980,4980,4980,4980,4980,4980,4980,4980,4977,4977,4977,4977,4977,4977,4977,4977,4975,4975,4975,4975,4975,4975,4975,4975,4978,4978,4978,4978,4978,4978,4978,4978,4981,4981,4981,4981,4981,4981,4981,4981,5026,5026,5026,5026,5026,5026,5026,5027,5027,5027,5027,5027,5027,5027,5029,5029,5029,5029,5029,5029,5029,5030,5030,5030,5030,5030,5030,5030,5031,5031,5031,5031,5031,5031,5031,5032,5032,5032,5032,5032,5032,5032,5028,5028,5028,5028,5028,5028,5028,769,8338,4985,4985,4985,4985,4984,4984,4984,4984,4983,4983,4983,4983,4982,4982,4982,4982,735,735,735,735,735,735,736,736,736,736,736,736,737,737,737,737,737,737,738,738,738,738,738,738,739,739,739,739,739,739,740,740,740,740,740,740,638,638,638,638,638,638,637,637,637,637,637,637,639,639,639,639,639,639,640,640,640,640,640,640,641,641,641,641,641,641,9496,9496,9496,9496,9496,9496,9496,9497,9497,9497,9497,9497,9497,9497,9498,9498,9498,9498,9498,9498,9498,9519,9519,9519,9519,9519,9519,9519,9520,9520,9520,9520,9520,9520,9520,9521,9521,9521,9521,9521,9521,9521,9522,9522,9522,9522,9522,9522,9522,3591,3591,3591,3590,3590,3590,3592,3592,3592,768,8538,9187,9187,9187,9187,9187,9187,9186,9186,9186,9186,9186,9186,9185,9185,9185,9185,9185,9185,9184,9184,9184,9184,9184,9184,9183,9183,9183,9183,9183,9183,7831,714,714,714,715,715,715,716,716,716,704,780,780,780,780,780,780,776,776,776,776,776,776,777,777,777,777,777,777,778,778,778,778,778,778,779,779,779,779,779,779,775,775,775,775,775,775,741,667,667,667,667,667,667,668,668,668,668,668,668,669,669,669,669,669,669,670,670,670,670,670,670,671,671,671,671,671,671,672,672,672,672,672,672,622,622,622,622,622,621,621,621,621,621,623,623,623,623,623,624,624,624,624,624,770,770,770,770,770,771,771,771,771,771,772,772,772,772,772,774,774,774,774,774,773,773,773,773,773,613,613,613,613,613,614,614,614,614,614,615,615,615,615,615,616,616,616,616,616,753,753,753,753,753,753,751,751,751,751,751,751,748,748,748,748,748,748,750,750,750,750,750,750,752,752,752,752,752,752,749,749,749,749,749,749,690,690,690,690,688,688,688,688,687,687,687,687,689,689,689,689,9506,9506,9506,9506,9506,9506,9507,9507,9507,9507,9507,9507,9508,9508,9508,9508,9508,9508,9509,9509,9509,9509,9509,9509,9510,9510,9510,9510,9510,9510,3589,5023,5023,5023,5023,5023,5021,5021,5021,5021,5021,5024,5024,5024,5024,5024,5022,5022,5022,5022,5022,5020,5020,5020,5020,5020,9941,9941,5471,5471,5471,5472,5472,5472,5473,5473,5473,8122,7827,7827,7827,7827,7828,7828,7828,7828,7829,7829,7829,7829,7830,7830,7830,7830,717,717,717,719,719,719,718,718,718,4919,4919,4919,4919,4919,4917,4917,4917,4917,4917,4918,4918,4918,4918,4918,4920,4920,4920,4920,4920,4921,4921,4921,4921,4921,631,631,631,631,631,631,635,635,635,635,635,635,632,632,632,632,632,632,633,633,633,633,633,633,634,634,634,634,634,634,636,636,636,636,636,636,645,645,645,645,645,648,648,648,648,648,649,649,649,649,649,646,646,646,646,646,647,647,647,647,647,661,661,661,661,661,661,662,662,662,662,662,662,663,663,663,663,663,663,665,665,665,665,665,665,666,666,666,666,666,666,9944,781,781,781,781,781,781,782,782,782,782,782,782,786,786,786,786,786,786,785,785,785,785,785,785,784,784,784,784,784,784,783,783,783,783,783,783,675,675,675,675,675,675,673,673,673,673,673,673,674,674,674,674,674,674,676,676,676,676,676,676,677,677,677,677,677,677,678,678,678,678,678,678,7022,7022,7022,7022,7022,7025,7025,7025,7025,7025,7021,7021,7021,7021,7021,7023,7023,7023,7023,7023,7024,7024,7024,7024,7024,707,707,707,707,707,707,708,708,708,708,708,708,709,709,709,709,709,709,710,710,710,710,710,710,706,706,706,706,706,706,705,705,705,705,705,705,767,8340,742,8339,9513,9513,9513,9513,9513,9513,9513,9514,9514,9514,9514,9514,9514,9514,9516,9516,9516,9516,9516,9516,9516,9517,9517,9517,9517,9517,9517,9517,9518,9518,9518,9518,9518,9518,9518,9512,9512,9512,9512,9512,9512,9512,730,730,730,730,730,730,730,730,730,729,729,729,729,729,729,729,729,729,733,733,733,733,733,733,733,733,733,727,727,727,727,727,727,727,727,727,734,734,734,734,734,734,734,734,734,732,732,732,732,732,732,732,732,732,731,731,731,731,731,731,731,731,731,728,728,728,728,728,728,728,728,728,9950,9950,9950,9950,9950,9950,9950,9950,9950,761,761,761,761,761,761,761,760,760,760,760,760,760,760,763,763,763,763,763,763,763,764,764,764,764,764,764,764,765,765,765,765,765,765,765,762,762,762,762,762,762,762,766,766,766,766,766,766,766,9503,9503,9503,9503,9503,9503,9503,9500,9500,9500,9500,9500,9500,9500,9499,9499,9499,9499,9499,9499,9499,9501,9501,9501,9501,9501,9501,9501,9502,9502,9502,9502,9502,9502,9502,9504,9504,9504,9504,9504,9504,9504,9505,9505,9505,9505,9505,9505,9505,743,743,743,743,745,745,745,745,744,744,744,744,746,746,746,746,8077,692,692,692,692,692,692,693,693,693,693,693,693,695,695,695,695,695,695,696,696,696,696,696,696,697,697,697,697,697,697,694,694,694,694,694,694,9138,8272,658,658,658,658,658,656,656,656,656,656,657,657,657,657,657,660,660,660,660,660,4888,4888,4888,4888,4888,4888,4891,4891,4891,4891,4891,4891,4889,4889,4889,4889,4889,4889,4890,4890,4890,4890,4890,4890,4892,4892,4892,4892,4892,4892,4893,4893,4893,4893,4893,4893,699,699,699,699,699,699,702,702,702,702,702,702,703,703,703,703,703,703,700,700,700,700,700,700,701,701,701,701,701,701,698,698,698,698,698,698,9983,9983,9983,9983,9983,9983,9984,9984,9984,9984,9984,9984,9985,9985,9985,9985,9985,9985,9986,9986,9986,9986,9986,9986,9987,9987,9987,9987,9987,9987,680,680,680,680,680,680,681,681,681,681,681,681,684,684,684,684,684,684,682,682,682,682,682,682,683,683,683,683,683,683,679,679,679,679,679,679) ) 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 0 ,12 | 0.016 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (9535,9535,9535,9535,9535,642,642,642,642,642,642,9188,9188,9188,9188,9188,9188,625,625,625,625,625,617,617,617,617,617,9511,9511,9511,9511,9511,9511,9942,9942,664,664,664,664,664,664,9515,9515,9515,9515,9515,9515,9515,659,659,659,659,659,9988,9988,9988,9988,9988,9988,4952,4952,4952,4952,4953,4953,4953,4953,4954,4954,4954,4954,4955,4955,4955,4955,4993,4993,4993,4993,4992,4992,4992,4992,4994,4994,4994,4994,4991,4991,4991,4991,4988,4988,4988,4988,4988,4987,4987,4987,4987,4987,4989,4989,4989,4989,4989,4990,4990,4990,4990,4990,4986,4986,4986,4986,4986,4999,4999,4999,4999,4999,4999,5000,5000,5000,5000,5000,5000,4995,4995,4995,4995,4995,4995,4997,4997,4997,4997,4997,4997,4996,4996,4996,4996,4996,4996,4998,4998,4998,4998,4998,4998,8331,721,721,721,721,721,721,721,720,720,720,720,720,720,720,726,726,726,726,726,726,726,722,722,722,722,722,722,722,724,724,724,724,724,724,724,725,725,725,725,725,725,725,723,723,723,723,723,723,723,5015,5015,5015,5015,5015,5019,5019,5019,5019,5019,5017,5017,5017,5017,5017,5018,5018,5018,5018,5018,5016,5016,5016,5016,5016,9538,9538,9538,9538,9538,9536,9536,9536,9536,9536,9534,9534,9534,9534,9534,9537,9537,9537,9537,9537,754,8539,4970,4970,4970,4970,4973,4973,4973,4973,4972,4972,4972,4972,4971,4971,4971,4971,15,8549,8548,1284,8833,8832,8834,8831,8530,1276,1276,8828,8827,8827,8826,8524,8527,8526,8525,8523,8522,8521,8533,1287,8836,8836,8836,8835,8835,8835,8535,8534,8536,8837,8837,8837,4974,4974,4974,4974,4974,4974,4974,4974,4976,4976,4976,4976,4976,4976,4976,4976,4979,4979,4979,4979,4979,4979,4979,4979,4980,4980,4980,4980,4980,4980,4980,4980,4977,4977,4977,4977,4977,4977,4977,4977,4975,4975,4975,4975,4975,4975,4975,4975,4978,4978,4978,4978,4978,4978,4978,4978,4981,4981,4981,4981,4981,4981,4981,4981,5026,5026,5026,5026,5026,5026,5026,5027,5027,5027,5027,5027,5027,5027,5029,5029,5029,5029,5029,5029,5029,5030,5030,5030,5030,5030,5030,5030,5031,5031,5031,5031,5031,5031,5031,5032,5032,5032,5032,5032,5032,5032,5028,5028,5028,5028,5028,5028,5028,769,8338,4985,4985,4985,4985,4984,4984,4984,4984,4983,4983,4983,4983,4982,4982,4982,4982,735,735,735,735,735,735,736,736,736,736,736,736,737,737,737,737,737,737,738,738,738,738,738,738,739,739,739,739,739,739,740,740,740,740,740,740,638,638,638,638,638,638,637,637,637,637,637,637,639,639,639,639,639,639,640,640,640,640,640,640,641,641,641,641,641,641,9496,9496,9496,9496,9496,9496,9496,9497,9497,9497,9497,9497,9497,9497,9498,9498,9498,9498,9498,9498,9498,9519,9519,9519,9519,9519,9519,9519,9520,9520,9520,9520,9520,9520,9520,9521,9521,9521,9521,9521,9521,9521,9522,9522,9522,9522,9522,9522,9522,3591,3591,3591,3590,3590,3590,3592,3592,3592,768,8538,9187,9187,9187,9187,9187,9187,9186,9186,9186,9186,9186,9186,9185,9185,9185,9185,9185,9185,9184,9184,9184,9184,9184,9184,9183,9183,9183,9183,9183,9183,7831,714,714,714,715,715,715,716,716,716,704,780,780,780,780,780,780,776,776,776,776,776,776,777,777,777,777,777,777,778,778,778,778,778,778,779,779,779,779,779,779,775,775,775,775,775,775,741,667,667,667,667,667,667,668,668,668,668,668,668,669,669,669,669,669,669,670,670,670,670,670,670,671,671,671,671,671,671,672,672,672,672,672,672,622,622,622,622,622,621,621,621,621,621,623,623,623,623,623,624,624,624,624,624,770,770,770,770,770,771,771,771,771,771,772,772,772,772,772,774,774,774,774,774,773,773,773,773,773,613,613,613,613,613,614,614,614,614,614,615,615,615,615,615,616,616,616,616,616,753,753,753,753,753,753,751,751,751,751,751,751,748,748,748,748,748,748,750,750,750,750,750,750,752,752,752,752,752,752,749,749,749,749,749,749,690,690,690,690,688,688,688,688,687,687,687,687,689,689,689,689,9506,9506,9506,9506,9506,9506,9507,9507,9507,9507,9507,9507,9508,9508,9508,9508,9508,9508,9509,9509,9509,9509,9509,9509,9510,9510,9510,9510,9510,9510,3589,5023,5023,5023,5023,5023,5021,5021,5021,5021,5021,5024,5024,5024,5024,5024,5022,5022,5022,5022,5022,5020,5020,5020,5020,5020,9941,9941,5471,5471,5471,5472,5472,5472,5473,5473,5473,8122,7827,7827,7827,7827,7828,7828,7828,7828,7829,7829,7829,7829,7830,7830,7830,7830,717,717,717,719,719,719,718,718,718,4919,4919,4919,4919,4919,4917,4917,4917,4917,4917,4918,4918,4918,4918,4918,4920,4920,4920,4920,4920,4921,4921,4921,4921,4921,631,631,631,631,631,631,635,635,635,635,635,635,632,632,632,632,632,632,633,633,633,633,633,633,634,634,634,634,634,634,636,636,636,636,636,636,645,645,645,645,645,648,648,648,648,648,649,649,649,649,649,646,646,646,646,646,647,647,647,647,647,661,661,661,661,661,661,662,662,662,662,662,662,663,663,663,663,663,663,665,665,665,665,665,665,666,666,666,666,666,666,9944,781,781,781,781,781,781,782,782,782,782,782,782,786,786,786,786,786,786,785,785,785,785,785,785,784,784,784,784,784,784,783,783,783,783,783,783,675,675,675,675,675,675,673,673,673,673,673,673,674,674,674,674,674,674,676,676,676,676,676,676,677,677,677,677,677,677,678,678,678,678,678,678,7022,7022,7022,7022,7022,7025,7025,7025,7025,7025,7021,7021,7021,7021,7021,7023,7023,7023,7023,7023,7024,7024,7024,7024,7024,707,707,707,707,707,707,708,708,708,708,708,708,709,709,709,709,709,709,710,710,710,710,710,710,706,706,706,706,706,706,705,705,705,705,705,705,767,8340,742,8339,9513,9513,9513,9513,9513,9513,9513,9514,9514,9514,9514,9514,9514,9514,9516,9516,9516,9516,9516,9516,9516,9517,9517,9517,9517,9517,9517,9517,9518,9518,9518,9518,9518,9518,9518,9512,9512,9512,9512,9512,9512,9512,730,730,730,730,730,730,730,730,730,729,729,729,729,729,729,729,729,729,733,733,733,733,733,733,733,733,733,727,727,727,727,727,727,727,727,727,734,734,734,734,734,734,734,734,734,732,732,732,732,732,732,732,732,732,731,731,731,731,731,731,731,731,731,728,728,728,728,728,728,728,728,728,9950,9950,9950,9950,9950,9950,9950,9950,9950,761,761,761,761,761,761,761,760,760,760,760,760,760,760,763,763,763,763,763,763,763,764,764,764,764,764,764,764,765,765,765,765,765,765,765,762,762,762,762,762,762,762,766,766,766,766,766,766,766,9503,9503,9503,9503,9503,9503,9503,9500,9500,9500,9500,9500,9500,9500,9499,9499,9499,9499,9499,9499,9499,9501,9501,9501,9501,9501,9501,9501,9502,9502,9502,9502,9502,9502,9502,9504,9504,9504,9504,9504,9504,9504,9505,9505,9505,9505,9505,9505,9505,743,743,743,743,745,745,745,745,744,744,744,744,746,746,746,746,8077,692,692,692,692,692,692,693,693,693,693,693,693,695,695,695,695,695,695,696,696,696,696,696,696,697,697,697,697,697,697,694,694,694,694,694,694,9138,8272,658,658,658,658,658,656,656,656,656,656,657,657,657,657,657,660,660,660,660,660,4888,4888,4888,4888,4888,4888,4891,4891,4891,4891,4891,4891,4889,4889,4889,4889,4889,4889,4890,4890,4890,4890,4890,4890,4892,4892,4892,4892,4892,4892,4893,4893,4893,4893,4893,4893,699,699,699,699,699,699,702,702,702,702,702,702,703,703,703,703,703,703,700,700,700,700,700,700,701,701,701,701,701,701,698,698,698,698,698,698,9983,9983,9983,9983,9983,9983,9984,9984,9984,9984,9984,9984,9985,9985,9985,9985,9985,9985,9986,9986,9986,9986,9986,9986,9987,9987,9987,9987,9987,9987,680,680,680,680,680,680,681,681,681,681,681,681,684,684,684,684,684,684,682,682,682,682,682,682,683,683,683,683,683,683,679,679,679,679,679,679) | 0.002 | 1570 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (15,614,615,617,613,616,615,613,616,617,614,613,617,615,616,614,617,615,613,614,616,616,615,613,617,614,622,623,625,621,624,623,624,621,625,622,621,625,623,624,622,625,623,621,622,624,624,623,621,622,625,636,632,635,633,631,634,636,635,631,633,634,632,632,636,631,635,633,634,636,632,635,631,633,634,636,632,634,631,633,635,635,634,632,633,631,636,642,638,641,639,640,637,642,641,639,637,640,638,638,642,637,641,639,640,642,638,641,637,639,640,642,638,640,637,639,641,641,640,638,637,639,642,646,647,649,645,648,647,648,649,645,646,645,649,647,648,646,649,645,647,646,648,648,647,645,646,649,657,658,660,656,659,658,659,656,660,657,656,660,658,659,657,660,658,656,657,659,659,658,656,657,660,666,662,665,663,661,664,666,665,663,661,664,662,662,666,661,665,664,663,662,666,665,661,663,664,666,662,664,661,663,665,665,662,664,663,661,666,672,668,671,669,667,670,672,671,667,669,670,668,668,672,667,671,670,669,668,672,671,667,669,670,668,672,670,667,669,671,671,670,668,669,667,672,678,674,677,675,673,676,678,677,673,675,676,674,674,678,673,677,676,675,674,678,677,673,675,676,678,674,676,673,675,677,677,674,676,675,673,678,684,680,683,681,679,682,684,683,679,681,682,680,680,684,679,683,682,681,680,684,683,679,681,682,680,684,682,679,681,683,683,682,680,681,679,684,690,688,687,689,690,687,688,689,687,690,688,689,689,687,688,690,697,693,696,694,695,692,697,696,694,695,692,693,693,697,692,696,694,695,697,693,696,692,694,695,693,697,695,692,694,696,696,695,693,694,692,697,703,699,702,700,701,698,703,702,700,698,701,699,699,703,698,702,700,701,699,703,702,698,700,701,699,703,701,698,700,702,702,699,701,698,700,703,704,710,706,709,707,705,708,710,709,707,705,708,706,706,710,705,709,707,708,706,710,709,705,707,708,710,706,708,705,707,709,709,706,708,705,707,710,715,716,714,715,716,714,715,714,716,718,717,719,718,719,717,718,717,719,722,726,725,721,723,724,720,722,723,726,725,720,724,721,723,721,725,726,720,724,722,721,726,720,725,724,723,722,726,725,721,720,723,724,722,726,721,724,723,720,725,722,725,724,723,721,720,726,722,9950,730,734,729,733,728,731,727,732,9950,730,731,729,734,727,733,732,728,9950,730,731,728,734,733,727,732,729,731,729,734,728,733,9950,732,727,730,729,9950,728,734,727,733,731,732,730,9950,729,734,728,733,727,731,730,732,9950,734,729,728,732,731,727,733,730,9950,729,733,732,728,731,727,730,734,740,736,739,737,735,738,740,739,737,735,738,736,736,740,735,739,737,738,736,740,739,735,737,738,736,740,738,735,737,739,739,736,738,735,737,740,741,742,746,744,745,743,746,743,744,745,746,743,744,745,745,744,743,746,753,749,752,750,751,748,753,752,750,748,751,749,749,753,748,752,751,750,749,753,752,748,750,751,753,749,751,748,750,752,752,749,751,750,748,753,754,762,766,765,761,763,760,764,762,763,766,760,765,764,761,763,761,765,766,760,764,762,761,766,760,765,764,763,762,766,765,761,760,763,764,762,766,764,761,760,763,762,765,765,764,763,761,760,762,766,767,768,769,771,772,774,770,773,772,770,773,774,771,770,774,773,772,771,774,770,772,771,773,773,772,770,774,771,780,776,779,777,775,778,780,779,777,775,778,776,776,780,775,779,777,778,776,780,779,775,777,778,776,780,778,775,777,779,779,776,778,777,775,780,786,782,785,783,781,784,786,785,781,783,784,782,782,786,781,785,783,784,786,782,785,781,783,784,786,782,784,781,783,785,785,784,782,781,783,786,8827,1276,1284,1287,3589,3591,3592,3590,3591,3592,3590,3591,3590,3592,4893,4889,4892,4890,4888,4891,4893,4892,4890,4888,4891,4889,4889,4893,4888,4892,4891,4890,4893,4889,4892,4888,4890,4891,4893,4889,4891,4888,4890,4892,4892,4889,4891,4888,4890,4893,4918,4919,4921,4917,4920,4919,4920,4921,4917,4918,4917,4921,4920,4919,4918,4921,4917,4919,4918,4920,4920,4919,4917,4921,4918,4955,4953,4952,4954,4952,4955,4953,4954,4952,4955,4953,4954,4954,4953,4952,4955,4973,4971,4970,4972,4970,4973,4971,4972,4973,4970,4971,4972,4972,4970,4971,4973,4981,4976,4980,4975,4979,4977,4974,4978,4981,4976,4980,4977,4979,4974,4978,4975,4981,4980,4979,4975,4977,4978,4974,4976,4976,4981,4975,4974,4980,4979,4977,4978,4981,4976,4980,4975,4979,4974,4977,4978,4981,4976,4980,4975,4978,4974,4977,4979,4976,4981,4979,4978,4975,4974,4977,4980,4980,4979,4976,4978,4975,4974,4977,4981,4985,4983,4982,4984,4985,4982,4984,4983,4982,4985,4983,4984,4984,4982,4983,4985,4987,4988,4990,4989,4986,4988,4986,4989,4990,4987,4986,4990,4988,4989,4987,4990,4986,4988,4989,4987,4989,4988,4986,4990,4987,4994,4992,4993,4991,4991,4994,4992,4993,4994,4991,4992,4993,4993,4991,4992,4994,5000,4996,4999,4997,4998,4995,5000,4999,4995,4997,4998,4996,4996,5000,4995,4999,4997,4998,4996,5000,4999,4995,4997,4998,4996,5000,4998,4995,4997,4999,4999,4998,4996,4995,4997,5000,5016,5017,5019,5015,5018,5017,5015,5018,5019,5016,5015,5019,5017,5018,5016,5019,5015,5017,5016,5018,5018,5017,5015,5016,5019,5021,5022,5024,5023,5020,5022,5020,5023,5024,5021,5020,5024,5023,5022,5021,5024,5020,5022,5023,5021,5023,5022,5020,5024,5021,5028,5032,5031,5027,5029,5026,5030,5028,5029,5032,5026,5031,5030,5027,5029,5027,5031,5032,5026,5030,5028,5027,5032,5026,5031,5029,5030,5028,5032,5027,5031,5029,5026,5028,5030,5032,5027,5030,5026,5029,5031,5028,5031,5030,5027,5029,5026,5032,5028,5472,5473,5471,5473,5472,5471,5472,5473,5471,7022,7023,7025,7024,7021,7023,7021,7024,7025,7022,7021,7025,7023,7024,7022,7025,7023,7021,7024,7022,7024,7023,7021,7022,7025,7830,7828,7829,7827,7827,7830,7829,7828,7830,7827,7828,7829,7829,7828,7827,7830,7831,8077,8122,8272,8331,8338,8339,8340,8521,8522,8523,8524,8525,8526,8527,8530,8533,8534,8535,8536,8538,8539,8548,8549,8826,8827,1276,8828,8831,8832,8833,8834,8837,8836,8835,8837,8835,8836,8836,8837,8835,9138,9188,9184,9187,9185,9186,9183,9188,9187,9185,9183,9186,9184,9184,9188,9183,9187,9185,9186,9188,9184,9187,9183,9185,9186,9184,9188,9186,9183,9185,9187,9187,9186,9184,9185,9183,9188,9498,9522,9521,9497,9519,9496,9520,9498,9519,9522,9496,9521,9520,9497,9519,9521,9497,9522,9520,9496,9498,9501,9505,9504,9500,9502,9503,9499,9501,9502,9505,9499,9504,9503,9500,9502,9500,9504,9505,9503,9499,9501,9500,9505,9499,9504,9503,9502,9501,9505,9500,9504,9499,9502,9503,9501,9505,9500,9503,9502,9499,9501,9504,9504,9503,9502,9500,9499,9501,9505,9511,9507,9510,9508,9506,9509,9511,9510,9506,9508,9509,9507,9507,9511,9506,9510,9508,9509,9507,9511,9510,9506,9508,9509,9507,9511,9509,9506,9508,9510,9510,9507,9509,9506,9508,9511,9514,9518,9517,9513,9515,9512,9516,9514,9515,9518,9517,9512,9516,9513,9515,9517,9513,9518,9512,9516,9514,9513,9518,9512,9517,9516,9515,9514,9518,9517,9513,9512,9515,9514,9516,9518,9513,9516,9515,9512,9514,9517,9517,9516,9513,9515,9512,9514,9518,9497,9522,9496,9521,9520,9519,9498,9522,9497,9521,9496,9519,9520,9498,9522,9497,9520,9519,9496,9498,9521,9521,9520,9519,9497,9496,9522,9498,9535,9536,9538,9537,9534,9537,9538,9535,9536,9534,9538,9537,9535,9534,9536,9534,9536,9538,9535,9537,9536,9535,9537,9538,9534,9942,9941,9941,9942,9944,729,734,728,733,730,727,732,9950,731,9988,9984,9987,9985,9983,9986,9988,9987,9983,9985,9986,9984,9984,9988,9983,9987,9986,9985,9988,9984,9987,9983,9985,9986,9988,9984,9986,9983,9985,9987,9987,9986,9984,9983,9985,9988) | 0.002 | 1570 |
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 (15,614,615,617,616,613,613,614,617,616,615,614,617,613,616,615,617,614,615,613,616,616,614,615,613,617,622,623,625,624,621,621,622,625,624,623,622,625,621,624,623,625,622,623,621,624,624,622,623,621,625,636,632,633,635,634,631,635,636,634,633,631,632,636,632,635,631,634,633,636,635,632,631,633,634,636,632,634,631,635,633,635,634,632,631,633,636,642,638,639,641,640,637,641,642,640,639,637,638,642,638,641,637,640,639,642,641,638,637,640,639,642,638,640,637,641,639,641,638,640,637,639,642,646,647,649,648,645,645,646,649,648,647,646,649,645,648,647,649,646,647,645,648,648,646,647,645,649,657,658,660,659,656,656,657,660,659,658,657,660,656,659,658,660,657,658,656,659,659,657,658,656,660,666,662,663,665,664,661,665,666,664,663,661,662,666,662,665,661,664,663,666,665,662,661,663,664,666,662,664,661,665,663,665,662,664,661,666,663,672,668,669,671,670,667,671,672,670,669,667,668,672,668,671,667,670,669,672,671,668,667,669,670,672,668,670,667,671,669,671,668,670,667,672,669,678,674,675,677,676,673,677,678,676,675,673,674,678,674,677,673,676,675,678,677,674,673,675,676,678,674,676,673,677,675,677,674,676,673,675,678,684,680,681,683,682,679,683,684,682,681,679,680,684,680,683,679,682,681,684,683,680,679,681,682,684,680,682,679,681,683,683,682,680,679,684,681,689,690,688,687,690,689,687,688,690,687,688,689,689,687,690,688,697,693,694,696,695,692,696,697,695,694,692,693,697,693,696,692,695,694,697,696,693,692,694,695,697,693,695,692,696,694,696,695,693,692,697,694,703,699,700,702,701,698,702,703,701,700,698,699,703,699,702,698,701,700,703,702,699,698,701,700,703,699,701,698,702,700,702,699,701,698,703,700,704,710,706,707,709,708,705,709,710,708,707,705,706,710,706,709,705,708,707,710,709,706,705,708,707,710,706,708,705,707,709,709,706,708,705,710,707,714,716,715,716,714,715,714,715,716,717,719,718,719,717,718,718,717,719,722,723,726,721,725,724,720,722,723,726,725,724,720,721,721,720,726,722,725,724,723,722,726,721,725,720,724,723,726,722,725,721,723,720,724,726,722,724,721,720,723,725,725,722,724,723,721,720,726,730,9950,729,734,731,728,733,732,727,730,731,9950,729,734,733,732,727,728,730,731,9950,734,733,728,732,727,729,729,728,9950,727,730,734,733,732,731,730,729,728,734,9950,733,727,732,731,730,734,9950,733,729,728,731,727,732,730,734,9950,729,732,728,727,731,733,730,9950,733,729,732,728,727,731,734,740,736,737,739,738,735,739,740,738,737,735,736,740,736,739,735,738,737,740,739,736,735,738,737,740,736,738,735,739,737,739,738,736,735,740,737,741,742,745,746,744,743,746,745,743,744,746,743,744,745,745,743,746,744,753,749,750,752,751,748,752,753,751,750,748,749,753,749,752,748,751,750,753,752,749,748,750,751,753,749,751,748,752,750,752,749,751,748,750,753,754,762,763,766,761,765,764,760,762,763,766,765,764,760,761,761,760,766,762,765,764,763,762,766,761,765,760,764,763,766,762,765,761,763,760,764,766,762,764,761,760,763,765,765,762,764,763,761,760,766,767,768,769,771,772,774,773,770,770,771,774,773,772,771,774,770,773,772,774,771,772,770,773,773,771,772,770,774,780,776,777,779,778,775,779,780,778,777,775,776,780,776,779,775,778,777,780,779,776,775,777,778,780,776,778,775,779,777,779,776,778,775,777,780,786,782,783,785,784,781,785,786,784,783,781,782,786,782,785,781,784,783,786,785,782,781,784,783,786,782,784,781,785,783,785,784,782,783,781,786,8827,1276,1284,1287,3589,3590,3592,3591,3592,3590,3591,3590,3591,3592,4893,4889,4890,4892,4891,4888,4892,4893,4891,4890,4888,4889,4893,4889,4892,4888,4891,4890,4893,4892,4889,4888,4890,4891,4893,4889,4891,4888,4892,4890,4892,4889,4891,4888,4890,4893,4918,4919,4921,4920,4917,4917,4918,4921,4920,4919,4918,4921,4917,4920,4919,4921,4918,4919,4917,4920,4920,4918,4919,4917,4921,4954,4955,4953,4952,4955,4954,4952,4953,4955,4952,4954,4953,4954,4952,4955,4953,4972,4973,4971,4970,4973,4970,4972,4971,4973,4970,4971,4972,4972,4970,4973,4971,4981,4980,4976,4977,4975,4979,4978,4974,4981,4976,4980,4979,4977,4978,4974,4975,4980,4981,4979,4977,4978,4975,4974,4976,4981,4976,4975,4980,4979,4974,4978,4977,4981,4980,4976,4979,4975,4974,4978,4977,4981,4980,4976,4975,4978,4974,4979,4977,4981,4976,4979,4975,4978,4974,4980,4977,4980,4976,4979,4978,4975,4974,4977,4981,4984,4985,4983,4982,4985,4982,4984,4983,4985,4982,4983,4984,4984,4982,4983,4985,4987,4988,4990,4989,4986,4986,4987,4990,4989,4988,4987,4990,4986,4989,4988,4990,4987,4988,4986,4989,4989,4987,4988,4986,4990,4993,4994,4992,4991,4994,4993,4991,4992,4994,4991,4993,4992,4993,4991,4994,4992,5000,4996,4997,4999,4998,4995,4999,5000,4998,4997,4995,4996,5000,4996,4999,4995,4998,4997,5000,4999,4996,4995,4998,4997,5000,4996,4998,4995,4997,4999,4999,4998,4996,4995,4997,5000,5016,5017,5019,5018,5015,5015,5016,5019,5018,5017,5016,5019,5015,5018,5017,5019,5016,5017,5015,5018,5018,5016,5017,5015,5019,5021,5022,5024,5023,5020,5020,5021,5024,5023,5022,5021,5024,5020,5023,5022,5024,5021,5022,5020,5023,5023,5021,5022,5020,5024,5028,5029,5032,5027,5031,5030,5026,5028,5029,5032,5031,5030,5026,5027,5027,5026,5032,5028,5031,5030,5029,5028,5032,5027,5031,5026,5030,5029,5032,5028,5031,5027,5029,5026,5030,5032,5028,5030,5027,5026,5029,5031,5031,5028,5030,5029,5027,5026,5032,5471,5473,5472,5473,5471,5472,5471,5472,5473,7022,7023,7025,7024,7021,7021,7022,7025,7024,7023,7022,7025,7021,7024,7023,7025,7022,7023,7021,7024,7024,7022,7023,7021,7025,7829,7830,7828,7827,7830,7829,7827,7828,7830,7827,7828,7829,7829,7827,7828,7830,7831,8077,8122,8272,8331,8338,8339,8340,8521,8522,8523,8524,8525,8526,8527,8530,8533,8534,8535,8536,8538,8539,8548,8549,8826,1276,8827,8828,8831,8832,8833,8834,8835,8837,8836,8837,8835,8836,8835,8837,8836,9138,9188,9184,9185,9187,9186,9183,9187,9188,9186,9185,9183,9184,9188,9184,9187,9183,9186,9185,9188,9187,9184,9183,9186,9185,9188,9184,9186,9183,9185,9187,9187,9186,9184,9183,9188,9185,9498,9519,9522,9497,9521,9520,9496,9498,9519,9522,9521,9520,9496,9497,9497,9496,9522,9498,9521,9520,9519,9501,9502,9505,9500,9504,9503,9499,9501,9502,9505,9504,9503,9499,9500,9500,9499,9505,9501,9504,9503,9502,9501,9505,9500,9504,9499,9503,9502,9505,9501,9504,9500,9502,9499,9503,9505,9501,9503,9500,9499,9502,9504,9504,9501,9503,9502,9500,9499,9505,9511,9507,9508,9510,9509,9506,9510,9511,9509,9508,9506,9507,9511,9507,9510,9506,9509,9508,9511,9510,9507,9506,9509,9508,9511,9507,9509,9506,9510,9508,9510,9507,9509,9506,9511,9508,9514,9515,9518,9513,9517,9516,9512,9514,9515,9518,9517,9516,9512,9513,9513,9512,9518,9514,9517,9516,9515,9514,9518,9513,9517,9512,9516,9515,9518,9514,9517,9513,9515,9512,9516,9518,9514,9513,9516,9512,9515,9517,9517,9514,9516,9515,9513,9512,9518,9498,9522,9497,9521,9496,9520,9519,9522,9498,9521,9497,9519,9496,9520,9522,9498,9520,9497,9496,9519,9521,9521,9498,9520,9519,9497,9496,9522,9537,9534,9538,9536,9535,9534,9538,9536,9535,9537,9538,9534,9537,9535,9536,9535,9538,9536,9534,9537,9536,9534,9535,9537,9538,9942,9941,9941,9942,9944,734,729,733,728,732,730,731,727,9950,9988,9984,9985,9987,9986,9983,9987,9988,9986,9985,9983,9984,9988,9984,9987,9983,9986,9985,9988,9987,9984,9983,9985,9986,9988,9984,9986,9983,9985,9987,9987,9986,9984,9983,9985,9988)
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` = 20 | 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` = '20'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.002 | 32 |
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 (9535,9535,9535,9535,9535,642,642,642,642,642,642,9188,9188,9188,9188,9188,9188,625,625,625,625,625,617,617,617,617,617,9511,9511,9511,9511,9511,9511,9942,9942,664,664,664,664,664,664,9515,9515,9515,9515,9515,9515,9515,659,659,659,659,659,9988,9988,9988,9988,9988,9988,4952,4952,4952,4952,4953,4953,4953,4953,4954,4954,4954,4954,4955,4955,4955,4955,4993,4993,4993,4993,4992,4992,4992,4992,4994,4994,4994,4994,4991,4991,4991,4991,4988,4988,4988,4988,4988,4987,4987,4987,4987,4987,4989,4989,4989,4989,4989,4990,4990,4990,4990,4990,4986,4986,4986,4986,4986,4999,4999,4999,4999,4999,4999,5000,5000,5000,5000,5000,5000,4995,4995,4995,4995,4995,4995,4997,4997,4997,4997,4997,4997,4996,4996,4996,4996,4996,4996,4998,4998,4998,4998,4998,4998,8331,721,721,721,721,721,721,721,720,720,720,720,720,720,720,726,726,726,726,726,726,726,722,722,722,722,722,722,722,724,724,724,724,724,724,724,725,725,725,725,725,725,725,723,723,723,723,723,723,723,5015,5015,5015,5015,5015,5019,5019,5019,5019,5019,5017,5017,5017,5017,5017,5018,5018,5018,5018,5018,5016,5016,5016,5016,5016,9538,9538,9538,9538,9538,9536,9536,9536,9536,9536,9534,9534,9534,9534,9534,9537,9537,9537,9537,9537,754,8539,4970,4970,4970,4970,4973,4973,4973,4973,4972,4972,4972,4972,4971,4971,4971,4971,15,8549,8548,1284,8833,8832,8834,8831,8530,1276,1276,8828,8827,8827,8826,8524,8527,8526,8525,8523,8522,8521,8533,1287,8836,8836,8836,8835,8835,8835,8535,8534,8536,8837,8837,8837,4974,4974,4974,4974,4974,4974,4974,4974,4976,4976,4976,4976,4976,4976,4976,4976,4979,4979,4979,4979,4979,4979,4979,4979,4980,4980,4980,4980,4980,4980,4980,4980,4977,4977,4977,4977,4977,4977,4977,4977,4975,4975,4975,4975,4975,4975,4975,4975,4978,4978,4978,4978,4978,4978,4978,4978,4981,4981,4981,4981,4981,4981,4981,4981,5026,5026,5026,5026,5026,5026,5026,5027,5027,5027,5027,5027,5027,5027,5029,5029,5029,5029,5029,5029,5029,5030,5030,5030,5030,5030,5030,5030,5031,5031,5031,5031,5031,5031,5031,5032,5032,5032,5032,5032,5032,5032,5028,5028,5028,5028,5028,5028,5028,769,8338,4985,4985,4985,4985,4984,4984,4984,4984,4983,4983,4983,4983,4982,4982,4982,4982,735,735,735,735,735,735,736,736,736,736,736,736,737,737,737,737,737,737,738,738,738,738,738,738,739,739,739,739,739,739,740,740,740,740,740,740,638,638,638,638,638,638,637,637,637,637,637,637,639,639,639,639,639,639,640,640,640,640,640,640,641,641,641,641,641,641,9496,9496,9496,9496,9496,9496,9496,9497,9497,9497,9497,9497,9497,9497,9498,9498,9498,9498,9498,9498,9498,9519,9519,9519,9519,9519,9519,9519,9520,9520,9520,9520,9520,9520,9520,9521,9521,9521,9521,9521,9521,9521,9522,9522,9522,9522,9522,9522,9522,3591,3591,3591,3590,3590,3590,3592,3592,3592,768,8538,9187,9187,9187,9187,9187,9187,9186,9186,9186,9186,9186,9186,9185,9185,9185,9185,9185,9185,9184,9184,9184,9184,9184,9184,9183,9183,9183,9183,9183,9183,7831,714,714,714,715,715,715,716,716,716,704,780,780,780,780,780,780,776,776,776,776,776,776,777,777,777,777,777,777,778,778,778,778,778,778,779,779,779,779,779,779,775,775,775,775,775,775,741,667,667,667,667,667,667,668,668,668,668,668,668,669,669,669,669,669,669,670,670,670,670,670,670,671,671,671,671,671,671,672,672,672,672,672,672,622,622,622,622,622,621,621,621,621,621,623,623,623,623,623,624,624,624,624,624,770,770,770,770,770,771,771,771,771,771,772,772,772,772,772,774,774,774,774,774,773,773,773,773,773,613,613,613,613,613,614,614,614,614,614,615,615,615,615,615,616,616,616,616,616,753,753,753,753,753,753,751,751,751,751,751,751,748,748,748,748,748,748,750,750,750,750,750,750,752,752,752,752,752,752,749,749,749,749,749,749,690,690,690,690,688,688,688,688,687,687,687,687,689,689,689,689,9506,9506,9506,9506,9506,9506,9507,9507,9507,9507,9507,9507,9508,9508,9508,9508,9508,9508,9509,9509,9509,9509,9509,9509,9510,9510,9510,9510,9510,9510,3589,5023,5023,5023,5023,5023,5021,5021,5021,5021,5021,5024,5024,5024,5024,5024,5022,5022,5022,5022,5022,5020,5020,5020,5020,5020,9941,9941,5471,5471,5471,5472,5472,5472,5473,5473,5473,8122,7827,7827,7827,7827,7828,7828,7828,7828,7829,7829,7829,7829,7830,7830,7830,7830,717,717,717,719,719,719,718,718,718,4919,4919,4919,4919,4919,4917,4917,4917,4917,4917,4918,4918,4918,4918,4918,4920,4920,4920,4920,4920,4921,4921,4921,4921,4921,631,631,631,631,631,631,635,635,635,635,635,635,632,632,632,632,632,632,633,633,633,633,633,633,634,634,634,634,634,634,636,636,636,636,636,636,645,645,645,645,645,648,648,648,648,648,649,649,649,649,649,646,646,646,646,646,647,647,647,647,647,661,661,661,661,661,661,662,662,662,662,662,662,663,663,663,663,663,663,665,665,665,665,665,665,666,666,666,666,666,666,9944,781,781,781,781,781,781,782,782,782,782,782,782,786,786,786,786,786,786,785,785,785,785,785,785,784,784,784,784,784,784,783,783,783,783,783,783,675,675,675,675,675,675,673,673,673,673,673,673,674,674,674,674,674,674,676,676,676,676,676,676,677,677,677,677,677,677,678,678,678,678,678,678,7022,7022,7022,7022,7022,7025,7025,7025,7025,7025,7021,7021,7021,7021,7021,7023,7023,7023,7023,7023,7024,7024,7024,7024,7024,707,707,707,707,707,707,708,708,708,708,708,708,709,709,709,709,709,709,710,710,710,710,710,710,706,706,706,706,706,706,705,705,705,705,705,705,767,8340,742,8339,9513,9513,9513,9513,9513,9513,9513,9514,9514,9514,9514,9514,9514,9514,9516,9516,9516,9516,9516,9516,9516,9517,9517,9517,9517,9517,9517,9517,9518,9518,9518,9518,9518,9518,9518,9512,9512,9512,9512,9512,9512,9512,730,730,730,730,730,730,730,730,730,729,729,729,729,729,729,729,729,729,733,733,733,733,733,733,733,733,733,727,727,727,727,727,727,727,727,727,734,734,734,734,734,734,734,734,734,732,732,732,732,732,732,732,732,732,731,731,731,731,731,731,731,731,731,728,728,728,728,728,728,728,728,728,9950,9950,9950,9950,9950,9950,9950,9950,9950,761,761,761,761,761,761,761,760,760,760,760,760,760,760,763,763,763,763,763,763,763,764,764,764,764,764,764,764,765,765,765,765,765,765,765,762,762,762,762,762,762,762,766,766,766,766,766,766,766,9503,9503,9503,9503,9503,9503,9503,9500,9500,9500,9500,9500,9500,9500,9499,9499,9499,9499,9499,9499,9499,9501,9501,9501,9501,9501,9501,9501,9502,9502,9502,9502,9502,9502,9502,9504,9504,9504,9504,9504,9504,9504,9505,9505,9505,9505,9505,9505,9505,743,743,743,743,745,745,745,745,744,744,744,744,746,746,746,746,8077,692,692,692,692,692,692,693,693,693,693,693,693,695,695,695,695,695,695,696,696,696,696,696,696,697,697,697,697,697,697,694,694,694,694,694,694,9138,8272,658,658,658,658,658,656,656,656,656,656,657,657,657,657,657,660,660,660,660,660,4888,4888,4888,4888,4888,4888,4891,4891,4891,4891,4891,4891,4889,4889,4889,4889,4889,4889,4890,4890,4890,4890,4890,4890,4892,4892,4892,4892,4892,4892,4893,4893,4893,4893,4893,4893,699,699,699,699,699,699,702,702,702,702,702,702,703,703,703,703,703,703,700,700,700,700,700,700,701,701,701,701,701,701,698,698,698,698,698,698,9983,9983,9983,9983,9983,9983,9984,9984,9984,9984,9984,9984,9985,9985,9985,9985,9985,9985,9986,9986,9986,9986,9986,9986,9987,9987,9987,9987,9987,9987,680,680,680,680,680,680,681,681,681,681,681,681,684,684,684,684,684,684,682,682,682,682,682,682,683,683,683,683,683,683,679,679,679,679,679,679) | 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 (9535,9535,9535,9535,9535,642,642,642,642,642,642,9188,9188,9188,9188,9188,9188,625,625,625,625,625,617,617,617,617,617,9511,9511,9511,9511,9511,9511,9942,9942,664,664,664,664,664,664,9515,9515,9515,9515,9515,9515,9515,659,659,659,659,659,9988,9988,9988,9988,9988,9988,4952,4952,4952,4952,4953,4953,4953,4953,4954,4954,4954,4954,4955,4955,4955,4955,4993,4993,4993,4993,4992,4992,4992,4992,4994,4994,4994,4994,4991,4991,4991,4991,4988,4988,4988,4988,4988,4987,4987,4987,4987,4987,4989,4989,4989,4989,4989,4990,4990,4990,4990,4990,4986,4986,4986,4986,4986,4999,4999,4999,4999,4999,4999,5000,5000,5000,5000,5000,5000,4995,4995,4995,4995,4995,4995,4997,4997,4997,4997,4997,4997,4996,4996,4996,4996,4996,4996,4998,4998,4998,4998,4998,4998,8331,721,721,721,721,721,721,721,720,720,720,720,720,720,720,726,726,726,726,726,726,726,722,722,722,722,722,722,722,724,724,724,724,724,724,724,725,725,725,725,725,725,725,723,723,723,723,723,723,723,5015,5015,5015,5015,5015,5019,5019,5019,5019,5019,5017,5017,5017,5017,5017,5018,5018,5018,5018,5018,5016,5016,5016,5016,5016,9538,9538,9538,9538,9538,9536,9536,9536,9536,9536,9534,9534,9534,9534,9534,9537,9537,9537,9537,9537,754,8539,4970,4970,4970,4970,4973,4973,4973,4973,4972,4972,4972,4972,4971,4971,4971,4971,15,8549,8548,1284,8833,8832,8834,8831,8530,1276,1276,8828,8827,8827,8826,8524,8527,8526,8525,8523,8522,8521,8533,1287,8836,8836,8836,8835,8835,8835,8535,8534,8536,8837,8837,8837,4974,4974,4974,4974,4974,4974,4974,4974,4976,4976,4976,4976,4976,4976,4976,4976,4979,4979,4979,4979,4979,4979,4979,4979,4980,4980,4980,4980,4980,4980,4980,4980,4977,4977,4977,4977,4977,4977,4977,4977,4975,4975,4975,4975,4975,4975,4975,4975,4978,4978,4978,4978,4978,4978,4978,4978,4981,4981,4981,4981,4981,4981,4981,4981,5026,5026,5026,5026,5026,5026,5026,5027,5027,5027,5027,5027,5027,5027,5029,5029,5029,5029,5029,5029,5029,5030,5030,5030,5030,5030,5030,5030,5031,5031,5031,5031,5031,5031,5031,5032,5032,5032,5032,5032,5032,5032,5028,5028,5028,5028,5028,5028,5028,769,8338,4985,4985,4985,4985,4984,4984,4984,4984,4983,4983,4983,4983,4982,4982,4982,4982,735,735,735,735,735,735,736,736,736,736,736,736,737,737,737,737,737,737,738,738,738,738,738,738,739,739,739,739,739,739,740,740,740,740,740,740,638,638,638,638,638,638,637,637,637,637,637,637,639,639,639,639,639,639,640,640,640,640,640,640,641,641,641,641,641,641,9496,9496,9496,9496,9496,9496,9496,9497,9497,9497,9497,9497,9497,9497,9498,9498,9498,9498,9498,9498,9498,9519,9519,9519,9519,9519,9519,9519,9520,9520,9520,9520,9520,9520,9520,9521,9521,9521,9521,9521,9521,9521,9522,9522,9522,9522,9522,9522,9522,3591,3591,3591,3590,3590,3590,3592,3592,3592,768,8538,9187,9187,9187,9187,9187,9187,9186,9186,9186,9186,9186,9186,9185,9185,9185,9185,9185,9185,9184,9184,9184,9184,9184,9184,9183,9183,9183,9183,9183,9183,7831,714,714,714,715,715,715,716,716,716,704,780,780,780,780,780,780,776,776,776,776,776,776,777,777,777,777,777,777,778,778,778,778,778,778,779,779,779,779,779,779,775,775,775,775,775,775,741,667,667,667,667,667,667,668,668,668,668,668,668,669,669,669,669,669,669,670,670,670,670,670,670,671,671,671,671,671,671,672,672,672,672,672,672,622,622,622,622,622,621,621,621,621,621,623,623,623,623,623,624,624,624,624,624,770,770,770,770,770,771,771,771,771,771,772,772,772,772,772,774,774,774,774,774,773,773,773,773,773,613,613,613,613,613,614,614,614,614,614,615,615,615,615,615,616,616,616,616,616,753,753,753,753,753,753,751,751,751,751,751,751,748,748,748,748,748,748,750,750,750,750,750,750,752,752,752,752,752,752,749,749,749,749,749,749,690,690,690,690,688,688,688,688,687,687,687,687,689,689,689,689,9506,9506,9506,9506,9506,9506,9507,9507,9507,9507,9507,9507,9508,9508,9508,9508,9508,9508,9509,9509,9509,9509,9509,9509,9510,9510,9510,9510,9510,9510,3589,5023,5023,5023,5023,5023,5021,5021,5021,5021,5021,5024,5024,5024,5024,5024,5022,5022,5022,5022,5022,5020,5020,5020,5020,5020,9941,9941,5471,5471,5471,5472,5472,5472,5473,5473,5473,8122,7827,7827,7827,7827,7828,7828,7828,7828,7829,7829,7829,7829,7830,7830,7830,7830,717,717,717,719,719,719,718,718,718,4919,4919,4919,4919,4919,4917,4917,4917,4917,4917,4918,4918,4918,4918,4918,4920,4920,4920,4920,4920,4921,4921,4921,4921,4921,631,631,631,631,631,631,635,635,635,635,635,635,632,632,632,632,632,632,633,633,633,633,633,633,634,634,634,634,634,634,636,636,636,636,636,636,645,645,645,645,645,648,648,648,648,648,649,649,649,649,649,646,646,646,646,646,647,647,647,647,647,661,661,661,661,661,661,662,662,662,662,662,662,663,663,663,663,663,663,665,665,665,665,665,665,666,666,666,666,666,666,9944,781,781,781,781,781,781,782,782,782,782,782,782,786,786,786,786,786,786,785,785,785,785,785,785,784,784,784,784,784,784,783,783,783,783,783,783,675,675,675,675,675,675,673,673,673,673,673,673,674,674,674,674,674,674,676,676,676,676,676,676,677,677,677,677,677,677,678,678,678,678,678,678,7022,7022,7022,7022,7022,7025,7025,7025,7025,7025,7021,7021,7021,7021,7021,7023,7023,7023,7023,7023,7024,7024,7024,7024,7024,707,707,707,707,707,707,708,708,708,708,708,708,709,709,709,709,709,709,710,710,710,710,710,710,706,706,706,706,706,706,705,705,705,705,705,705,767,8340,742,8339,9513,9513,9513,9513,9513,9513,9513,9514,9514,9514,9514,9514,9514,9514,9516,9516,9516,9516,9516,9516,9516,9517,9517,9517,9517,9517,9517,9517,9518,9518,9518,9518,9518,9518,9518,9512,9512,9512,9512,9512,9512,9512,730,730,730,730,730,730,730,730,730,729,729,729,729,729,729,729,729,729,733,733,733,733,733,733,733,733,733,727,727,727,727,727,727,727,727,727,734,734,734,734,734,734,734,734,734,732,732,732,732,732,732,732,732,732,731,731,731,731,731,731,731,731,731,728,728,728,728,728,728,728,728,728,9950,9950,9950,9950,9950,9950,9950,9950,9950,761,761,761,761,761,761,761,760,760,760,760,760,760,760,763,763,763,763,763,763,763,764,764,764,764,764,764,764,765,765,765,765,765,765,765,762,762,762,762,762,762,762,766,766,766,766,766,766,766,9503,9503,9503,9503,9503,9503,9503,9500,9500,9500,9500,9500,9500,9500,9499,9499,9499,9499,9499,9499,9499,9501,9501,9501,9501,9501,9501,9501,9502,9502,9502,9502,9502,9502,9502,9504,9504,9504,9504,9504,9504,9504,9505,9505,9505,9505,9505,9505,9505,743,743,743,743,745,745,745,745,744,744,744,744,746,746,746,746,8077,692,692,692,692,692,692,693,693,693,693,693,693,695,695,695,695,695,695,696,696,696,696,696,696,697,697,697,697,697,697,694,694,694,694,694,694,9138,8272,658,658,658,658,658,656,656,656,656,656,657,657,657,657,657,660,660,660,660,660,4888,4888,4888,4888,4888,4888,4891,4891,4891,4891,4891,4891,4889,4889,4889,4889,4889,4889,4890,4890,4890,4890,4890,4890,4892,4892,4892,4892,4892,4892,4893,4893,4893,4893,4893,4893,699,699,699,699,699,699,702,702,702,702,702,702,703,703,703,703,703,703,700,700,700,700,700,700,701,701,701,701,701,701,698,698,698,698,698,698,9983,9983,9983,9983,9983,9983,9984,9984,9984,9984,9984,9984,9985,9985,9985,9985,9985,9985,9986,9986,9986,9986,9986,9986,9987,9987,9987,9987,9987,9987,680,680,680,680,680,680,681,681,681,681,681,681,684,684,684,684,684,684,682,682,682,682,682,682,683,683,683,683,683,683,679,679,679,679,679,679) | 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/butelki/20' | 0.000 | 1 |
UPDATE `missing_labels` SET `count` = 7 WHERE `label_key` = 'attribute.attrib_cat-11' AND `module` = 'attribute' AND `language` = 'pl_PL' AND `url` = '/kategoria/butelki/20' | 0.001 | 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` = '5015' | 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` = '5016'
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` = '4995' | 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` = '5000'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 6 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '741' | 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` = '741'
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` = '8338' | 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` = '8338'
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` = '781' | 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` = '786'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 6 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '760' | 0.000 | 7 |
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` = '762'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 7 |
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` = '4888' | 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` = '4893'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 6 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '7827' | 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` = '7830'
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` = '673' | 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` = '678'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 6 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '9944' | 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` = '9944'
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` = '743' | 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` = '746'
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` = '4986' | 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` = '4987'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 5 |
SELECT `name`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
SELECT `description`
FROM (`boxes_set`)
WHERE `id_boxes_set` = 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'page_name'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'footer_text'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'rodo_pdf_link'
LIMIT 0, 1 | 0.000 | 1 |
Total: 86 | 0.125 | 7095 |