OM
select count(1)
FROM products
WHERE ( `status` = ?
AND date_available <= ? )
AND type <> ?
AND products.id IN (SELECT product_id
FROM product_to_categories
WHERE category_id = ?)
Size: a a a
OM
select count(1)
FROM products
WHERE ( `status` = ?
AND date_available <= ? )
AND type <> ?
AND products.id IN (SELECT product_id
FROM product_to_categories
WHERE category_id = ?)
S
select count(1)
FROM products
WHERE ( `status` = ?
AND date_available <= ? )
AND type <> ?
AND products.id IN (SELECT product_id
FROM product_to_categories
WHERE category_id = ?)
IZ
IF(products.type = 2, product_id IN (SELECT id FROM products WHERE main_id = products.id), product_id = products.id)
S
IF(products.type = 2, product_id IN (SELECT id FROM products WHERE main_id = products.id), product_id = products.id)
IZ
IF(products.type = 2, product_id IN (SELECT id FROM products WHERE main_id = products.id), product_id = products.id)
VS
IZ
IF(products.type = 2, product_id IN (SELECT id FROM products WHERE main_id = products.id), product_id = products.id)
VS
IZ
IZ
IZ
OM
id
, IF(currency_code = 'UAH', (vendor_price / 1), IF(currency_code = 'USD', (vendor_price / 0.037), vendor_price)) as vendor_price, (select IF(currency_code = 'UAH', (price / 1), IF(currency_code = 'USD', (price / 0.037), price)) as price from product_specials
where (`user_group_id` = ? and date_start
< ?) and (`date_end` > ? or date_end
is null) and IF(products.type = 2, product_id IN (SELECT id FROM products WHERE main_id = products.id), product_id = products.id)) as special
, (select IF(currency_code = 'UAH', (price / 1), IF(currency_code = 'USD', (price / 0.037), price)) as price from product_discounts
where (`user_group_id` = ? and date_start
< ? and quantity
= ?) and (`date_end` > ? or date_end
is null) and IF(products.type = 2, product_id IN (SELECT id FROM products WHERE main_id = products.id), product_id = products.id)) as discount
from products
where (`status` = ? and date_available
<= ?) and type
<> ? and products
.id
in (select product_id
from product_to_categories
where category_id
= ?)OM
VS
IZ
IZ
VS
IZ
IZ
VS