Queries | Time | Rows |
SELECT `pages`.*, `news_categories`.`news_category_name`
FROM (`pages`)
LEFT JOIN `news` ON (`pages`.`id_page` = `news`.`page_id`)
LEFT JOIN `news_to_categories` ON (`news_to_categories`.`news_id` = `news`.`id_news`)
LEFT JOIN `news_categories` ON (`news_to_categories`.`news_category_id` = `news_categories`.`id_news_category`)
WHERE `available` = 'Y'
ORDER BY `homepage` DESC | 0.001 | 75 |
SELECT *
FROM (`languages`) | 0.000 | 2 |
SELECT *
FROM (`languages`) | 0.000 | 2 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_base_api_url'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_auth_api_url'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_id'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_client_secret'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_token'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'apilo_developer_id'
LIMIT 0, 1 | 0.000 | 1 |
SELECT `parameter_value` FROM `shop_parameters_values` | 0.000 | 542 |
SELECT `attribute_value` FROM `shop_attributes_values_description` | 0.000 | 221 |
SELECT *
FROM (`boxes`)
WHERE `boxes_set_id` = 1
AND `active` = 1
ORDER BY `position` DESC | 0.000 | 6 |
SELECT *
FROM (`shop_currencies`)
ORDER BY `id_currency` ASC | 0.000 | 1 |
SELECT *
FROM (`configuration`)
WHERE `key` = 'google_tracking_code'
LIMIT 0, 1 | 0.000 | 1 |
SELECT *
FROM (`calendar`)
LEFT JOIN `calendar_info` ON (`calendar_info`.`calendar_day_id` = `calendar`.`id_calendar_day`)
WHERE `calendar_lang` = 'pl_PL'
AND `calendar_date` >= '2025-06-15'
ORDER BY `calendar_date` ASC
LIMIT 0, 3 | 0.000 | 0 |
SELECT *
FROM (`configuration`) | 0.000 | 65 |
SELECT *
FROM (`configuration`) | 0.000 | 65 |
SELECT *
FROM (`shop_categories` AS `c`)
INNER JOIN `shop_categories_description` AS `cd` ON (`cd`.`category_id` = `c`.`id_category`)
WHERE `c`.`active` = 'Y'
ORDER BY `c`.`position` DESC, `cd`.`category_name` ASC | 0.001 | 113 |
SELECT *
FROM (`shop_producers`)
ORDER BY `producer_name` ASC | 0.000 | 14 |
SELECT *
FROM (`shop_parameters` AS `p`)
INNER JOIN `shop_parameters_description` AS `pd` ON (`pd`.`parameter_id` = `p`.`id_parameter`)
WHERE `p`.`active` = 'Y' | 0.000 | 1 |
SELECT `shop_parameters`.*, `shop_product_parameters`.*, `shop_parameters_values`.*
FROM (`shop_parameters`)
LEFT JOIN `shop_product_parameters` ON (`shop_product_parameters`.`parameter_id` = `shop_parameters`.`id_parameter`)
LEFT JOIN `shop_products_parameters` ON (`shop_products_parameters`.`product_id` = `shop_product_parameters`.`product_id`)
LEFT JOIN `shop_parameters_values` ON (`shop_parameters_values`.`id_parameter_value` = `shop_products_parameters`.`parameter_value_id`)
ORDER BY `shop_parameters_values`.`id_parameter_value` ASC | 0.004 | 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` = '21' | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '5' | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = '4' | 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` = 21 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `category_id` IN (5,4)
ORDER BY `level` ASC | 0.000 | 2 |
SELECT *
FROM (`shop_categories`)
JOIN `shop_categories_description` ON (`category_id` = `id_category`)
WHERE `id_category` = '21'
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 (21) ) as s ORDER BY mainproduct DESC, product_name ASC ) as s | 0.106 | 1278 |
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 (10045,10045,10045,10045,10045,10045,10064,10064,10064,10064,10064,10063,10063,10063,10063,10063,10056,10056,10056,10056,10044,10044,10044,10044,10044,10044,10046,10046,10046,10046,10046,10046,10047,10047,10047,10047,10047,10047,10048,10048,10048,10048,10048,10048,10049,10049,10049,10049,10049,10049,3848,3848,3847,3847,3755,3755,3755,3755,3755,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3766,3766,3766,3766,3766,3766,3766,3766,3766,3766,10041,10041,10041,10041,10041,10041,10041,10041,10041,10041,3764,3764,3764,3764,3764,3764,3764,3764,3764,3764,3763,3763,3763,3763,3763,3763,3763,3763,3763,3763,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3765,3765,3765,3765,3765,3765,3765,3765,3765,3765,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,10042,10042,10042,10042,10042,10042,10042,10042,10042,10042,10043,10043,10043,10043,10043,10043,10043,10043,10043,10043,3896,3896,3896,3896,3896,3896,3896,3896,3899,3899,3899,3899,3899,3899,3899,3899,3900,3900,3900,3900,3900,3900,3900,3900,3897,3897,3897,3897,3897,3897,3897,3897,3898,3898,3898,3898,3898,3898,3898,3898,3903,3903,3903,3903,3903,3903,3903,3903,3901,3901,3901,3901,3901,3901,3901,3901,3902,3902,3902,3902,3902,3902,3902,3902,3864,3864,3864,3864,3864,3864,3864,3863,3863,3863,3863,3863,3863,3863,3869,3869,3869,3869,3869,3869,3869,3865,3865,3865,3865,3865,3865,3865,3866,3866,3866,3866,3866,3866,3866,3868,3868,3868,3868,3868,3868,3868,3867,3867,3867,3867,3867,3867,3867,10065,10065,10065,10065,10065,10066,10066,10066,10066,10066,10067,10067,10067,10067,10067,10068,10068,10068,10068,10068,10052,10052,10052,10052,10052,10050,10050,10050,10050,10050,10051,10051,10051,10051,10051,10053,10053,10053,10053,10053,3811,3811,3811,3811,3811,3811,3811,3811,3814,3814,3814,3814,3814,3814,3814,3814,3813,3813,3813,3813,3813,3813,3813,3813,3816,3816,3816,3816,3816,3816,3816,3816,3818,3818,3818,3818,3818,3818,3818,3818,3815,3815,3815,3815,3815,3815,3815,3815,3817,3817,3817,3817,3817,3817,3817,3817,3812,3812,3812,3812,3812,3812,3812,3812,3791,3791,3791,3791,3792,3792,3792,3792,3793,3793,3793,3793,3794,3794,3794,3794,3756,3756,3756,3756,3756,3756,3756,3757,3757,3757,3757,3757,3757,3757,3762,3762,3762,3762,3762,3762,3762,3760,3760,3760,3760,3760,3760,3760,3758,3758,3758,3758,3758,3758,3758,3761,3761,3761,3761,3761,3761,3761,3759,3759,3759,3759,3759,3759,3759,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,5099,3825,3825,3826,3826,3828,3828,3828,3828,3828,3831,3831,3831,3831,3831,3829,3829,3829,3829,3829,3832,3832,3832,3832,3832,3830,3830,3830,3830,3830,10054,10054,10054,10054,10057,10057,10057,10057,10055,10055,10055,10055,3820,3820,3820,3820,3820,3820,8710,8710,8710,8710,8710,8710,3821,3821,3821,3821,3821,3821,3822,3822,3822,3822,3822,3822,3823,3823,3823,3823,3823,3823,3824,3824,3824,3824,3824,3824,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,3918,3918,3918,3918,3918,3920,3920,3920,3920,3920,3916,3916,3916,3916,3916,3917,3917,3917,3917,3917,3919,3919,3919,3919,3919,3892,3892,3892,3892,3894,3894,3894,3894,3893,3893,3893,3893,3895,3895,3895,3895,8711,3849,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3226,3226,3226,3226,3226,3229,3229,3229,3229,3229,3227,3227,3227,3227,3227,3225,3225,3225,3225,3225,3228,3228,3228,3228,3228,10033,10033,10033,10033,10033,10034,10034,10034,10034,10034,10031,10031,10031,10031,10031,10032,10032,10032,10032,10032,10035,10035,10035,10035,10035) ) as s GROUP BY id_product_ps ) as ss | 0.009 | 26 |
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 (10045,10045,10045,10045,10045,10045,10064,10064,10064,10064,10064,10063,10063,10063,10063,10063,10056,10056,10056,10056,10044,10044,10044,10044,10044,10044,10046,10046,10046,10046,10046,10046,10047,10047,10047,10047,10047,10047,10048,10048,10048,10048,10048,10048,10049,10049,10049,10049,10049,10049,3848,3848,3847,3847,3755,3755,3755,3755,3755,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3766,3766,3766,3766,3766,3766,3766,3766,3766,3766,10041,10041,10041,10041,10041,10041,10041,10041,10041,10041,3764,3764,3764,3764,3764,3764,3764,3764,3764,3764,3763,3763,3763,3763,3763,3763,3763,3763,3763,3763,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3765,3765,3765,3765,3765,3765,3765,3765,3765,3765,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,10042,10042,10042,10042,10042,10042,10042,10042,10042,10042,10043,10043,10043,10043,10043,10043,10043,10043,10043,10043,3896,3896,3896,3896,3896,3896,3896,3896,3899,3899,3899,3899,3899,3899,3899,3899,3900,3900,3900,3900,3900,3900,3900,3900,3897,3897,3897,3897,3897,3897,3897,3897,3898,3898,3898,3898,3898,3898,3898,3898,3903,3903,3903,3903,3903,3903,3903,3903,3901,3901,3901,3901,3901,3901,3901,3901,3902,3902,3902,3902,3902,3902,3902,3902,3864,3864,3864,3864,3864,3864,3864,3863,3863,3863,3863,3863,3863,3863,3869,3869,3869,3869,3869,3869,3869,3865,3865,3865,3865,3865,3865,3865,3866,3866,3866,3866,3866,3866,3866,3868,3868,3868,3868,3868,3868,3868,3867,3867,3867,3867,3867,3867,3867,10065,10065,10065,10065,10065,10066,10066,10066,10066,10066,10067,10067,10067,10067,10067,10068,10068,10068,10068,10068,10052,10052,10052,10052,10052,10050,10050,10050,10050,10050,10051,10051,10051,10051,10051,10053,10053,10053,10053,10053,3811,3811,3811,3811,3811,3811,3811,3811,3814,3814,3814,3814,3814,3814,3814,3814,3813,3813,3813,3813,3813,3813,3813,3813,3816,3816,3816,3816,3816,3816,3816,3816,3818,3818,3818,3818,3818,3818,3818,3818,3815,3815,3815,3815,3815,3815,3815,3815,3817,3817,3817,3817,3817,3817,3817,3817,3812,3812,3812,3812,3812,3812,3812,3812,3791,3791,3791,3791,3792,3792,3792,3792,3793,3793,3793,3793,3794,3794,3794,3794,3756,3756,3756,3756,3756,3756,3756,3757,3757,3757,3757,3757,3757,3757,3762,3762,3762,3762,3762,3762,3762,3760,3760,3760,3760,3760,3760,3760,3758,3758,3758,3758,3758,3758,3758,3761,3761,3761,3761,3761,3761,3761,3759,3759,3759,3759,3759,3759,3759,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,5099,3825,3825,3826,3826,3828,3828,3828,3828,3828,3831,3831,3831,3831,3831,3829,3829,3829,3829,3829,3832,3832,3832,3832,3832,3830,3830,3830,3830,3830,10054,10054,10054,10054,10057,10057,10057,10057,10055,10055,10055,10055,3820,3820,3820,3820,3820,3820,8710,8710,8710,8710,8710,8710,3821,3821,3821,3821,3821,3821,3822,3822,3822,3822,3822,3822,3823,3823,3823,3823,3823,3823,3824,3824,3824,3824,3824,3824,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,3918,3918,3918,3918,3918,3920,3920,3920,3920,3920,3916,3916,3916,3916,3916,3917,3917,3917,3917,3917,3919,3919,3919,3919,3919,3892,3892,3892,3892,3894,3894,3894,3894,3893,3893,3893,3893,3895,3895,3895,3895,8711,3849,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3226,3226,3226,3226,3226,3229,3229,3229,3229,3229,3227,3227,3227,3227,3227,3225,3225,3225,3225,3225,3228,3228,3228,3228,3228,10033,10033,10033,10033,10033,10034,10034,10034,10034,10034,10031,10031,10031,10031,10031,10032,10032,10032,10032,10032,10035,10035,10035,10035,10035) ) as s order by available_now DESC, mainproduct DESC, product_name ASC ) as ss GROUP BY id_product_ps order by available_now DESC LIMIT 12 ,12 | 0.012 | 12 |
SELECT *
FROM (`shop_related_products`)
WHERE `related_product_id` IN (10045,10045,10045,10045,10045,10045,10064,10064,10064,10064,10064,10063,10063,10063,10063,10063,10056,10056,10056,10056,10044,10044,10044,10044,10044,10044,10046,10046,10046,10046,10046,10046,10047,10047,10047,10047,10047,10047,10048,10048,10048,10048,10048,10048,10049,10049,10049,10049,10049,10049,3848,3848,3847,3847,3755,3755,3755,3755,3755,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3766,3766,3766,3766,3766,3766,3766,3766,3766,3766,10041,10041,10041,10041,10041,10041,10041,10041,10041,10041,3764,3764,3764,3764,3764,3764,3764,3764,3764,3764,3763,3763,3763,3763,3763,3763,3763,3763,3763,3763,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3765,3765,3765,3765,3765,3765,3765,3765,3765,3765,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,10042,10042,10042,10042,10042,10042,10042,10042,10042,10042,10043,10043,10043,10043,10043,10043,10043,10043,10043,10043,3896,3896,3896,3896,3896,3896,3896,3896,3899,3899,3899,3899,3899,3899,3899,3899,3900,3900,3900,3900,3900,3900,3900,3900,3897,3897,3897,3897,3897,3897,3897,3897,3898,3898,3898,3898,3898,3898,3898,3898,3903,3903,3903,3903,3903,3903,3903,3903,3901,3901,3901,3901,3901,3901,3901,3901,3902,3902,3902,3902,3902,3902,3902,3902,3864,3864,3864,3864,3864,3864,3864,3863,3863,3863,3863,3863,3863,3863,3869,3869,3869,3869,3869,3869,3869,3865,3865,3865,3865,3865,3865,3865,3866,3866,3866,3866,3866,3866,3866,3868,3868,3868,3868,3868,3868,3868,3867,3867,3867,3867,3867,3867,3867,10065,10065,10065,10065,10065,10066,10066,10066,10066,10066,10067,10067,10067,10067,10067,10068,10068,10068,10068,10068,10052,10052,10052,10052,10052,10050,10050,10050,10050,10050,10051,10051,10051,10051,10051,10053,10053,10053,10053,10053,3811,3811,3811,3811,3811,3811,3811,3811,3814,3814,3814,3814,3814,3814,3814,3814,3813,3813,3813,3813,3813,3813,3813,3813,3816,3816,3816,3816,3816,3816,3816,3816,3818,3818,3818,3818,3818,3818,3818,3818,3815,3815,3815,3815,3815,3815,3815,3815,3817,3817,3817,3817,3817,3817,3817,3817,3812,3812,3812,3812,3812,3812,3812,3812,3791,3791,3791,3791,3792,3792,3792,3792,3793,3793,3793,3793,3794,3794,3794,3794,3756,3756,3756,3756,3756,3756,3756,3757,3757,3757,3757,3757,3757,3757,3762,3762,3762,3762,3762,3762,3762,3760,3760,3760,3760,3760,3760,3760,3758,3758,3758,3758,3758,3758,3758,3761,3761,3761,3761,3761,3761,3761,3759,3759,3759,3759,3759,3759,3759,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,5099,3825,3825,3826,3826,3828,3828,3828,3828,3828,3831,3831,3831,3831,3831,3829,3829,3829,3829,3829,3832,3832,3832,3832,3832,3830,3830,3830,3830,3830,10054,10054,10054,10054,10057,10057,10057,10057,10055,10055,10055,10055,3820,3820,3820,3820,3820,3820,8710,8710,8710,8710,8710,8710,3821,3821,3821,3821,3821,3821,3822,3822,3822,3822,3822,3822,3823,3823,3823,3823,3823,3823,3824,3824,3824,3824,3824,3824,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,3918,3918,3918,3918,3918,3920,3920,3920,3920,3920,3916,3916,3916,3916,3916,3917,3917,3917,3917,3917,3919,3919,3919,3919,3919,3892,3892,3892,3892,3894,3894,3894,3894,3893,3893,3893,3893,3895,3895,3895,3895,8711,3849,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3226,3226,3226,3226,3226,3229,3229,3229,3229,3229,3227,3227,3227,3227,3227,3225,3225,3225,3225,3225,3228,3228,3228,3228,3228,10033,10033,10033,10033,10033,10034,10034,10034,10034,10034,10031,10031,10031,10031,10031,10032,10032,10032,10032,10032,10035,10035,10035,10035,10035) | 0.002 | 1278 |
SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (3226,3227,3229,3225,3228,3227,3228,3225,3229,3226,3225,3229,3227,3228,3226,3229,3225,3227,3228,3226,3228,3227,3225,3226,3229,3754,3753,3751,3752,3755,3758,3762,3761,3757,3759,3760,3756,3758,3759,3762,3761,3756,3760,3757,3759,3761,3757,3762,3760,3756,3758,3757,3762,3756,3761,3760,3759,3758,3762,3757,3761,3756,3759,3760,3758,3762,3757,3760,3759,3756,3761,3758,3761,3760,3757,3759,3756,3758,3762,10043,3766,10042,3765,10041,3764,3769,3767,3763,3768,10043,3766,10042,3767,10041,3765,3763,3769,3768,3764,10043,10042,3766,3767,10041,3764,3769,3763,3768,3765,10043,3767,10042,3765,10041,3764,3769,3763,3768,3766,10043,3766,10042,3765,10041,3764,3763,3769,3768,3767,3766,10043,10042,3765,10041,3769,3764,3763,3767,3768,3766,10043,3765,10042,10041,3764,3768,3763,3767,3769,3775,3783,3781,3780,3773,3774,3779,3772,3777,3778,3771,3770,3776,3775,3783,3774,3781,3773,3780,3772,3778,3779,3776,3777,3771,3770,3775,3783,3774,3780,3781,3773,3771,3779,3778,3770,3777,3772,3776,3775,3783,3780,3774,3781,3772,3779,3778,3771,3770,3777,3773,3776,3775,3776,3783,3781,3780,3779,3773,3771,3778,3772,3777,3774,3770,3781,3774,3773,3772,3783,3779,3778,3771,3770,3780,3775,3777,3776,3775,3774,3773,3772,3783,3770,3771,3781,3780,3779,3778,3776,3777,3783,3774,3781,3780,3779,3778,3773,3772,3771,3776,3770,3777,3775,3783,3774,3781,3780,3773,3779,3772,3771,3777,3770,3776,3778,3775,3783,3774,3781,3773,3780,3772,3771,3778,3777,3776,3770,3779,3775,3783,3774,3781,3773,3772,3779,3778,3771,3775,3777,3776,3770,3780,3783,3774,3773,3780,3779,3778,3772,3771,3777,3770,3776,3781,3775,3780,3774,3773,3781,3779,3775,3772,3771,3778,3777,3776,3770,3783,3794,3792,3791,3793,3794,3791,3793,3792,3794,3791,3792,3793,3793,3792,3791,3794,3818,3813,3817,3812,3816,3814,3811,3815,3818,3813,3817,3814,3816,3811,3815,3812,3818,3817,3812,3816,3814,3815,3811,3813,3813,3812,3818,3817,3811,3816,3815,3814,3818,3813,3817,3812,3816,3811,3814,3815,3813,3818,3817,3812,3815,3811,3814,3816,3813,3818,3816,3815,3812,3811,3814,3817,3817,3813,3816,3815,3812,3811,3814,3818,3824,3823,8710,3820,3821,3822,3820,3824,8710,3823,3821,3822,3820,3824,8710,3823,3821,3822,3820,3824,8710,3822,3821,3823,3823,3820,3822,8710,3821,3824,3826,3825,3825,3826,3829,3830,3832,3828,3831,3830,3832,3831,3828,3829,3828,3832,3830,3831,3829,3832,3830,3828,3829,3831,3831,3830,3828,3829,3832,10091,3840,10090,3839,9887,3838,3837,10094,3836,10088,3835,3846,3845,3833,3844,3841,3843,3842,10092,10093,3834,10091,3840,10090,3839,9887,3838,10094,3837,10088,3836,3846,3834,3845,3841,3833,3844,3843,10092,3842,3835,10093,10091,3840,10090,3839,3838,9887,10094,3837,10088,3841,3835,3846,3834,3845,3833,3844,3843,3842,10092,10093,3836,10091,3840,3839,10090,9887,3838,10094,3841,3836,10088,3835,3846,3834,3845,3833,3844,3843,3842,10092,10093,3837,3839,3838,3837,10092,10091,3836,10093,10090,9887,3835,10094,3834,10088,3833,3846,3845,3844,3843,3842,3840,3841,10091,3839,10090,3838,9887,10094,3837,10088,3846,3836,3835,3834,3845,3844,3833,3843,10092,3841,10093,3840,3842,10091,3839,10090,3838,9887,10094,3837,10088,3836,3846,3835,3834,3845,3833,3844,3842,10092,3841,10093,3843,3840,10091,3839,10090,3838,9887,10094,3837,10088,3836,3846,3835,3845,3834,3833,3843,3842,10092,3841,10093,3844,3840,10091,3839,10090,3838,9887,10094,3837,10088,3836,3845,3835,3844,3843,3834,3833,3842,3841,10092,10093,3846,3840,3847,3848,3847,3848,3849,3861,3854,3860,3859,3853,3852,3858,3851,3857,3856,9011,3855,3850,3861,3854,3860,3853,3852,3859,3855,3857,3858,3850,3856,3851,9011,3861,3854,3860,3859,3853,3851,3858,3850,3857,3856,9011,3852,3855,3861,3854,3855,3860,3859,3851,3852,3858,3857,3850,3856,3853,9011,3855,3861,3853,3860,3859,3851,3858,3852,3857,3856,3850,9011,3854,3853,3850,3852,3851,9011,3861,3860,3859,3858,3857,3856,3855,3854,3861,3860,3853,3859,3858,3851,3852,3857,3850,9011,3855,3856,3854,3861,3853,3860,3859,3852,3858,3851,3856,3850,3855,9011,3854,3857,3861,3860,3853,3859,3852,3851,3850,3856,3857,3855,9011,3858,3854,3861,3860,3853,3858,3852,3851,3856,3857,3850,9011,3855,3854,3859,3861,3859,3853,3852,3858,3851,3850,3857,3856,3855,9011,3854,3860,3865,3869,3868,3864,3866,3867,3863,3865,3866,3869,3863,3868,3867,3864,3866,3868,3864,3869,3867,3863,3865,3864,3869,3863,3868,3867,3866,3865,3869,3864,3868,3866,3863,3867,3865,3869,3864,3867,3866,3863,3865,3868,3868,3867,3864,3866,3863,3869,3865,3895,3893,3892,3894,3892,3895,3893,3894,3892,3895,3893,3894,3894,3892,3893,3895,3903,3898,3902,3897,3901,3899,3896,3900,3903,3898,3902,3899,3896,3901,3900,3897,3903,3902,3901,3897,3899,3900,3896,3898,3898,3897,3903,3902,3896,3901,3899,3900,3903,3898,3902,3897,3901,3896,3899,3900,3903,3898,3902,3897,3900,3896,3899,3901,3898,3903,3901,3900,3897,3896,3899,3902,3902,3898,3901,3900,3897,3899,3896,3903,3917,3918,3920,3919,3916,3918,3919,3916,3920,3917,3916,3920,3919,3918,3917,3920,3918,3916,3919,3917,3919,3918,3916,3917,3920,5099,3824,3820,3823,3822,3821,8710,8711,3861,3854,3860,3853,3859,3852,3858,3851,3857,3850,3856,3855,9011,10032,10033,10034,10031,10035,10033,10035,10031,10034,10032,10031,10034,10035,10033,10032,10033,10035,10031,10032,10034,10034,10031,10033,10032,10035,10043,10042,3766,3767,3765,3764,3769,10041,3768,3763,10043,10041,3767,3766,3765,3764,3769,3763,10042,3768,10042,10041,3766,3767,3765,3769,3764,10043,3763,3768,10049,10045,10048,10046,10047,10044,10049,10048,10044,10046,10047,10045,10045,10049,10044,10048,10046,10047,10049,10045,10048,10044,10046,10047,10049,10045,10047,10044,10046,10048,10048,10045,10047,10046,10044,10049,10051,10052,10063,10050,10053,10052,10053,10050,10063,10051,10050,10063,10052,10053,10051,10063,10050,10052,10051,10053,10057,10055,10054,10056,10057,10054,10055,10056,10054,10057,10055,10056,10056,10054,10055,10057,10053,10050,10052,10063,10051,10065,10066,10068,10067,10064,10066,10067,10064,10068,10065,10064,10068,10067,10066,10065,10068,10064,10066,10065,10067,10067,10064,10066,10068,10065,10091,3839,10090,3838,9887,3837,10094,3846,3836,3845,3835,3844,3834,3833,3843,3842,10092,3841,10093,10088,3840,10091,3839,9887,3838,10094,10088,3837,3846,3836,3845,3835,3844,3834,3833,3843,3842,3841,10092,10093,10090,3840,10090,3839,9887,3838,10094,10088,3837,3846,3836,3835,3845,3834,3844,3833,3843,10092,3842,3841,10093,10091,3840,10091,3840,10090,3839,9887,3838,10094,3837,10088,3836,3846,3835,3845,3834,3844,3833,3843,3842,10092,10093,3841,10091,3840,10090,3839,9887,3838,10094,3837,10088,3836,3846,3835,3845,3834,3844,3833,3843,3842,10092,10093,3841,10091,3839,10090,3838,9887,3837,10088,3836,3846,3845,3835,3834,3844,3833,3843,10092,3842,10093,3841,10094,3840,10085,3787,10086,3786,10084,3785,10083,3784,3790,3789,10121,10120,3788,10120,3788,10085,3787,10086,3786,10084,3785,10083,3784,3790,3789,10121) | 0.002 | 1503 |
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 (3226,3227,3229,3228,3225,3225,3226,3229,3228,3227,3226,3229,3225,3228,3227,3229,3226,3227,3225,3228,3228,3226,3227,3225,3229,3752,3753,3755,3754,3751,3751,3752,3755,3754,3753,3752,3755,3751,3754,3753,3755,3752,3753,3751,3754,3754,3752,3753,3751,3755,3758,3759,3762,3757,3761,3760,3756,3758,3759,3762,3761,3760,3756,3757,3757,3756,3762,3758,3761,3760,3759,3758,3762,3757,3761,3756,3760,3759,3762,3758,3761,3757,3759,3756,3760,3762,3758,3760,3757,3756,3759,3761,3761,3758,3760,3759,3757,3756,3762,3766,3767,10043,10042,3765,10041,3764,3769,3768,3763,3766,3767,10043,10042,3765,10041,3769,3768,3763,3764,10043,3766,3767,10042,10041,3769,3764,3768,3763,3765,3767,10043,3769,10042,3768,3765,10041,3764,3763,3766,3766,10043,10042,3765,10041,3764,3769,3763,3768,3767,3766,10043,3769,10042,3765,10041,3764,3763,3767,3768,10043,3766,10042,3765,10041,3768,3764,3763,3767,3769,3775,3776,3781,3783,3773,3780,3772,3779,3774,3778,3777,3771,3770,3775,3783,3774,3781,3780,3773,3772,3776,3779,3778,3777,3770,3771,3775,3783,3776,3781,3773,3780,3774,3779,3778,3771,3770,3777,3772,3775,3783,3781,3776,3780,3774,3779,3772,3778,3771,3770,3777,3773,3775,3776,3781,3783,3780,3773,3779,3772,3778,3771,3777,3774,3770,3776,3774,3773,3772,3783,3771,3770,3780,3775,3781,3779,3778,3777,3774,3783,3781,3780,3779,3771,3778,3773,3772,3777,3776,3770,3775,3783,3781,3780,3774,3773,3779,3778,3772,3770,3771,3776,3777,3775,3775,3783,3781,3774,3780,3773,3779,3772,3771,3777,3770,3776,3778,3775,3783,3774,3781,3780,3773,3772,3778,3777,3771,3770,3779,3776,3783,3781,3773,3774,3772,3779,3778,3775,3771,3777,3770,3776,3780,3775,3783,3774,3780,3779,3773,3772,3778,3771,3777,3770,3781,3776,3781,3780,3779,3774,3773,3775,3778,3772,3777,3771,3776,3770,3783,10120,10121,3790,3789,3788,3787,3786,3785,3784,10120,10121,3790,3789,3788,3787,3786,3784,3785,10120,10121,3790,3789,3788,3787,3785,3784,3786,10120,10121,3790,3789,3788,3786,3785,3784,3787,10121,10120,3790,3789,3787,3786,3785,3784,3788,10120,10121,3790,3788,3787,3786,3785,3784,3789,10120,10121,3789,3788,3787,3786,3785,3784,3790,3793,3794,3792,3791,3794,3793,3791,3792,3794,3791,3792,3793,3793,3791,3792,3794,3818,3817,3813,3814,3812,3816,3815,3811,3818,3813,3817,3816,3814,3815,3811,3812,3817,3818,3816,3814,3815,3812,3811,3813,3818,3813,3812,3817,3816,3811,3815,3814,3818,3817,3813,3816,3812,3811,3814,3815,3818,3817,3813,3812,3815,3811,3814,3816,3818,3813,3816,3812,3815,3811,3814,3817,3817,3813,3816,3815,3812,3811,3814,3818,3823,3824,3822,3821,8710,3820,3824,3820,3823,8710,3822,3821,3824,3823,3820,8710,3822,3821,3824,3820,3822,8710,3823,3821,3823,3820,3822,8710,3821,3824,3826,3825,3825,3826,3829,3830,3832,3831,3828,3828,3829,3832,3831,3830,3829,3832,3828,3831,3830,3832,3829,3830,3828,3831,3831,3829,3830,3828,3832,10091,10090,3837,10094,3836,10088,3846,3835,3834,3844,3841,3843,3842,10092,10093,10091,3840,10090,3837,3839,9887,3838,10094,10088,3836,3835,3846,3841,3845,3844,3833,3843,10092,3842,10093,3834,10091,10090,3840,3837,3839,9887,3838,10094,3836,10088,3846,3841,3844,3834,3845,3833,3843,10092,3842,10093,3835,10091,10090,3840,3837,3839,9887,3838,10094,3841,10088,3846,3835,3834,3845,3844,3833,3843,10092,3842,10093,3836,10091,10090,3840,3841,3839,9887,10088,10094,3838,3836,3846,3835,3834,3844,3845,3833,3843,3842,10092,10093,3837,10091,10090,3841,10088,10094,3837,3846,3836,3844,3835,3843,3834,3842,10092,10093,10091,10090,3841,10088,10094,3846,3837,3836,3835,3844,3843,3834,3842,10092,10093,3837,3836,3835,3834,10092,10093,3846,3844,3841,10088,3843,10091,3842,10090,10094,3840,3839,3838,3837,10091,10090,3836,9887,3835,10088,3846,10094,3834,3833,3845,3844,3843,3842,10092,10093,3841,10091,3840,10090,3839,3838,9887,10088,10094,3837,3846,3836,3835,3845,3844,3834,3833,3843,10092,10093,3841,3842,10091,3840,10090,3839,3838,9887,10094,10088,3837,3846,3836,3835,3834,3845,3844,3833,10092,3842,3841,10093,3843,10091,3840,10090,3839,3838,9887,10094,3837,10088,3846,3836,3835,3834,3845,3833,3843,3842,10092,3841,10093,3844,10091,10090,10094,10088,3837,3846,3836,3835,3834,3844,3843,10092,3842,3841,10093,10091,3840,10090,3839,3838,9887,10088,10094,3837,3836,3835,3845,3844,3843,3834,3833,3842,10092,3841,10093,3846,3848,3847,3847,3848,3849,3855,3861,3860,3852,3854,3853,3859,3858,3851,3857,9011,3856,3850,3854,3861,3853,3860,3852,3855,3859,3858,3857,3850,3856,9011,3851,3855,3861,3860,3854,3853,3859,3851,3857,3858,3850,9011,3856,3852,3855,3861,3854,3860,3859,3852,3858,3857,3851,3850,3856,9011,3853,3853,3861,3852,3851,3850,9011,3854,3860,3859,3858,3857,3856,3855,3854,3853,3851,3860,3861,3859,3858,3857,3852,3850,3856,3855,9011,3860,3854,3861,3859,3853,3852,3858,3857,3851,3850,9011,3855,3856,3861,3854,3853,3860,3859,3852,3851,3858,3850,3856,9011,3855,3857,3860,3854,3861,3859,3853,3852,3857,3850,3851,3856,9011,3855,3858,3854,3860,3861,3852,3853,3858,3857,3851,3850,9011,3856,3855,3859,3854,3861,3852,3859,3853,3858,3851,3850,3857,3856,9011,3855,3860,3853,3854,3857,3852,3860,3859,3851,3858,3850,9011,3856,3855,3861,3865,3866,3869,3864,3868,3867,3863,3865,3866,3869,3868,3867,3863,3864,3864,3863,3869,3865,3868,3867,3866,3865,3869,3864,3868,3863,3867,3866,3869,3865,3868,3864,3866,3863,3867,3869,3865,3867,3864,3863,3866,3868,3868,3865,3867,3866,3864,3863,3869,3894,3895,3893,3892,3895,3894,3892,3893,3895,3892,3894,3893,3894,3892,3895,3893,3903,3902,3898,3899,3897,3901,3900,3896,3903,3898,3902,3901,3899,3900,3896,3897,3902,3903,3901,3899,3900,3897,3896,3898,3903,3898,3902,3897,3901,3896,3900,3899,3903,3902,3898,3901,3897,3896,3900,3899,3903,3902,3898,3900,3897,3896,3901,3899,3903,3898,3901,3897,3900,3896,3899,3902,3902,3901,3898,3900,3897,3896,3903,3899,3917,3918,3920,3919,3916,3916,3917,3920,3919,3918,3917,3920,3916,3919,3918,3920,3917,3918,3916,3919,3919,3917,3918,3916,3920,5099,3824,3820,3823,3822,3821,8710,8711,3855,3861,3854,3860,3853,3859,3852,3858,3857,3851,3850,3856,9011,10091,10090,3837,10088,10094,3846,3836,3844,3835,3843,3834,3842,3841,10092,10093,9887,10032,10033,10034,10035,10031,10031,10032,10034,10035,10033,10032,10034,10031,10035,10033,10035,10032,10033,10031,10034,10032,10034,10033,10031,10035,10043,10042,3766,3767,3765,3764,3769,3768,10041,3763,10043,3766,3767,10041,3765,3764,3769,3763,3768,10042,10042,3767,3766,10041,3765,3769,3764,3768,3763,10043,10049,10045,10046,10048,10047,10044,10048,10049,10047,10046,10044,10045,10049,10045,10048,10044,10047,10046,10049,10048,10045,10044,10047,10046,10049,10045,10047,10044,10046,10048,10048,10047,10045,10044,10046,10049,10051,10052,10063,10053,10050,10050,10051,10063,10053,10052,10051,10063,10050,10053,10052,10063,10051,10052,10050,10053,10056,10057,10055,10054,10057,10054,10056,10055,10057,10054,10056,10055,10056,10054,10057,10055,10053,10051,10052,10050,10063,10065,10066,10068,10067,10064,10064,10065,10068,10067,10066,10065,10068,10064,10067,10066,10068,10065,10066,10064,10067,10067,10065,10066,10064,10068,10120,10121,10120,10121,3790,3789,3788,3787,3786,3785,3784,10084,10085,10086,10084,10120,10121,3790,3789,3788,3787,3786,3785,3784,10085,10086,10120,10121,10085,10084,3790,3789,3788,3787,3786,3785,3784,10086,10091,3840,10090,3839,3838,9887,10094,3837,3846,3836,3835,3845,3844,3834,3843,3833,3842,10092,3841,10093,10088,10091,3840,3839,9887,3838,10094,10088,3837,3846,3836,3835,3845,3844,3834,3843,3833,3842,10092,3841,10093,10090,10090,3840,3839,9887,3838,10094,3837,10088,3836,3846,3835,3845,3834,3844,3833,3843,10092,3842,3841,10093,10091,10091,3841,3840,3839,10090,3838,9887,10094,3837,10088,3836,3835,3846,3845,3844,3834,3843,3833,3842,10093,10092,10091,3841,3840,10090,3839,3838,9887,10094,3837,10088,3836,3835,3846,3845,3834,3844,3843,3833,10092,3842,10093,10091,3840,10090,3839,3838,9887,3837,10088,3836,3846,3835,3845,3844,3834,3843,3833,10092,3842,10093,3841,10094,3788,10085,3787,10086,3786,10084,3785,10083,3784,3790,10121,3789,10120,10120,3789,3788,10085,3787,10086,3786,10084,3785,10083,3784,3790,10121)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 5 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 21 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 5 | 0.000 | 1 |
SELECT *
FROM (`shop_categories`)
WHERE `id_category` = 4 | 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` = '21'
AND `spv`.`active` = 'Y'
GROUP BY `sp`.`id_attr_ps`
ORDER BY `spv`.`parameter_position` DESC | 0.002 | 34 |
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 (10045,10045,10045,10045,10045,10045,10064,10064,10064,10064,10064,10063,10063,10063,10063,10063,10056,10056,10056,10056,10044,10044,10044,10044,10044,10044,10046,10046,10046,10046,10046,10046,10047,10047,10047,10047,10047,10047,10048,10048,10048,10048,10048,10048,10049,10049,10049,10049,10049,10049,3848,3848,3847,3847,3755,3755,3755,3755,3755,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3766,3766,3766,3766,3766,3766,3766,3766,3766,3766,10041,10041,10041,10041,10041,10041,10041,10041,10041,10041,3764,3764,3764,3764,3764,3764,3764,3764,3764,3764,3763,3763,3763,3763,3763,3763,3763,3763,3763,3763,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3765,3765,3765,3765,3765,3765,3765,3765,3765,3765,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,10042,10042,10042,10042,10042,10042,10042,10042,10042,10042,10043,10043,10043,10043,10043,10043,10043,10043,10043,10043,3896,3896,3896,3896,3896,3896,3896,3896,3899,3899,3899,3899,3899,3899,3899,3899,3900,3900,3900,3900,3900,3900,3900,3900,3897,3897,3897,3897,3897,3897,3897,3897,3898,3898,3898,3898,3898,3898,3898,3898,3903,3903,3903,3903,3903,3903,3903,3903,3901,3901,3901,3901,3901,3901,3901,3901,3902,3902,3902,3902,3902,3902,3902,3902,3864,3864,3864,3864,3864,3864,3864,3863,3863,3863,3863,3863,3863,3863,3869,3869,3869,3869,3869,3869,3869,3865,3865,3865,3865,3865,3865,3865,3866,3866,3866,3866,3866,3866,3866,3868,3868,3868,3868,3868,3868,3868,3867,3867,3867,3867,3867,3867,3867,10065,10065,10065,10065,10065,10066,10066,10066,10066,10066,10067,10067,10067,10067,10067,10068,10068,10068,10068,10068,10052,10052,10052,10052,10052,10050,10050,10050,10050,10050,10051,10051,10051,10051,10051,10053,10053,10053,10053,10053,3811,3811,3811,3811,3811,3811,3811,3811,3814,3814,3814,3814,3814,3814,3814,3814,3813,3813,3813,3813,3813,3813,3813,3813,3816,3816,3816,3816,3816,3816,3816,3816,3818,3818,3818,3818,3818,3818,3818,3818,3815,3815,3815,3815,3815,3815,3815,3815,3817,3817,3817,3817,3817,3817,3817,3817,3812,3812,3812,3812,3812,3812,3812,3812,3791,3791,3791,3791,3792,3792,3792,3792,3793,3793,3793,3793,3794,3794,3794,3794,3756,3756,3756,3756,3756,3756,3756,3757,3757,3757,3757,3757,3757,3757,3762,3762,3762,3762,3762,3762,3762,3760,3760,3760,3760,3760,3760,3760,3758,3758,3758,3758,3758,3758,3758,3761,3761,3761,3761,3761,3761,3761,3759,3759,3759,3759,3759,3759,3759,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,5099,3825,3825,3826,3826,3828,3828,3828,3828,3828,3831,3831,3831,3831,3831,3829,3829,3829,3829,3829,3832,3832,3832,3832,3832,3830,3830,3830,3830,3830,10054,10054,10054,10054,10057,10057,10057,10057,10055,10055,10055,10055,3820,3820,3820,3820,3820,3820,8710,8710,8710,8710,8710,8710,3821,3821,3821,3821,3821,3821,3822,3822,3822,3822,3822,3822,3823,3823,3823,3823,3823,3823,3824,3824,3824,3824,3824,3824,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,3918,3918,3918,3918,3918,3920,3920,3920,3920,3920,3916,3916,3916,3916,3916,3917,3917,3917,3917,3917,3919,3919,3919,3919,3919,3892,3892,3892,3892,3894,3894,3894,3894,3893,3893,3893,3893,3895,3895,3895,3895,8711,3849,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3226,3226,3226,3226,3226,3229,3229,3229,3229,3229,3227,3227,3227,3227,3227,3225,3225,3225,3225,3225,3228,3228,3228,3228,3228,10033,10033,10033,10033,10033,10034,10034,10034,10034,10034,10031,10031,10031,10031,10031,10032,10032,10032,10032,10032,10035,10035,10035,10035,10035) | 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 (10045,10045,10045,10045,10045,10045,10064,10064,10064,10064,10064,10063,10063,10063,10063,10063,10056,10056,10056,10056,10044,10044,10044,10044,10044,10044,10046,10046,10046,10046,10046,10046,10047,10047,10047,10047,10047,10047,10048,10048,10048,10048,10048,10048,10049,10049,10049,10049,10049,10049,3848,3848,3847,3847,3755,3755,3755,3755,3755,3769,3769,3769,3769,3769,3769,3769,3769,3769,3769,3766,3766,3766,3766,3766,3766,3766,3766,3766,3766,10041,10041,10041,10041,10041,10041,10041,10041,10041,10041,3764,3764,3764,3764,3764,3764,3764,3764,3764,3764,3763,3763,3763,3763,3763,3763,3763,3763,3763,3763,3768,3768,3768,3768,3768,3768,3768,3768,3768,3768,3765,3765,3765,3765,3765,3765,3765,3765,3765,3765,3767,3767,3767,3767,3767,3767,3767,3767,3767,3767,10042,10042,10042,10042,10042,10042,10042,10042,10042,10042,10043,10043,10043,10043,10043,10043,10043,10043,10043,10043,3896,3896,3896,3896,3896,3896,3896,3896,3899,3899,3899,3899,3899,3899,3899,3899,3900,3900,3900,3900,3900,3900,3900,3900,3897,3897,3897,3897,3897,3897,3897,3897,3898,3898,3898,3898,3898,3898,3898,3898,3903,3903,3903,3903,3903,3903,3903,3903,3901,3901,3901,3901,3901,3901,3901,3901,3902,3902,3902,3902,3902,3902,3902,3902,3864,3864,3864,3864,3864,3864,3864,3863,3863,3863,3863,3863,3863,3863,3869,3869,3869,3869,3869,3869,3869,3865,3865,3865,3865,3865,3865,3865,3866,3866,3866,3866,3866,3866,3866,3868,3868,3868,3868,3868,3868,3868,3867,3867,3867,3867,3867,3867,3867,10065,10065,10065,10065,10065,10066,10066,10066,10066,10066,10067,10067,10067,10067,10067,10068,10068,10068,10068,10068,10052,10052,10052,10052,10052,10050,10050,10050,10050,10050,10051,10051,10051,10051,10051,10053,10053,10053,10053,10053,3811,3811,3811,3811,3811,3811,3811,3811,3814,3814,3814,3814,3814,3814,3814,3814,3813,3813,3813,3813,3813,3813,3813,3813,3816,3816,3816,3816,3816,3816,3816,3816,3818,3818,3818,3818,3818,3818,3818,3818,3815,3815,3815,3815,3815,3815,3815,3815,3817,3817,3817,3817,3817,3817,3817,3817,3812,3812,3812,3812,3812,3812,3812,3812,3791,3791,3791,3791,3792,3792,3792,3792,3793,3793,3793,3793,3794,3794,3794,3794,3756,3756,3756,3756,3756,3756,3756,3757,3757,3757,3757,3757,3757,3757,3762,3762,3762,3762,3762,3762,3762,3760,3760,3760,3760,3760,3760,3760,3758,3758,3758,3758,3758,3758,3758,3761,3761,3761,3761,3761,3761,3761,3759,3759,3759,3759,3759,3759,3759,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,10088,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3841,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,3846,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,10094,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3835,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,3843,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,10090,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3834,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3842,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3836,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3844,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,3837,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10091,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10092,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,10093,5099,3825,3825,3826,3826,3828,3828,3828,3828,3828,3831,3831,3831,3831,3831,3829,3829,3829,3829,3829,3832,3832,3832,3832,3832,3830,3830,3830,3830,3830,10054,10054,10054,10054,10057,10057,10057,10057,10055,10055,10055,10055,3820,3820,3820,3820,3820,3820,8710,8710,8710,8710,8710,8710,3821,3821,3821,3821,3821,3821,3822,3822,3822,3822,3822,3822,3823,3823,3823,3823,3823,3823,3824,3824,3824,3824,3824,3824,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3775,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3778,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3780,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3779,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3774,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3772,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3783,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3773,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3771,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3776,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3777,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3770,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,3781,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10120,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,10121,3918,3918,3918,3918,3918,3920,3920,3920,3920,3920,3916,3916,3916,3916,3916,3917,3917,3917,3917,3917,3919,3919,3919,3919,3919,3892,3892,3892,3892,3894,3894,3894,3894,3893,3893,3893,3893,3895,3895,3895,3895,8711,3849,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3857,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3860,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3855,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3853,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3852,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3856,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3851,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3850,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3859,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,3858,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,9011,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3854,3226,3226,3226,3226,3226,3229,3229,3229,3229,3229,3227,3227,3227,3227,3227,3225,3225,3225,3225,3225,3228,3228,3228,3228,3228,10033,10033,10033,10033,10033,10034,10034,10034,10034,10034,10031,10031,10031,10031,10031,10032,10032,10032,10032,10032,10035,10035,10035,10035,10035) | 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` = '8711' | 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` = '8711'
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` = '3820' | 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` = '3824'
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` = '10064' | 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` = '10065'
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` = '3892' | 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` = '3895'
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` = '3225' | 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` = '3226'
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` = '3825' | 0.000 | 2 |
SELECT `sp`.`id_attr_ps`, `sp`.`id_product`, `spv`.`parameter_value`, `spv`.`parameter_value_name`, `spv`.`en_US_parameter_value_name`, `spv`.`parameter_img`, `spv`.`parameter_value2`, `spv`.`parameter_parent`, `spv`.`parameter_img`, `spd`.`parameter_name`, `spv`.`id_parameter_value`
FROM (`shop_products` AS `sp`)
LEFT JOIN `shop_parameters_values` AS `spv` ON (`spv`.`id_parameter_value` = `sp`.`id_attr_ps`)
LEFT JOIN `shop_related_products` AS `srp` ON (`srp`.`related_product_id` = `sp`.`id_product`)
LEFT JOIN `shop_parameters_description` AS `spd` ON (`spd`.`parameter_id` = `spv`.`parameter_id`)
INNER JOIN `shop_products_description` AS `spdesc` ON (`spdesc`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`product_id` = '3826'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 2 |
SELECT `srp`.`product_id`
FROM (`shop_related_products` AS `srp`)
INNER JOIN `shop_products_description` AS `spd` ON (`spd`.`product_id` = `srp`.`related_product_id`)
WHERE `srp`.`related_product_id` = '5099' | 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` = '5099'
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` = '10044' | 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` = '10049'
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` = '10050' | 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` = '10051'
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` = '10054' | 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` = '10057'
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` = '10031' | 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` = '10032'
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` = '3763' | 0.000 | 10 |
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` = '10043'
AND `spv`.`active` = 'Y'
AND `sp`.`active` = 'Y'
ORDER BY `spv`.`parameter_position` DESC | 0.000 | 10 |
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.150 | 6387 |