SELECT UPPER(`type`) AS `type`, UPPER(`name`) AS `name`, `expire` FROM sys_cache_expires [ RunTime:0.003356s ]
select id,url_name from article where url_name !='' [ RunTime:0.003048s ]
select id,url_name from article where url_name !='' [ RunTime:0.003002s ]
select * from sys_pc_pages where flag='foot_help' [ RunTime:0.003073s ]
select id,title from article where cat_id=4 and is_open=1 limit 0,7 [ RunTime:0.003167s ]
select id,url_name from article where id='6' [ RunTime:0.002955s ]
select * from article_cat where id='4' [ RunTime:0.003007s ]
select id,title from article where cat_id=7 and is_open=1 limit 0,7 [ RunTime:0.002971s ]
select id,url_name from article where id='8' [ RunTime:0.002917s ]
select id,url_name from article where id='11' [ RunTime:0.002953s ]
select * from article_cat where id='7' [ RunTime:0.003020s ]
select id,title from article where cat_id=5 and is_open=1 limit 0,7 [ RunTime:0.002991s ]
select id,url_name from article where id='13' [ RunTime:0.002909s ]
select id,url_name from article where id='15' [ RunTime:0.002955s ]
select id,url_name from article where id='17' [ RunTime:0.003118s ]
select * from article_cat where id='5' [ RunTime:0.002953s ]
select * from friend_link order by sort_order desc limit 0,5 [ RunTime:0.003004s ]
select * from sys_pc_pages where flag='header_nav' [ RunTime:0.003065s ]
select * from cat where parent_id='1' order by sort_order asc [ RunTime:0.003016s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003042s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003018s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003068s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003069s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.002970s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.002932s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.002974s ]
SELECT count(*) FROM cat WHERE parent_id = '73' AND is_show = 1 [ RunTime:0.003008s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '73' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.002966s ]
select b.* from goods as g left join brand b on g.brand_id=b.id where g.cat_id IN ('73') and b.id >0 group by b.id [ RunTime:0.003277s ]
SELECT * FROM cat WHERE id='73' LIMIT 1 [ RunTime:0.003037s ]
select pic,parent_id from cat where id='73' [ RunTime:0.002939s ]
select pic,parent_id from cat where id='' [ RunTime:0.002917s ]
select pic,parent_id from cat where id='' [ RunTime:0.002902s ]
select pic,parent_id from cat where id='' [ RunTime:0.002930s ]
SELECT count(*) FROM cat WHERE parent_id = '0' [ RunTime:0.003037s ]
SELECT id,cat_name ,parent_id,is_show FROM cat WHERE parent_id = '0' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003002s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003033s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '1' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.002993s ]
SELECT count(*) FROM cat WHERE parent_id = '2' AND is_show = 1 [ RunTime:0.003055s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '2' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003021s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.002980s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '3' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003001s ]
SELECT count(*) FROM cat WHERE parent_id = '4' AND is_show = 1 [ RunTime:0.002968s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '4' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.002925s ]
SELECT count(*) FROM cat WHERE parent_id = '73' [ RunTime:0.002983s ]
SELECT id,cat_name ,parent_id,is_show FROM cat WHERE parent_id = '73' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.002997s ]
SELECT count(*) FROM cat WHERE parent_id = '73' AND is_show = 1 [ RunTime:0.002990s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '73' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.002955s ]
SELECT a.attr_id,attr_value,attr.attr_name FROM goods_attr as a left join goods g on a.goods_id = g.id left join attr on a.attr_id=attr.id where g.cat_id IN ('73') and attr.is_linked=1 GROUP BY a.attr_id,a.attr_value [ RunTime:0.003241s ]
SELECT count(*) FROM cat WHERE parent_id = '73' AND is_show = 1 [ RunTime:0.002993s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '73' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003000s ]
SELECT goods_id FROM goods_cat AS g WHERE g.cat_id IN ('73') [ RunTime:0.002930s ]
SELECT count(*) as total_num FROM goods AS g WHERE g.is_on_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('73') OR g.id IN ('') ) [ RunTime:0.003024s ]
SELECT g.id as goods_id, g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS shop_price, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img,g.brand_id,b.name as brand_name FROM goods AS g left join brand b on g.brand_id=b.id WHERE g.is_on_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('73') OR g.id IN ('') ) ORDER BY g.id desc limit 0, 24 [ RunTime:0.003060s ]
SELECT id,keywords,cat_desc,parent_id FROM cat WHERE id='73' LIMIT 1 [ RunTime:0.003024s ]
