SELECT UPPER(`type`) AS `type`, UPPER(`name`) AS `name`, `expire` FROM sys_cache_expires [ RunTime:0.003591s ]
select id,url_name from article where url_name !='' [ RunTime:0.003337s ]
select id,url_name from article where url_name !='' [ RunTime:0.003244s ]
select * from sys_pc_pages where flag='foot_help' [ RunTime:0.003337s ]
select id,title from article where cat_id=4 and is_open=1 limit 0,7 [ RunTime:0.003237s ]
select id,url_name from article where id='6' [ RunTime:0.003178s ]
select * from article_cat where id='4' [ RunTime:0.003155s ]
select id,title from article where cat_id=7 and is_open=1 limit 0,7 [ RunTime:0.003182s ]
select id,url_name from article where id='8' [ RunTime:0.003143s ]
select id,url_name from article where id='11' [ RunTime:0.003168s ]
select * from article_cat where id='7' [ RunTime:0.003224s ]
select id,title from article where cat_id=5 and is_open=1 limit 0,7 [ RunTime:0.003249s ]
select id,url_name from article where id='13' [ RunTime:0.003215s ]
select id,url_name from article where id='15' [ RunTime:0.003149s ]
select id,url_name from article where id='17' [ RunTime:0.003174s ]
select * from article_cat where id='5' [ RunTime:0.003211s ]
select * from friend_link order by sort_order desc limit 0,5 [ RunTime:0.003255s ]
select * from sys_pc_pages where flag='header_nav' [ RunTime:0.003242s ]
select * from cat where parent_id='1' order by sort_order asc [ RunTime:0.003227s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003237s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003203s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003214s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003239s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.003183s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003172s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.003202s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003211s ]
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.003186s ]
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.003238s ]
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.003222s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003189s ]
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.003184s ]
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.003178s ]
SELECT count(*) FROM cat WHERE parent_id = '4' AND is_show = 1 [ RunTime:0.003228s ]
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.003172s ]
select b.* from goods as g left join brand b on g.brand_id=b.id where g.cat_id IN ('1','2','3','4') and b.id >0 group by b.id [ RunTime:0.003575s ]
SELECT id, cat_name, parent_id FROM cat [ RunTime:0.003231s ]
SELECT * FROM cat WHERE id='1' LIMIT 1 [ RunTime:0.003269s ]
select pic,parent_id from cat where id='1' [ RunTime:0.003140s ]
select pic,parent_id from cat where id='0' [ RunTime:0.003144s ]
select pic,parent_id from cat where id='' [ RunTime:0.003161s ]
select pic,parent_id from cat where id='' [ RunTime:0.003188s ]
SELECT count(*) FROM cat WHERE parent_id = '0' [ RunTime:0.003206s ]
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.003206s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003215s ]
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.003355s ]
SELECT count(*) FROM cat WHERE parent_id = '2' AND is_show = 1 [ RunTime:0.003179s ]
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.003174s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003160s ]
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.003195s ]
SELECT count(*) FROM cat WHERE parent_id = '4' AND is_show = 1 [ RunTime:0.003200s ]
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.003141s ]
SELECT count(*) FROM cat WHERE parent_id = '1' [ RunTime:0.003204s ]
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.003165s ]
SELECT count(*) FROM cat WHERE parent_id = '2' AND is_show = 1 [ RunTime:0.003234s ]
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.003234s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003189s ]
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.003222s ]
SELECT count(*) FROM cat WHERE parent_id = '4' AND is_show = 1 [ RunTime:0.003179s ]
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.003186s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003186s ]
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.003168s ]
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.003169s ]
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.003158s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003187s ]
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.003287s ]
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.003216s ]
SELECT count(*) FROM cat WHERE parent_id = '4' AND is_show = 1 [ RunTime:0.003179s ]
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.003254s ]
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 ('1','2','3','4') and attr.is_linked=1 GROUP BY a.attr_id,a.attr_value [ RunTime:0.003715s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003246s ]
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.003238s ]
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.003241s ]
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.003258s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003239s ]
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.003205s ]
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.003225s ]
SELECT count(*) FROM cat WHERE parent_id = '4' AND is_show = 1 [ RunTime:0.003224s ]
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.003237s ]
SELECT goods_id FROM goods_cat AS g WHERE g.cat_id IN ('1','2','3','4') [ RunTime:0.003181s ]
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 ('1','2','3','4') OR g.id IN ('') ) [ RunTime:0.003309s ]
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 ('1','2','3','4') OR g.id IN ('') ) ORDER BY g.id desc limit 0, 24 [ RunTime:0.003382s ]
select sum(num) as num from goods_buy_log where goods_id='33' [ RunTime:0.003258s ]
select * from shop_config where code='currency_format' [ RunTime:0.003153s ]
select * from shop_config where code='currency_format' [ RunTime:0.003130s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 33 and is_main=1 [ RunTime:0.003211s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 33 and is_main2=1 [ RunTime:0.003304s ]
select sum(num) as num from goods_buy_log where goods_id='31' [ RunTime:0.003263s ]
select * from shop_config where code='currency_format' [ RunTime:0.003235s ]
select * from shop_config where code='currency_format' [ RunTime:0.003170s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 31 and is_main=1 [ RunTime:0.003256s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 31 and is_main2=1 [ RunTime:0.003265s ]
select sum(num) as num from goods_buy_log where goods_id='29' [ RunTime:0.003277s ]
select * from shop_config where code='currency_format' [ RunTime:0.003222s ]
select * from shop_config where code='currency_format' [ RunTime:0.003170s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 29 and is_main=1 [ RunTime:0.003182s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 29 and is_main2=1 [ RunTime:0.003204s ]
select sum(num) as num from goods_buy_log where goods_id='28' [ RunTime:0.003262s ]
select * from shop_config where code='currency_format' [ RunTime:0.003218s ]
select * from shop_config where code='currency_format' [ RunTime:0.003200s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 28 and is_main=1 [ RunTime:0.003186s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 28 and is_main2=1 [ RunTime:0.003224s ]
select sum(num) as num from goods_buy_log where goods_id='27' [ RunTime:0.003174s ]
select * from shop_config where code='currency_format' [ RunTime:0.003181s ]
select * from shop_config where code='currency_format' [ RunTime:0.003156s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 27 and is_main=1 [ RunTime:0.003183s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 27 and is_main2=1 [ RunTime:0.003199s ]
select sum(num) as num from goods_buy_log where goods_id='26' [ RunTime:0.003179s ]
select * from shop_config where code='currency_format' [ RunTime:0.003195s ]
select * from shop_config where code='currency_format' [ RunTime:0.003215s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 26 and is_main=1 [ RunTime:0.003189s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 26 and is_main2=1 [ RunTime:0.003203s ]
select sum(num) as num from goods_buy_log where goods_id='25' [ RunTime:0.003192s ]
select * from shop_config where code='currency_format' [ RunTime:0.003228s ]
select * from shop_config where code='currency_format' [ RunTime:0.003153s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 25 and is_main=1 [ RunTime:0.003204s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 25 and is_main2=1 [ RunTime:0.003269s ]
select sum(num) as num from goods_buy_log where goods_id='24' [ RunTime:0.003227s ]
select * from shop_config where code='currency_format' [ RunTime:0.003183s ]
select * from shop_config where code='currency_format' [ RunTime:0.003143s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 24 and is_main=1 [ RunTime:0.003196s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 24 and is_main2=1 [ RunTime:0.003189s ]
select sum(num) as num from goods_buy_log where goods_id='23' [ RunTime:0.003253s ]
select * from shop_config where code='currency_format' [ RunTime:0.003195s ]
select * from shop_config where code='currency_format' [ RunTime:0.003170s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 23 and is_main=1 [ RunTime:0.003176s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 23 and is_main2=1 [ RunTime:0.003251s ]
select sum(num) as num from goods_buy_log where goods_id='22' [ RunTime:0.003194s ]
select * from shop_config where code='currency_format' [ RunTime:0.003225s ]
select * from shop_config where code='currency_format' [ RunTime:0.003158s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 22 and is_main=1 [ RunTime:0.003175s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 22 and is_main2=1 [ RunTime:0.003229s ]
select sum(num) as num from goods_buy_log where goods_id='14' [ RunTime:0.003225s ]
select * from shop_config where code='currency_format' [ RunTime:0.003169s ]
select * from shop_config where code='currency_format' [ RunTime:0.003169s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 14 and is_main=1 [ RunTime:0.003209s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 14 and is_main2=1 [ RunTime:0.003156s ]
select sum(num) as num from goods_buy_log where goods_id='13' [ RunTime:0.003192s ]
select * from shop_config where code='currency_format' [ RunTime:0.003116s ]
select * from shop_config where code='currency_format' [ RunTime:0.003148s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 13 and is_main=1 [ RunTime:0.003233s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 13 and is_main2=1 [ RunTime:0.003184s ]
select sum(num) as num from goods_buy_log where goods_id='12' [ RunTime:0.003191s ]
select * from shop_config where code='currency_format' [ RunTime:0.003137s ]
select * from shop_config where code='currency_format' [ RunTime:0.003138s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 12 and is_main=1 [ RunTime:0.003210s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 12 and is_main2=1 [ RunTime:0.003193s ]
select sum(num) as num from goods_buy_log where goods_id='11' [ RunTime:0.003211s ]
select * from shop_config where code='currency_format' [ RunTime:0.003154s ]
select * from shop_config where code='currency_format' [ RunTime:0.003173s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 11 and is_main=1 [ RunTime:0.003214s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 11 and is_main2=1 [ RunTime:0.003217s ]
select sum(num) as num from goods_buy_log where goods_id='10' [ RunTime:0.003216s ]
select * from shop_config where code='currency_format' [ RunTime:0.003187s ]
select * from shop_config where code='currency_format' [ RunTime:0.003186s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 10 and is_main=1 [ RunTime:0.003231s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 10 and is_main2=1 [ RunTime:0.003275s ]
select sum(num) as num from goods_buy_log where goods_id='9' [ RunTime:0.003438s ]
select * from shop_config where code='currency_format' [ RunTime:0.003201s ]
select * from shop_config where code='currency_format' [ RunTime:0.003179s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 9 and is_main=1 [ RunTime:0.003236s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 9 and is_main2=1 [ RunTime:0.003257s ]
select sum(num) as num from goods_buy_log where goods_id='8' [ RunTime:0.003245s ]
select * from shop_config where code='currency_format' [ RunTime:0.003175s ]
select * from shop_config where code='currency_format' [ RunTime:0.003146s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 8 and is_main=1 [ RunTime:0.003257s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 8 and is_main2=1 [ RunTime:0.003273s ]
select sum(num) as num from goods_buy_log where goods_id='7' [ RunTime:0.003222s ]
select * from shop_config where code='currency_format' [ RunTime:0.003209s ]
select * from shop_config where code='currency_format' [ RunTime:0.003229s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 7 and is_main=1 [ RunTime:0.003152s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 7 and is_main2=1 [ RunTime:0.003305s ]
select sum(num) as num from goods_buy_log where goods_id='6' [ RunTime:0.003212s ]
select * from shop_config where code='currency_format' [ RunTime:0.003177s ]
select * from shop_config where code='currency_format' [ RunTime:0.003191s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 6 and is_main=1 [ RunTime:0.003166s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 6 and is_main2=1 [ RunTime:0.003189s ]
select sum(num) as num from goods_buy_log where goods_id='5' [ RunTime:0.003178s ]
select * from shop_config where code='currency_format' [ RunTime:0.003228s ]
select * from shop_config where code='currency_format' [ RunTime:0.003230s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 5 and is_main=1 [ RunTime:0.003276s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 5 and is_main2=1 [ RunTime:0.003220s ]
select sum(num) as num from goods_buy_log where goods_id='4' [ RunTime:0.003211s ]
select * from shop_config where code='currency_format' [ RunTime:0.003238s ]
select * from shop_config where code='currency_format' [ RunTime:0.003151s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 4 and is_main=1 [ RunTime:0.003204s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 4 and is_main2=1 [ RunTime:0.003355s ]
select sum(num) as num from goods_buy_log where goods_id='1' [ RunTime:0.003237s ]
select * from shop_config where code='currency_format' [ RunTime:0.003155s ]
select * from shop_config where code='currency_format' [ RunTime:0.003190s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 1 and is_main=1 [ RunTime:0.003227s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 1 and is_main2=1 [ RunTime:0.003229s ]
SELECT id,keywords,cat_desc,parent_id FROM cat WHERE id='1' LIMIT 1 [ RunTime:0.003247s ]
