SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/kukly/o_4-o_9-same_toy-bubiloons.html' LIMIT 0,1 [0.00041508674621582 sec]
select id,name,url, is_active from pod_cat_category where url = 'kukly' [0.00031304359436035 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('o_4','o_9','same_toy','bubiloons') order by url [0.0012900829315186 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('o_4','o_9','same_toy','bubiloons') order by url [0.00053501129150391 sec]
select id,url from pod_cat_brand where BINARY url IN ('o_4','o_9','same_toy','bubiloons') [0.00089478492736816 sec]
select id from pod_structure where link='catalogue/108' and active='1' AND lang_ru='1' [0.00031089782714844 sec]
SELECT id, url FROM pod_filter WHERE url IN ('o_4','o_9','same_toy','bubiloons') [0.0005640983581543 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('o_4','o_9','same_toy','bubiloons') [0.00042295455932617 sec]
SELECT c.id, c.super_category_id, c.entry, c.name AS name, c.title AS cat_title, c.metakwds AS cat_kwds, c.metadesc AS cat_metadesc, c.descr AS cat_descr, cc.name AS parent_name, cc.url AS parent_url, c.url as curl, cc.image AS parent_image, c.seo_text AS seo_text, c.seo_text_mobile AS seo_text_mobile, c.action_text AS action_text, c.view_type, c.is_delivery_custom, c.hide_subcat_sidebar, c.image FROM pod_cat_category c LEFT JOIN pod_cat_category cc ON cc.id=c.entry WHERE c.id='108' [0.00020718574523926 sec]
SELECT sc.url, sc.id AS super_category_id, sc.name AS super_category_name, sc.templ_good_title AS templ_good_title, sc.templ_good_kwds, sc.templ_good_desc AS templ_good_desc, sc.templ_brand_title AS templ_brand_title, sc.templ_brand_kwds, sc.templ_brand_desc AS templ_brand_desc, sc.templ_cat_title AS templ_cat_title, sc.templ_cat_kwds, sc.templ_cat_desc AS templ_cat_desc, 1 AS o FROM pod_cat_category c LEFT JOIN pod_super_category sc ON sc.id=c.super_category_id WHERE c.id='692' [0.00017094612121582 sec]
SELECT id FROM pod_cat_category WHERE entry='108' [0.00013399124145508 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.00023293495178223 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 (108) 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 (108) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.38752913475037 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.00058698654174805 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.00072693824768066 sec]
SELECT g.id /* cats:108 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND g.is_present AND 1 UNION SELECT g.id /* cats:108 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND 1 [0.013814926147461 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2af234ae6c5 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.0011210441589355 sec]
INSERT INTO temp_brand_counts_6a2af234ae6c5 (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:108 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.is_present AND 1 UNION SELECT g.brand_id AS id, g.id AS gid /* cats:108 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (1600,2527) [0.006580114364624 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_6a2af234ae6c5 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.00077390670776367 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2af234ae6c5 [0.00022101402282715 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 /* cats:108 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:108 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND 1 ) A [0.00065994262695312 sec]
SELECT g.id /* cats:108 */,if(g.is_present and g.price >= '299' and g.price <= '299',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 >= '299' and g.price <= '299',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price FROM tmp_base_goods g LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id AND pcg.is_present=1 AND pcg.price >= '299' AND pcg.price <= '299' WHERE g.id IN (452879,452875) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0011141300201416 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 >= '299' and g.price <= '299',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 >= '299' and g.price <= '299',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 >= '299' and pcg.price <= '299') WHERE g.id in (452875,452879) GROUP BY g.id ORDER BY g.ordr desc [0.0014660358428955 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 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 IN (452875,452879) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00052499771118164 sec]
SELECT DISTINCT ggd2.good_id AS source_good_id, 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_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 (452875,452879) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.00065183639526367 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id in (1600,2527) [0.00030994415283203 sec]
SELECT p.id, p.dt, p.title as title, p.descr, p.thumb, p.url, s.link FROM pod_publication p LEFT JOIN pod_pub_type pt ON pt.id=p.rub_id LEFT JOIN pod_structure s ON pt.page_id=s.id LEFT JOIN pod_cat_public cp ON (cp.public_id = p.id) WHERE p.rub_id = 2 AND p.active='1' AND cp.category_id='108' ORDER BY p.dt DESC LIMIT 1 [0.0055208206176758 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='1600.2527' [0.00026988983154297 sec]
SELECT id, name AS name, url, entry FROM pod_cat_category WHERE is_active='1' AND is_hidden='0' AND entry='0' AND super_category_id='3' AND id!='108' ORDER BY ordr [0.00078916549682617 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304; CREATE TEMPORARY TABLE tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00049400329589844 sec]
INSERT INTO tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 (id) SELECT A.id FROM ( SELECT g.id /* cats:108 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND g.is_present AND 1 UNION SELECT g.id /* cats:108 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND 1 ) A [0.00085091590881348 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304; CREATE TEMPORARY TABLE tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00038504600524902 sec]
INSERT INTO tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (362,367) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 108 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.01061487197876 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304; CREATE TEMPORARY TABLE tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00045680999755859 sec]
INSERT IGNORE INTO tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 p GROUP BY p.filter_id [0.00046515464782715 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_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 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.00035977363586426 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 [0.00030899047851562 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 [0.00018811225891113 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234b7304 [0.00014495849609375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277; CREATE TEMPORARY TABLE tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00030303001403809 sec]
INSERT INTO tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:108 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:108 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND 1 ) A [0.00082087516784668 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277; CREATE TEMPORARY TABLE tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00041794776916504 sec]
INSERT INTO tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (362,367) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 108 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.00091099739074707 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277; CREATE TEMPORARY TABLE tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00040507316589355 sec]
INSERT IGNORE INTO tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 p GROUP BY p.filter_id [0.00039100646972656 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_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 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.00041913986206055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 [0.00036907196044922 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 [0.00018191337585449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bb277 [0.00013399124145508 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc; CREATE TEMPORARY TABLE tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00027894973754883 sec]
INSERT INTO tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:108 */ FROM tmp_base_goods g WHERE g.brand_id IN (1600,2527) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:108 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id WHERE g.brand_id IN (1600,2527) AND 1 ) A [0.00049400329589844 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc; CREATE TEMPORARY TABLE tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.00049614906311035 sec]
INSERT INTO tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 262 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.0079090595245361 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc; CREATE TEMPORARY TABLE tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00045108795166016 sec]
INSERT INTO tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc p GROUP BY p.filter_id [0.00045299530029297 sec]
INSERT INTO tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc c ON c.filter_id = pf.id WHERE pf.id in (362,367) AND c.filter_id IS NULL [0.00038409233093262 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_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc 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.00048685073852539 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc [0.00030207633972168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc [0.00013113021850586 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bc9dc [0.00012683868408203 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46; CREATE TEMPORARY TABLE tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00023508071899414 sec]
INSERT IGNORE INTO tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46 (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 /* cats:108 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:108 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (362,367) WHERE g.brand_id IN (1600,2527) AND 1 ) A [0.00085306167602539 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46; CREATE TEMPORARY TABLE tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00034809112548828 sec]
INSERT IGNORE INTO tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46 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.00051283836364746 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46 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.0002739429473877 sec]
SELECT COUNT(*) FROM tmp_base_goods [0.0001521110534668 sec]
Array ( [0] => Array ( [COUNT(*)] => 84 ) ) SELECT COUNT(*) FROM tmp_sub_goods [0.00012612342834473 sec]
Array ( [0] => Array ( [COUNT(*)] => 0 ) ) SELECT COUNT(*) FROM pod_cat_filter WHERE category_id = 2 [0.00025296211242676 sec]
Array ( [0] => Array ( [COUNT(*)] => 4 ) ) SELECT COUNT(*) FROM pod_cat_filter WHERE category_id = 3 [0.00023508071899414 sec]
Array ( [0] => Array ( [COUNT(*)] => 5 ) ) DROP TEMPORARY TABLE IF EXISTS tmp_A_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46 [0.00033402442932129 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_o8487ngqejc7fjebbeae3c4uls_6a2af234bfd46 [0.00018596649169922 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00024700164794922 sec]
Низкие цены на Детские куклы Same Toy ... Bubiloons (Сaмe Toи ... Бубілooнс) – большой выбор, фото. Купить Детские куклы Same Toy ... Bubiloons (Сaмe Toи ... Бубілooнс) в Киеве и Украине

DEVELOPMENT🌷СКИДКИ ДО 70%

Магазин PODUSHKA ®

Магазин PODUSHKA ®
Игрушки для детей Игрушки для детей
Игрушки для девочек Игрушки для девочек
Детские куклы Детские куклы
Same Toy ... Bubiloons Same Toy ... Bubiloons

Детские куклы Same Toy ... Bubiloons

Как правильно выбрать игрушку для ребенка