Carlton (Великобританія)
SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/brand/1220.html' LIMIT 0,1 [0.00082612037658691 sec]
select id from pod_structure where link='brand/1220' and active='1' AND lang_ua='1' [0.00047898292541504 sec]
SELECT
b.id,
b.name_ua AS name,
b.descr_ua AS descr,
c.name_ua AS country,
b.image_small, b.url
FROM pod_cat_brand b
INNER JOIN pod_country c ON b.country_id = c.id
WHERE b.id = '1220' OR b.url = '1220' AND b.is_active='1' [0.00075721740722656 sec]
SELECT DISTINCT
c.id,
c.name_ua AS name,
c.descr_ua AS descr,
c.url
FROM pod_cat_good g
LEFT JOIN pod_cat_category c ON c.id=g.cat_id
WHERE g.is_active='1' AND g.brand_id='1220' AND c.is_active='1' AND c.entry<>'0'
ORDER BY name [0.015053033828735 sec]
SELECT COUNT(*) as total FROM pod_cat_good
WHERE is_active='1' AND is_present_all_mods=1 AND entry='0' AND brand_id='1220' [0.0021119117736816 sec]
SELECT g.video, g.threedvideo, g.is_xit, g.is_action, g.is_sale,
g.sub_is_action, g.is_new, g.is_pay_for_video, g.id, g.cat_id,
g.name_ua AS name, g.name2_ua AS name2, g.descr, g.size_table, g.artikul, g.image_small,
g.image_big, g.price, g.old_price, g.is_present,
g.is_present_all_mods, g.sub_icon_id, g.url, g.ordr, g.last_items, g.fast_delivery, g.free_delivery, g.gift,
g.timer, g.action_validity,
b.name_ua AS brand_name, b.url as burl, b.id as bid, b.country AS brand_country, c.url as curl, c.name_ua AS cat_name,
si.name_ua AS sub_icon_name, si.icon AS sub_icon,
g.star, g.comment_id,
g.price as min_sort_price, g.price as max_sort_price
FROM pod_cat_good g
INNER JOIN pod_cat_category c ON c.id=g.cat_id
LEFT JOIN pod_cat_brand b ON b.id=g.brand_id
LEFT JOIN pod_sub_icon si ON si.id=g.sub_icon_id
WHERE g.is_active='1' AND g.is_present_all_mods=1 AND g.entry='0' AND g.brand_id='1220'
ORDER BY g.ordr DESC
LIMIT 0, 32 [0.0011711120605469 sec]
DEVELOPMENT🌷ЗНИЖКИ ДО 70%
ПЕРЕЙТИ