SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/kastryuli/glass-maestro.html' LIMIT 0,1 [0.00072789192199707 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('glass','maestro') order by url [0.00071001052856445 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('glass','maestro') order by url [0.0005030632019043 sec]
select id,url from pod_cat_brand where BINARY url IN ('glass','maestro') [0.00090479850769043 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 = 332
AND cb.is_active = 1
LIMIT 1 [0.00084805488586426 sec]
SELECT id, url FROM pod_filter WHERE url IN ('glass','maestro') [0.00029277801513672 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('glass','maestro') [0.00024604797363281 sec]
SELECT g.id -- основні
FROM pod_cat_good g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT g.id -- основні в допкатегорії
FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
[0.012696027755737 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2a814640106 (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.0013720989227295 sec]
INSERT INTO temp_brand_counts_6a2a814640106 (id, gid)
SELECT g.brand_id AS id, g.id AS gid -- основні
FROM pod_cat_good g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT g.brand_id AS id, g.id AS gid -- основні в допкатегорії
FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT id, null gid
FROM pod_cat_category
WHERE id in (332) [0.0017590522766113 sec]
SELECT b.id, b.name AS name, pc.name 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_6a2a814640106
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.00054097175598145 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2a814640106 [0.0001678466796875 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 -- основні
FROM pod_cat_good g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT MIN(g.price) AS min_price, MAX(g.price) AS max_price -- основні в допкатегорії
FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price -- підтовари
FROM
pod_cat_good go
INNER JOIN pod_cat_good g ON go.entry = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
UNION
SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price -- підтовари в допкатегорії
FROM pod_cat_good go
INNER JOIN pod_cat_good g ON go.entry = g.id
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.brand_id IN (332) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
) A
[0.0016219615936279 sec]
SELECT g.id, if(g.is_present and g.price >= '194' and g.price <= '301',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 >= '194' and g.price <= '301',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 >= '194' and pcg.price <= '301' WHERE g.id in (166821,468197,468198)
GROUP BY g.id
ORDER BY g.ordr desc
LIMIT 0, 32 [0.0032448768615723 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 AS name, g.name2 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 AS brand_name,b.url as burl,b.id as bid, b.country AS brand_country,c.url as curl, c.name AS cat_name,
si.name AS sub_icon_name,si.icon AS sub_icon,
g.star, g.comment_id, if(g.is_present and g.price >= '194' and g.price <= '301',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 >= '194' and g.price <= '301',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 >= '194' and pcg.price <= '301')
WHERE g.id in (166821,468197,468198)
GROUP BY g.id
ORDER BY g.ordr desc [0.00074505805969238 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.name AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name 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 = '166821' AND g.is_present = '1' AND g.is_active = '1'
ORDER BY g.is_present DESC [0.00023603439331055 sec]
SELECT distinct g.id, g.is_present_all_mods,
pc.name 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_cat_good g
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_goods_group_goods ggd2 ON ggd2.good_id = 166821
LEFT JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id
LEFT JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id
LEFT JOIN pod_colors pc ON pc.id=ggd.color_id
WHERE
g.id=ggd.good_id
order by g.id= 166821 desc, g.is_present_all_mods desc [0.00055885314941406 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.name AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name 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 = '468197' AND g.is_present = '1' AND g.is_active = '1'
ORDER BY g.is_present DESC [0.00018477439880371 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.name AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name 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 = '468198' AND g.is_present = '1' AND g.is_active = '1'
ORDER BY g.is_present DESC [0.00017809867858887 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id in (332) [0.0001218318939209 sec]
SELECT cb.id,
cb.info AS info,
cb.title AS title,
cb.metadesc AS metadesc,
cb.seo_text AS seo_text,
cb.tagH1 AS tagH1,
cb.canonical,
cb.is_active
FROM pod_set_cat_brand cb
WHERE
cb.cat_id = 115
AND cb.brand_id = 332
AND cb.is_active = 1
LIMIT 1 [0.00016188621520996 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='332' [0.00012111663818359 sec]
SELECT url FROM pod_cat_brand WHERE id = 332 [0.0001380443572998 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c;
CREATE TEMPORARY TABLE tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.00025606155395508 sec]
INSERT INTO tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c (id) SELECT A.id FROM (
SELECT g.id -- основні
FROM pod_cat_good g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT g.id -- основні в допкатегорії
FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
) A [0.00066304206848145 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c;
CREATE TEMPORARY TABLE tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00018787384033203 sec]
INSERT INTO tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (111)
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.0053131580352783 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c;
CREATE TEMPORARY TABLE tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00021696090698242 sec]
INSERT IGNORE INTO tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c p
GROUP BY p.filter_id [0.00017380714416504 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name AS name,
f.url,
f.ord,
fm.name AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c 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.00020003318786621 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c [0.00014495849609375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c [6.3896179199219E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814644f4c [6.0081481933594E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18;
CREATE TEMPORARY TABLE tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 (
id INT NOT NULL,
entry INT NOT NULL,
PRIMARY KEY (id),
KEY idx_entry (entry)
) ENGINE=MEMORY; [0.00017118453979492 sec]
INSERT INTO tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 (id, entry) SELECT A.id, A.entry FROM (
SELECT g.id as id, g.id as entry -- основні
FROM pod_cat_good g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT g.id as id, g.id as entry -- основні в допкатегорії
FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT go.id as id, g.id as entry -- підтовари
FROM
pod_cat_good go
INNER JOIN pod_cat_good g ON go.entry = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
UNION
SELECT go.id as id, g.id as entry -- підтовари в допкатегорії
FROM pod_cat_good go
INNER JOIN pod_cat_good g ON go.entry = g.id
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.brand_id IN (332) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
) A [0.0012869834899902 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18;
CREATE TEMPORARY TABLE tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.0002589225769043 sec]
INSERT INTO tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 (goods_id, filter_id)
SELECT DISTINCT
A.entry AS goods_id,
f.id AS filter_id
FROM tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (111)
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.00050497055053711 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18;
CREATE TEMPORARY TABLE tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.0001990795135498 sec]
INSERT IGNORE INTO tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 p
GROUP BY p.filter_id [0.00036191940307617 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name AS name,
f.url,
f.ord,
fm.name AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 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.00027799606323242 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 [0.00019502639770508 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 [0.0001220703125 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a814646e18 [0.00010204315185547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c;
CREATE TEMPORARY TABLE tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.00014805793762207 sec]
INSERT INTO tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c (id) SELECT A.id FROM (
SELECT g.id -- основні
FROM pod_cat_good g USE INDEX (idx_cat_entry_active_present)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT 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.brand_id IN (332) AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
) A [0.024883031845093 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c;
CREATE TEMPORARY TABLE tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00028896331787109 sec]
INSERT INTO tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c 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.010643005371094 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c;
CREATE TEMPORARY TABLE tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00021004676818848 sec]
INSERT INTO tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c p
GROUP BY p.filter_id [0.00021100044250488 sec]
INSERT IGNORE INTO tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c c ON c.filter_id = pf.id
WHERE pf.id in (111) AND c.filter_id IS NULL [0.00015497207641602 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name AS name,
f.url,
f.ord,
fm.name AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c 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.0002598762512207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c [0.00013899803161621 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c [8.2015991210938E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a81464803c [6.6041946411133E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4;
CREATE TEMPORARY TABLE tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4 (
entry INT NOT NULL,
sub_icon_id INT NOT NULL,
PRIMARY KEY (entry, sub_icon_id)
) ENGINE=MEMORY; [0.00011992454528809 sec]
INSERT IGNORE INTO tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4 (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 -- основні
FROM pod_cat_good g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT g.id as id, g.id as entry, g.sub_icon_id -- основні в допкатегорії
FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.brand_id IN (332) AND
g.is_present AND
g.is_present_all_mods AND g.entry =0 AND g.is_active
UNION
SELECT go.id as id, g.id as entry, go.sub_icon_id -- підтовари
FROM
pod_cat_good go
INNER JOIN pod_cat_good g ON go.entry = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE g.cat_id IN (115) AND
g.brand_id IN (332) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
UNION
SELECT go.id as id, g.id as entry, go.sub_icon_id -- підтовари в допкатегорії
FROM pod_cat_good go
INNER JOIN pod_cat_good g ON go.entry = g.id
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (111)
WHERE dc.dop_cat_id IN (115) AND
g.brand_id IN (332) AND
go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active
) A [0.0013558864593506 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4;
CREATE TEMPORARY TABLE tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4 (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.0001680850982666 sec]
INSERT IGNORE INTO tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4 (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4 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.00025486946105957 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name AS name,
si.url
FROM tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4 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.00012588500976562 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4 [0.00014901161193848 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_gvi5l4mp94enq8utb1jbbhucrh_6a2a8146513a4 [6.3180923461914E-5 sec]
Низкие цены на Кастрюли MAESTRO (MAEСTРO) – большой выбор, фото. Купить Кастрюли MAESTRO (MAEСTРO) в Киеве и Украине
Кухонные кастрюли Maestro – высокое качество и доступная цена
От того насколько качественная кастрюля зависит вкус и безопасность приготовленной еды. Китайская торговая марка Maestro на протяжении многих лет занимается производством высококачественной профессиональной посуды из нержавеющей стали и керамики. Практически все крышки кастрюль выполнены из прочного стекла, которое очень сложно разбить. Также, производятся кастрюли с керамическими крышками. Широкое разнообразие моделей позволяет сделать свой выбор максимально быстро. Сегодня кастрюли Maestro можно найти в различных вариациях:
Металлические, выполненные из нержавеющей стали;
Керамические антипригарные кастрюли из прочного материала со стеклянной и керамической крышкой;
Сотейники (ковши) с ручкой, стеклянной крышкой;
Наборы кастрюль, состоящие из нескольких единиц посуды, различных по своему объему.
Разнообразие размеров, форм и дизайнов просто поражает воображение.
Почему Maestro?
Вся продукция известной мировой марки выполнена из прочных и качественных материалов, которые остаются безопасными даже при достижении высокой температуре. По этой причине кастрюля Маэстро является прочным и надежным кухонным девайсом. Кастрюли предназначены для приготовления любой пищи, которая подразумевает выполнение различных процессов: варка, тушение, бланшировка и пр.
Практичность кастрюль Maestro обусловлена их высоким качеством. Благодаря этому фактору на стенках посуды не скапливаются загрязнения. Термодинамическую крышку с самой кастрюлей можно смело мыть в посудомоечной машине с применением специальных моющих средств. Большое количество моделей кухонной посуды можно использовать на газовых, электрических и индукционных плитах. Вкус еды приготовленной в кастрюлях Maestro получается насыщенным, при этом пища не теряет своих полезных свойств. Плавные линии, разнообразие цветов, объемов, а также высокий уровень функциональности делают кастрюли Маэстро незаменимой посудой на любой профессиональной и домашней кухне.
Преимущества покупки в интернет-магазине «podushka»
Не знаете, где в Киеве купить оригинальную продукцию торговой марки Maestro по доступной цене? Предлагаем посетить страницы сайта «podushka». Широкий ассортимент товара позволяет удовлетворить потребность каждого покупателя. Доставка товара осуществляется по всей территории Украины, любой удобной для заказчика курьерско-транспортной компанией. Добро пожаловать в интернет-магазин «podushka»!
Ваш заказ оформлен! На e-mail отправлено письмо с подтверждением В ближайшее время с Вами свяжется менеджер Спасибо за заказ!
Ваш профиль будет удален навсегда. Его нельзя восстановить. Продолжить?
Оставьте свой номер телефона и наши менеджеры вам перезвонят
Оплату картами Visa и MasterCard обеспечивает сервис онлайн-платежей Portmone.com. Безопасность оплаты подтверждена международным аудитом PCI DSS. Служба поддержки: тел. +380(44)2000902