SELECT UPPER(`type`) AS `type`, UPPER(`name`) AS `name`, `expire` FROM sys_cache_expires [ RunTime:0.003323s ]
select id,url_name from article where url_name !='' [ RunTime:0.003179s ]
select id,url_name from article where url_name !='' [ RunTime:0.003126s ]
select * from sys_pc_pages where flag='foot_help' [ RunTime:0.003150s ]
select id,title from article where cat_id=4 and is_open=1 limit 0,7 [ RunTime:0.003088s ]
select id,url_name from article where id='6' [ RunTime:0.002989s ]
select * from article_cat where id='4' [ RunTime:0.003003s ]
select id,title from article where cat_id=7 and is_open=1 limit 0,7 [ RunTime:0.003026s ]
select id,url_name from article where id='8' [ RunTime:0.003009s ]
select id,url_name from article where id='11' [ RunTime:0.002969s ]
select * from article_cat where id='7' [ RunTime:0.002976s ]
select id,title from article where cat_id=5 and is_open=1 limit 0,7 [ RunTime:0.003100s ]
select id,url_name from article where id='13' [ RunTime:0.003071s ]
select id,url_name from article where id='15' [ RunTime:0.002989s ]
select id,url_name from article where id='17' [ RunTime:0.003043s ]
select * from article_cat where id='5' [ RunTime:0.003004s ]
select * from friend_link order by sort_order desc limit 0,5 [ RunTime:0.003069s ]
select * from sys_pc_pages where flag='header_nav' [ RunTime:0.003064s ]
select * from cat where parent_id='1' order by sort_order asc [ RunTime:0.003081s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003050s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003023s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003060s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003009s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.003096s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003034s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.003016s ]
SELECT c.id, c.cat_name, COUNT(g.id) AS goods_count
FROM goods g left join cat c on g.cat_id=c.id WHERE g.brand_id = '27' and g.is_delete = 0 and g.is_on_sale = 1 GROUP BY g.cat_id [ RunTime:0.003319s ]
SELECT count(*) as total_num FROM goods AS g WHERE g.is_on_sale = 1 AND g.brand_id IN ('27') [ RunTime:0.003071s ]
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.brand_id IN ('27') ORDER BY g.id desc limit 0, 24 [ RunTime:0.003171s ]
select sum(num) as num from goods_buy_log where goods_id='29' [ RunTime:0.003045s ]
select * from shop_config where code='currency_format' [ RunTime:0.003024s ]
select * from shop_config where code='currency_format' [ RunTime:0.003040s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 29 and is_main=1 [ RunTime:0.003045s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 29 and is_main2=1 [ RunTime:0.003070s ]
select sum(num) as num from goods_buy_log where goods_id='26' [ RunTime:0.002997s ]
select * from shop_config where code='currency_format' [ RunTime:0.002998s ]
select * from shop_config where code='currency_format' [ RunTime:0.003010s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 26 and is_main=1 [ RunTime:0.003045s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 26 and is_main2=1 [ RunTime:0.003041s ]
select sum(num) as num from goods_buy_log where goods_id='25' [ RunTime:0.003102s ]
select * from shop_config where code='currency_format' [ RunTime:0.003028s ]
select * from shop_config where code='currency_format' [ RunTime:0.002983s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 25 and is_main=1 [ RunTime:0.003041s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 25 and is_main2=1 [ RunTime:0.003023s ]
select sum(num) as num from goods_buy_log where goods_id='23' [ RunTime:0.003022s ]
select * from shop_config where code='currency_format' [ RunTime:0.002994s ]
select * from shop_config where code='currency_format' [ RunTime:0.003043s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 23 and is_main=1 [ RunTime:0.002987s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 23 and is_main2=1 [ RunTime:0.003060s ]
select sum(num) as num from goods_buy_log where goods_id='22' [ RunTime:0.003069s ]
select * from shop_config where code='currency_format' [ RunTime:0.002962s ]
select * from shop_config where code='currency_format' [ RunTime:0.003007s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 22 and is_main=1 [ RunTime:0.003016s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 22 and is_main2=1 [ RunTime:0.003009s ]
select sum(num) as num from goods_buy_log where goods_id='17' [ RunTime:0.002993s ]
select * from shop_config where code='currency_format' [ RunTime:0.002947s ]
select * from shop_config where code='currency_format' [ RunTime:0.002974s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 17 and is_main=1 [ RunTime:0.002999s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 17 and is_main2=1 [ RunTime:0.003019s ]
select sum(num) as num from goods_buy_log where goods_id='14' [ RunTime:0.002972s ]
select * from shop_config where code='currency_format' [ RunTime:0.002993s ]
select * from shop_config where code='currency_format' [ RunTime:0.003029s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 14 and is_main=1 [ RunTime:0.003023s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 14 and is_main2=1 [ RunTime:0.003001s ]
select sum(num) as num from goods_buy_log where goods_id='12' [ RunTime:0.003011s ]
select * from shop_config where code='currency_format' [ RunTime:0.002999s ]
select * from shop_config where code='currency_format' [ RunTime:0.003008s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 12 and is_main=1 [ RunTime:0.003067s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 12 and is_main2=1 [ RunTime:0.003060s ]
select sum(num) as num from goods_buy_log where goods_id='8' [ RunTime:0.003046s ]
select * from shop_config where code='currency_format' [ RunTime:0.003026s ]
select * from shop_config where code='currency_format' [ RunTime:0.003010s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 8 and is_main=1 [ RunTime:0.003013s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 8 and is_main2=1 [ RunTime:0.002999s ]
select sum(num) as num from goods_buy_log where goods_id='5' [ RunTime:0.003032s ]
select * from shop_config where code='currency_format' [ RunTime:0.003015s ]
select * from shop_config where code='currency_format' [ RunTime:0.003032s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 5 and is_main=1 [ RunTime:0.003057s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 5 and is_main2=1 [ RunTime:0.003057s ]
select sum(num) as num from goods_buy_log where goods_id='3' [ RunTime:0.003020s ]
select * from shop_config where code='currency_format' [ RunTime:0.003036s ]
select * from shop_config where code='currency_format' [ RunTime:0.003019s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 3 and is_main=1 [ RunTime:0.003103s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 3 and is_main2=1 [ RunTime:0.003039s ]
select sum(num) as num from goods_buy_log where goods_id='2' [ RunTime:0.003046s ]
select * from shop_config where code='currency_format' [ RunTime:0.003018s ]
select * from shop_config where code='currency_format' [ RunTime:0.003044s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 2 and is_main=1 [ RunTime:0.003050s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 2 and is_main2=1 [ RunTime:0.003023s ]
select * from brand where id='27' [ RunTime:0.003041s ]
