SELECT UPPER(`type`) AS `type`, UPPER(`name`) AS `name`, `expire` FROM sys_cache_expires [ RunTime:0.003517s ]
select id,url_name from article where url_name !='' [ RunTime:0.003222s ]
select id,url_name from article where url_name !='' [ RunTime:0.003253s ]
select * from sys_pc_pages where flag='foot_help' [ RunTime:0.003336s ]
select id,title from article where cat_id=4 and is_open=1 limit 0,7 [ RunTime:0.003268s ]
select id,url_name from article where id='6' [ RunTime:0.003117s ]
select * from article_cat where id='4' [ RunTime:0.003174s ]
select id,title from article where cat_id=7 and is_open=1 limit 0,7 [ RunTime:0.003252s ]
select id,url_name from article where id='8' [ RunTime:0.003175s ]
select id,url_name from article where id='11' [ RunTime:0.003239s ]
select * from article_cat where id='7' [ RunTime:0.003199s ]
select id,title from article where cat_id=5 and is_open=1 limit 0,7 [ RunTime:0.003264s ]
select id,url_name from article where id='13' [ RunTime:0.003106s ]
select id,url_name from article where id='15' [ RunTime:0.003153s ]
select id,url_name from article where id='17' [ RunTime:0.003129s ]
select * from article_cat where id='5' [ RunTime:0.003176s ]
select * from friend_link order by sort_order desc limit 0,5 [ RunTime:0.003252s ]
select * from sys_pc_pages where flag='header_nav' [ RunTime:0.003243s ]
select * from cat where parent_id='1' order by sort_order asc [ RunTime:0.003216s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003281s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003248s ]
select * from cat where parent_id='2' order by sort_order asc [ RunTime:0.003181s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003174s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.003234s ]
select * from cat where parent_id='3' order by sort_order asc [ RunTime:0.003213s ]
select * from cat where parent_id='4' order by sort_order asc [ RunTime:0.003214s ]
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 = '4' and g.is_delete = 0 and g.is_on_sale = 1 GROUP BY g.cat_id [ RunTime:0.003544s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003279s ]
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.003237s ]
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.003206s ]
SELECT goods_id FROM goods_cat AS g WHERE g.cat_id IN ('3','4') [ RunTime:0.003164s ]
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 ('3','4') OR g.id IN ('') ) AND g.brand_id IN ('4') [ RunTime:0.003316s ]
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 ('3','4') OR g.id IN ('') ) AND g.brand_id IN ('4') ORDER BY g.id desc limit 0, 24 [ RunTime:0.003394s ]
select sum(num) as num from goods_buy_log where goods_id='33' [ RunTime:0.003227s ]
select * from shop_config where code='currency_format' [ RunTime:0.003181s ]
select * from shop_config where code='currency_format' [ RunTime:0.003331s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 33 and is_main=1 [ RunTime:0.003260s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 33 and is_main2=1 [ RunTime:0.003226s ]
select sum(num) as num from goods_buy_log where goods_id='27' [ RunTime:0.003189s ]
select * from shop_config where code='currency_format' [ RunTime:0.003214s ]
select * from shop_config where code='currency_format' [ RunTime:0.003124s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 27 and is_main=1 [ RunTime:0.003166s ]
select goods_id,big_url,middle_url,thumb_url from goods_images where goods_id = 27 and is_main2=1 [ RunTime:0.003249s ]
select * from brand where id='4' [ RunTime:0.003235s ]
SELECT id, cat_name, parent_id FROM cat [ RunTime:0.003186s ]
