SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/kastryuli/stainless-lamart.html' LIMIT 0,1 [0.00050711631774902 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('stainless','lamart') order by url [0.001600980758667 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('stainless','lamart') order by url [0.001133918762207 sec]
select id,url from pod_cat_brand where BINARY url IN ('stainless','lamart') [0.0017869472503662 sec]
SELECT cb.metaindex, cb.metafollow
FROM pod_set_cat_brand cb
INNER JOIN pod_cat_category c ON cb.cat_id = c.id
WHERE c.url = 'kastryuli'
AND cb.brand_id = 1203
AND cb.is_active = 1
LIMIT 1 [0.00053501129150391 sec]
SELECT id, url FROM pod_filter WHERE url IN ('stainless','lamart') [0.00041794776916504 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('stainless','lamart') [0.00045108795166016 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
CREATE TEMPORARY TABLE tmp_base_goods (id INT NOT NULL PRIMARY KEY) ENGINE=MEMORY [0.00045585632324219 sec]
INSERT INTO tmp_base_goods (id)
SELECT DISTINCT g.id FROM pod_cat_good g
WHERE g.cat_id IN (115) AND g.entry=0 AND g.is_active AND g.is_present_all_mods
UNION
SELECT DISTINCT g.id FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
WHERE dc.dop_cat_id IN (115) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.0025539398193359 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, KEY idx_entry (entry)) ENGINE=MEMORY [0.00038790702819824 sec]
INSERT INTO tmp_sub_goods (id, entry)
SELECT go.id, go.entry 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.0015709400177002 sec]
SELECT g.id -- основні (tmp)
FROM tmp_base_goods t
INNER JOIN pod_cat_good g ON t.id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.brand_id IN (1203) AND
g.is_present_all_mods AND g.is_active
[0.020736932754517 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2ac4297104e (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.00022506713867188 sec]
INSERT INTO temp_brand_counts_6a2ac4297104e (id, gid)
SELECT g.brand_id AS id, g.id AS gid -- основні (tmp)
FROM tmp_base_goods t
INNER JOIN pod_cat_good g ON t.id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.is_present_all_mods AND g.is_active
UNION
SELECT id, null gid
FROM pod_cat_category
WHERE id in (1203) [0.025943040847778 sec]
SELECT b.id, b.name_ua AS name, pc.name_ua AS country, b.country_id,
b.image_icon, b.url, b.ordr, pc.code,
COALESCE(tc.count, 0) as count
FROM pod_cat_brand b
INNER JOIN (
SELECT id, COUNT(gid) as count
FROM temp_brand_counts_6a2ac4297104e
GROUP BY id
HAVING COUNT(gid) > 0
) tc ON b.id = tc.id
LEFT JOIN pod_country pc ON (pc.id = b.country_id AND pc.is_active = 1)
WHERE b.is_active = '1'
ORDER BY b.ordr [0.0010499954223633 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2ac4297104e [0.00025296211242676 sec]
SELECT MIN(min_price) AS min_price, MAX(max_price) AS max_price
FROM (
SELECT MIN(g.price) AS min_price, MAX(g.price) AS max_price -- основні (tmp)
FROM tmp_base_goods t
INNER JOIN pod_cat_good g ON t.id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.brand_id IN (1203) AND
g.is_present AND
g.is_present_all_mods AND g.is_active
UNION
SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price -- підтовари (tmp)
FROM tmp_sub_goods t
INNER JOIN pod_cat_good go ON t.id = go.id
INNER JOIN pod_cat_good g ON t.entry = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.brand_id IN (1203) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
) A
[0.00180983543396 sec]
SELECT g.id, if(g.is_present and g.price >= '1511' and g.price <= '1511',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) min_sort_price
, if(g.is_present and g.price >= '1511' and g.price <= '1511',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price
FROM pod_cat_good g
LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id and pcg.is_present=1 and pcg.is_present=1 and pcg.price >= '1511' and pcg.price <= '1511' WHERE g.id in (413741)
GROUP BY g.id
ORDER BY g.ordr desc
LIMIT 0, 32 [0.00078296661376953 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, if(g.is_present and g.price >= '1511' and g.price <= '1511',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) as min_sort_price,
if(g.is_present and g.price >= '1511' and g.price <= '1511',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.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
LEFT JOIN pod_cat_good pcg ON (pcg.entry=g.id and pcg.is_present=1 and pcg.price >= '1511' and pcg.price <= '1511')
WHERE g.id in (413741)
GROUP BY g.id
ORDER BY g.ordr desc [0.00078797340393066 sec]
SELECT g.ordr, g.is_xit, g.is_pay_for_video, g.is_action, g.is_sale, g.is_new, g.last_items, g.fast_delivery, g.free_delivery, g.gift,
g.timer, g.action_validity,
g.id, g.entry, g.name_ua AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name_ua AS sub_icon_name, si.icon AS sub_icon
FROM pod_cat_good g
LEFT JOIN pod_sub_icon si ON si.id = g.sub_icon_id
WHERE g.entry IN (413741) AND g.is_present = '1' AND g.is_active = '1'
ORDER BY g.entry, g.is_present DESC [0.00047016143798828 sec]
SELECT DISTINCT
ggd2.good_id AS source_good_id,
g.id, g.is_present_all_mods,
pc.name_ua AS name,
g.url,
b.url as burl, c.url as curl,
g.is_present,
pc.code AS color_code,
gg.group_type,
gg.param_name,
gg.param_name_ua,
ggd.text_value,
ggd.icon_path
FROM pod_goods_group_goods ggd2
JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id
JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id
JOIN pod_cat_good g ON g.id=ggd.good_id
LEFT JOIN pod_cat_brand b ON g.brand_id=b.id
LEFT JOIN pod_cat_category c ON g.cat_id=c.id
LEFT JOIN pod_colors pc ON pc.id=ggd.color_id
WHERE ggd2.good_id IN (413741)
ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.00087118148803711 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id in (1203) [0.00026702880859375 sec]
SELECT cb.id,
cb.info_ua AS info,
cb.title_ua AS title,
cb.metadesc_ua AS metadesc,
cb.seo_text_ua AS seo_text,
cb.tagH1_ua AS tagH1,
cb.canonical,
cb.is_active
FROM pod_set_cat_brand cb
WHERE
cb.cat_id = 115
AND cb.brand_id = 1203
AND cb.is_active = 1
LIMIT 1 [0.00032281875610352 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id='1203' [0.00025606155395508 sec]
SELECT url FROM pod_cat_brand WHERE id = 1203 [0.00024104118347168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8;
CREATE TEMPORARY TABLE tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.00040221214294434 sec]
INSERT INTO tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 (id) SELECT A.id FROM (
SELECT g.id -- основні (tmp)
FROM tmp_base_goods t
INNER JOIN pod_cat_good g ON t.id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.brand_id IN (1203) AND
g.is_present_all_mods AND g.is_active
) A [0.0014019012451172 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8;
CREATE TEMPORARY TABLE tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00035285949707031 sec]
INSERT INTO tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (110)
INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 115
INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.0052869319915771 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8;
CREATE TEMPORARY TABLE tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00035309791564941 sec]
INSERT IGNORE INTO tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 p
GROUP BY p.filter_id [0.00029301643371582 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name_ua AS name,
f.url,
f.ord,
fm.name_ua AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 c
INNER JOIN pod_filter f ON c.filter_id = f.id
INNER JOIN pod_filter fm ON f.entry = fm.id
ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00027918815612793 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 [0.0002439022064209 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 [0.00011897087097168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297d0f8 [0.00010895729064941 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957;
CREATE TEMPORARY TABLE tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 (
id INT NOT NULL,
entry INT NOT NULL,
PRIMARY KEY (id),
KEY idx_entry (entry)
) ENGINE=MEMORY; [0.00032687187194824 sec]
INSERT INTO tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 (id, entry) SELECT A.id, A.entry FROM (
SELECT g.id as id, g.id as entry -- основні (tmp)
FROM tmp_base_goods t
INNER JOIN pod_cat_good g ON t.id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.brand_id IN (1203) AND
g.is_present AND
g.is_present_all_mods AND g.is_active
UNION
SELECT go.id as id, g.id as entry -- підтовари (tmp)
FROM tmp_sub_goods t
INNER JOIN pod_cat_good go ON t.id = go.id
INNER JOIN pod_cat_good g ON t.entry = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.brand_id IN (1203) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
) A [0.0021638870239258 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957;
CREATE TEMPORARY TABLE tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00045299530029297 sec]
INSERT INTO tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 (goods_id, filter_id)
SELECT DISTINCT
A.entry AS goods_id,
f.id AS filter_id
FROM tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (110)
INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 115
INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.00082206726074219 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957;
CREATE TEMPORARY TABLE tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00040793418884277 sec]
INSERT IGNORE INTO tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 p
GROUP BY p.filter_id [0.00042200088500977 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name_ua AS name,
f.url,
f.ord,
fm.name_ua AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 c
INNER JOIN pod_filter f ON c.filter_id = f.id
INNER JOIN pod_filter fm ON f.entry = fm.id
ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.0004878044128418 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 [0.00036406517028809 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 [0.00018692016601562 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac4297f957 [0.00025296211242676 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8;
CREATE TEMPORARY TABLE tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.00026917457580566 sec]
INSERT INTO tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 (id) SELECT A.id FROM (
SELECT g.id -- основні (tmp)
FROM tmp_base_goods t
INNER JOIN pod_cat_good g ON t.id = g.id
WHERE g.brand_id IN (1203) AND
g.is_present_all_mods AND g.is_active
) A [0.0012431144714355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8;
CREATE TEMPORARY TABLE tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00034904479980469 sec]
INSERT INTO tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 106
INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.0032060146331787 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8;
CREATE TEMPORARY TABLE tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00036311149597168 sec]
INSERT INTO tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 p
GROUP BY p.filter_id [0.00029993057250977 sec]
INSERT IGNORE INTO tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 c ON c.filter_id = pf.id
WHERE pf.id in (110) AND c.filter_id IS NULL [0.00026679039001465 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name_ua AS name,
f.url,
f.ord,
fm.name_ua AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 c
INNER JOIN pod_filter f ON c.filter_id = f.id
INNER JOIN pod_filter fm ON f.entry = fm.id
ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00029301643371582 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 [0.00030207633972168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 [0.00012993812561035 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429815e8 [0.0001220703125 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1;
CREATE TEMPORARY TABLE tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1 (
entry INT NOT NULL,
sub_icon_id INT NOT NULL,
PRIMARY KEY (entry, sub_icon_id)
) ENGINE=MEMORY; [0.00026702880859375 sec]
INSERT IGNORE INTO tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1 (entry, sub_icon_id)
SELECT DISTINCT A.entry, A.sub_icon_id FROM (
SELECT g.id as id, g.id as entry, g.sub_icon_id -- основні (tmp)
FROM tmp_base_goods t
INNER JOIN pod_cat_good g ON t.id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.brand_id IN (1203) AND
g.is_present AND
g.is_present_all_mods AND g.is_active
UNION
SELECT go.id as id, g.id as entry, go.sub_icon_id -- підтовари (tmp)
FROM tmp_sub_goods t
INNER JOIN pod_cat_good go ON t.id = go.id
INNER JOIN pod_cat_good g ON t.entry = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (110)
WHERE g.brand_id IN (1203) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
) A [0.0019869804382324 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1;
CREATE TEMPORARY TABLE tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1 (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00033807754516602 sec]
INSERT IGNORE INTO tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1 (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1 A
INNER JOIN pod_sub_icon si ON A.sub_icon_id = si.id AND si.is_active_filter = 1
) AA
GROUP BY sub_icon_id [0.00042605400085449 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name_ua AS name,
si.url
FROM tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1 c
INNER JOIN pod_sub_icon si ON c.sub_icon_id = si.id AND si.is_active_filter = 1
ORDER BY si.ordr, si.name [0.00037813186645508 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1 [0.00028514862060547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_j75mah0mbp0k9uve6d0r1d6dsb_6a2ac429836c1 [0.00017499923706055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00026822090148926 sec]
Низькі ціни на Каструлі Lamart (Лaмaрт) - великий вибір, фото. Купити Каструлі Lamart (Лaмaрт) в Києві і Україні
Каструлі Lamart - французьке якість від шеф-кухаря
Торгова марка «Lamart» заснована французьким кухарем, який працював в сімейному ресторані на березі Атлантичного океану. Тоді П'єр Ламар загорівся ідеєю створити лінійку сучасних кухонного приладдя, які будуть полегшувати процес готування улюблених страв. Так світ побачив легендарні каструлі Lamart.
Різноманітність моделей на всі випадки життя
Посуд виготовляється з першокласних матеріалів із застосуванням інноваційних технологій:
колекція «Shiny» з керамічним антипригарним покриттям
серія «Multicolor» з кольорового алюмінію з противопригарного поверхнею Greblon
колекція «Iron» з чавуну з антипригарним емальовані зсередини
серія «Joli» - каструлі Lamart з нержавійки з багатошаровим дном
алюмінієвий посуд з мармурової поверхнею.
Хочете придбати товари Lamart за вигідною вартості в Києві? Ласкаво просимо в інтернет-магазин «Подушка», де можна купити каструлі за доступними цінами. У каталозі ви зможете вибрати посуд з алюмінію, чавуну і нержавіючої сталі з фірмовими антипригарним покриттям. Кожна каструля Lamart оснащена скляною кришкою з паровиходом і ергономічними ручками.
Ваше замовлення оформлено! На e-mail відправлено лист з підтвердженням Найближчим часом з Вами зв'яжеться менеджер Дякємо за замовлення!
Ваш профіль буде видалений назавжди. Його не можна відновити. Продовжити?
Залиште свій номер телефону і наші менеджери Вам зателефонують
Оплату картами Visa і MasterCard забезпечує сервіс онлайн-платежів Portmone.com. Безпека оплати підтверджена міжнародним аудитом PCI DSS. Служба підтримки: тел. +380 (44) 2000902