Конструктор для хлопчиків Cobi ... Stem
Виробник: Cobi (Польша)
Виробник: Cobi (Польша)
Виробник: Cobi (Польша)
Виробник: Cobi (Польша)
Виробник: Stem (КНР)
SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/konstruktory_dlya_malchikov/o_7-developing-constructor_sets-cobi-moose-led-stem.html' LIMIT 0,1 [0.00059199333190918 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('o_7','developing','constructor_sets','cobi','moose','led','stem') order by url [0.0017640590667725 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('o_7','developing','constructor_sets','cobi','moose','led','stem') order by url [0.0012259483337402 sec]
select id,url from pod_cat_brand where BINARY url IN ('o_7','developing','constructor_sets','cobi','moose','led','stem') [0.0023238658905029 sec]
SELECT id, url FROM pod_filter WHERE url IN ('o_7','developing','constructor_sets','cobi','moose','led','stem') [0.0012059211730957 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('o_7','developing','constructor_sets','cobi','moose','led','stem') [0.00099706649780273 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
CREATE TEMPORARY TABLE tmp_base_goods (
id INT NOT NULL PRIMARY KEY,
brand_id INT,
price DECIMAL(10,2),
old_price DECIMAL(10,2),
ordr INT,
is_present TINYINT(1),
sub_icon_id INT,
fast_delivery TINYINT(1),
is_new TINYINT(1),
is_sale TINYINT(1),
KEY idx_brand (brand_id)
) ENGINE=MEMORY [0.00046896934509277 sec]
INSERT INTO tmp_base_goods
(id, brand_id, price, old_price, ordr, is_present, sub_icon_id, fast_delivery, is_new, is_sale)
SELECT g.id, g.brand_id, g.price, g.old_price, g.ordr, g.is_present,
g.sub_icon_id, g.fast_delivery, g.is_new, g.is_sale
FROM pod_cat_good g
WHERE g.cat_id IN (446) AND g.entry=0 AND g.is_active AND g.is_present_all_mods
UNION
SELECT g.id, g.brand_id, g.price, g.old_price, g.ordr, g.is_present,
g.sub_icon_id, g.fast_delivery, g.is_new, g.is_sale
FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
WHERE dc.dop_cat_id IN (446) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.39659094810486 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods;
CREATE TEMPORARY TABLE tmp_sub_goods (
id INT NOT NULL PRIMARY KEY,
entry INT NOT NULL,
price DECIMAL(10,2),
old_price DECIMAL(10,2),
sub_icon_id INT,
is_present TINYINT(1),
fast_delivery TINYINT(1),
is_new TINYINT(1),
is_sale TINYINT(1),
KEY idx_entry (entry)
) ENGINE=MEMORY [0.00050497055053711 sec]
INSERT INTO tmp_sub_goods
(id, entry, price, old_price, sub_icon_id, is_present, fast_delivery, is_new, is_sale)
SELECT go.id, go.entry, go.price, go.old_price, go.sub_icon_id, go.is_present,
go.fast_delivery, go.is_new, go.is_sale
FROM pod_cat_good go
INNER JOIN tmp_base_goods t ON go.entry = t.id
WHERE go.is_active AND go.is_present [0.0010020732879639 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00039482116699219 sec]
DEVELOPMENT🌷ЗНИЖКИ ДО 70%
ПЕРЕЙТИ
Виробник: Cobi (Польша)
Виробник: Cobi (Польша)
Виробник: Cobi (Польша)
Виробник: Cobi (Польша)
Виробник: Stem (КНР)