select id,url_name from article where url_name !='' [ RunTime:0.003512s ]
select id,url_name from article where url_name !='' [ RunTime:0.003306s ]
select * from sys_pc_pages where flag='foot_help' [ RunTime:0.003464s ]
select id,title from article where cat_id=4 and is_open=1 limit 0,7 [ RunTime:0.003346s ]
select id,url_name from article where id='7' [ RunTime:0.003200s ]
select * from article_cat where id='4' [ RunTime:0.003328s ]
select id,title from article where cat_id=7 and is_open=1 limit 0,7 [ RunTime:0.003355s ]
select id,url_name from article where id='9' [ RunTime:0.003242s ]
select id,url_name from article where id='12' [ RunTime:0.003205s ]
select * from article_cat where id='7' [ RunTime:0.003196s ]
select id,title from article where cat_id=5 and is_open=1 limit 0,7 [ RunTime:0.003258s ]
select id,url_name from article where id='8' [ RunTime:0.003148s ]
select * from article_cat where id='5' [ RunTime:0.003225s ]
select * from friend_link order by sort_order desc limit 0,5 [ RunTime:0.003292s ]
select * from sys_pc_pages where flag='header_nav' [ RunTime:0.003288s ]
select * from cat where parent_id='33' and is_show=1 order by sort_order asc [ RunTime:0.003358s ]
select * from cat where parent_id='1' and is_show=1 order by sort_order asc [ RunTime:0.003362s ]
select * from cat where parent_id='26' and is_show=1 order by sort_order asc [ RunTime:0.003211s ]
select * from cat where parent_id='27' and is_show=1 order by sort_order asc [ RunTime:0.003250s ]
select * from cat where parent_id='59' and is_show=1 order by sort_order asc [ RunTime:0.003245s ]
select * from cat where parent_id='23' and is_show=1 order by sort_order asc [ RunTime:0.003248s ]
select * from cat where parent_id='28' and is_show=1 order by sort_order asc [ RunTime:0.003237s ]
select * from cat where parent_id='29' and is_show=1 order by sort_order asc [ RunTime:0.003238s ]
select * from cat where parent_id='30' and is_show=1 order by sort_order asc [ RunTime:0.003241s ]
select * from cat where parent_id='13' and is_show=1 order by sort_order asc [ RunTime:0.003187s ]
select * from cat where parent_id='25' and is_show=1 order by sort_order asc [ RunTime:0.003213s ]
select * from cat where parent_id='58' and is_show=1 order by sort_order asc [ RunTime:0.003248s ]
select * from cat where parent_id='2' and is_show=1 order by sort_order asc [ RunTime:0.003307s ]
select * from cat where parent_id='5' and is_show=1 order by sort_order asc [ RunTime:0.003350s ]
select * from cat where parent_id='10' and is_show=1 order by sort_order asc [ RunTime:0.003232s ]
select * from cat where parent_id='11' and is_show=1 order by sort_order asc [ RunTime:0.003283s ]
select * from cat where parent_id='12' and is_show=1 order by sort_order asc [ RunTime:0.003240s ]
select * from cat where parent_id='22' and is_show=1 order by sort_order asc [ RunTime:0.003246s ]
select * from cat where parent_id='32' and is_show=1 order by sort_order asc [ RunTime:0.003257s ]
select * from cat where parent_id='51' and is_show=1 order by sort_order asc [ RunTime:0.003238s ]
select * from cat where parent_id='52' and is_show=1 order by sort_order asc [ RunTime:0.003196s ]
select * from cat where parent_id='3' and is_show=1 order by sort_order asc [ RunTime:0.003261s ]
select * from cat where parent_id='15' and is_show=1 order by sort_order asc [ RunTime:0.003252s ]
select * from cat where parent_id='14' and is_show=1 order by sort_order asc [ RunTime:0.003222s ]
select * from cat where parent_id='4' and is_show=1 order by sort_order asc [ RunTime:0.003332s ]
select * from cat where parent_id='20' and is_show=1 order by sort_order asc [ RunTime:0.003297s ]
select * from cat where parent_id='21' and is_show=1 order by sort_order asc [ RunTime:0.003269s ]
select * from cat where parent_id='34' and is_show=1 order by sort_order asc [ RunTime:0.003348s ]
select * from cat where parent_id='35' and is_show=1 order by sort_order asc [ RunTime:0.003387s ]
select * from cat where parent_id='36' and is_show=1 order by sort_order asc [ RunTime:0.003281s ]
select * from cat where parent_id='37' and is_show=1 order by sort_order asc [ RunTime:0.003236s ]
select * from cat where parent_id='38' and is_show=1 order by sort_order asc [ RunTime:0.003232s ]
select * from cat where parent_id='39' and is_show=1 order by sort_order asc [ RunTime:0.003211s ]
select * from cat where parent_id='40' and is_show=1 order by sort_order asc [ RunTime:0.003230s ]
select * from cat where parent_id='41' and is_show=1 order by sort_order asc [ RunTime:0.003267s ]
select * from cat where parent_id='42' and is_show=1 order by sort_order asc [ RunTime:0.003245s ]
select * from cat where parent_id='43' and is_show=1 order by sort_order asc [ RunTime:0.003221s ]
select * from cat where parent_id='44' and is_show=1 order by sort_order asc [ RunTime:0.003278s ]
select * from cat where parent_id='45' and is_show=1 order by sort_order asc [ RunTime:0.003306s ]
select * from cat where parent_id='46' and is_show=1 order by sort_order asc [ RunTime:0.003293s ]
select * from cat where parent_id='55' and is_show=1 order by sort_order asc [ RunTime:0.003326s ]
select * from cat where parent_id='56' and is_show=1 order by sort_order asc [ RunTime:0.003219s ]
select * from cat where parent_id='57' and is_show=1 order by sort_order asc [ RunTime:0.003311s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003254s ]
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.003237s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '26' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003233s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '27' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003198s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '59' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003243s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '23' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003197s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '28' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003209s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '29' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003235s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '30' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003198s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '13' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003213s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '25' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003282s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '58' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003297s ]
select b.* from goods as g left join brand b on g.brand_id=b.id where g.cat_id IN ('1','26','27','59','23','28','29','30','13','25','58') and b.id >0 group by b.id [ RunTime:0.017971s ]
SELECT * FROM cat WHERE id='1' LIMIT 1 [ RunTime:0.003432s ]
select pic,parent_id from cat where id='1' [ RunTime:0.003220s ]
select pic,parent_id from cat where id='33' [ RunTime:0.003297s ]
select pic,parent_id from cat where id='0' [ RunTime:0.003239s ]
select pic,parent_id from cat where id='' [ RunTime:0.003165s ]
SELECT count(*) FROM cat WHERE parent_id = '0' [ RunTime:0.003250s ]
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.003302s ]
SELECT count(*) FROM cat WHERE parent_id = '33' AND is_show = 1 [ RunTime:0.003236s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '33' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003312s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003278s ]
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.003317s ]
SELECT count(*) FROM cat WHERE parent_id = '26' AND is_show = 1 [ RunTime:0.003240s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '26' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003252s ]
SELECT count(*) FROM cat WHERE parent_id = '27' AND is_show = 1 [ RunTime:0.003263s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '27' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003257s ]
SELECT count(*) FROM cat WHERE parent_id = '59' AND is_show = 1 [ RunTime:0.003205s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '59' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003256s ]
SELECT count(*) FROM cat WHERE parent_id = '23' AND is_show = 1 [ RunTime:0.003217s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '23' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003219s ]
SELECT count(*) FROM cat WHERE parent_id = '28' AND is_show = 1 [ RunTime:0.003311s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '28' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003337s ]
SELECT count(*) FROM cat WHERE parent_id = '29' AND is_show = 1 [ RunTime:0.003224s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '29' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003289s ]
SELECT count(*) FROM cat WHERE parent_id = '30' AND is_show = 1 [ RunTime:0.003257s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '30' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003242s ]
SELECT count(*) FROM cat WHERE parent_id = '13' AND is_show = 1 [ RunTime:0.003235s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '13' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003273s ]
SELECT count(*) FROM cat WHERE parent_id = '25' AND is_show = 1 [ RunTime:0.003252s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '25' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003236s ]
SELECT count(*) FROM cat WHERE parent_id = '58' AND is_show = 1 [ RunTime:0.003229s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '58' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003287s ]
SELECT count(*) FROM cat WHERE parent_id = '2' AND is_show = 1 [ RunTime:0.003282s ]
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.003339s ]
SELECT count(*) FROM cat WHERE parent_id = '5' AND is_show = 1 [ RunTime:0.003237s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '5' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003275s ]
SELECT count(*) FROM cat WHERE parent_id = '8' AND is_show = 1 [ RunTime:0.003274s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '8' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003225s ]
SELECT count(*) FROM cat WHERE parent_id = '9' AND is_show = 1 [ RunTime:0.003230s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '9' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003240s ]
SELECT count(*) FROM cat WHERE parent_id = '10' AND is_show = 1 [ RunTime:0.003226s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '10' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003488s ]
SELECT count(*) FROM cat WHERE parent_id = '11' AND is_show = 1 [ RunTime:0.003811s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '11' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003412s ]
SELECT count(*) FROM cat WHERE parent_id = '12' AND is_show = 1 [ RunTime:0.003666s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '12' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003525s ]
SELECT count(*) FROM cat WHERE parent_id = '22' AND is_show = 1 [ RunTime:0.003588s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '22' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003233s ]
SELECT count(*) FROM cat WHERE parent_id = '32' AND is_show = 1 [ RunTime:0.003217s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '32' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003213s ]
SELECT count(*) FROM cat WHERE parent_id = '51' AND is_show = 1 [ RunTime:0.003147s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '51' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003171s ]
SELECT count(*) FROM cat WHERE parent_id = '52' AND is_show = 1 [ RunTime:0.003257s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '52' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003917s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003323s ]
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.003226s ]
SELECT count(*) FROM cat WHERE parent_id = '15' AND is_show = 1 [ RunTime:0.003351s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '15' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003196s ]
SELECT count(*) FROM cat WHERE parent_id = '14' AND is_show = 1 [ RunTime:0.003188s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '14' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003204s ]
SELECT count(*) FROM cat WHERE parent_id = '4' AND is_show = 1 [ RunTime:0.003288s ]
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.003277s ]
SELECT count(*) FROM cat WHERE parent_id = '20' AND is_show = 1 [ RunTime:0.003200s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '20' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003205s ]
SELECT count(*) FROM cat WHERE parent_id = '21' AND is_show = 1 [ RunTime:0.003198s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '21' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003251s ]
SELECT count(*) FROM cat WHERE parent_id = '34' AND is_show = 1 [ RunTime:0.003240s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '34' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003265s ]
SELECT count(*) FROM cat WHERE parent_id = '35' AND is_show = 1 [ RunTime:0.003248s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '35' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003207s ]
SELECT count(*) FROM cat WHERE parent_id = '36' AND is_show = 1 [ RunTime:0.003231s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '36' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003227s ]
SELECT count(*) FROM cat WHERE parent_id = '37' AND is_show = 1 [ RunTime:0.003248s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '37' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003227s ]
SELECT count(*) FROM cat WHERE parent_id = '38' AND is_show = 1 [ RunTime:0.003191s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '38' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003258s ]
SELECT count(*) FROM cat WHERE parent_id = '39' AND is_show = 1 [ RunTime:0.003233s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '39' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003226s ]
SELECT count(*) FROM cat WHERE parent_id = '40' AND is_show = 1 [ RunTime:0.003245s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '40' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003210s ]
SELECT count(*) FROM cat WHERE parent_id = '41' AND is_show = 1 [ RunTime:0.003241s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '41' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003258s ]
SELECT count(*) FROM cat WHERE parent_id = '42' AND is_show = 1 [ RunTime:0.003322s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '42' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003180s ]
SELECT count(*) FROM cat WHERE parent_id = '43' AND is_show = 1 [ RunTime:0.003258s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '43' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003208s ]
SELECT count(*) FROM cat WHERE parent_id = '44' AND is_show = 1 [ RunTime:0.003186s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '44' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003264s ]
SELECT count(*) FROM cat WHERE parent_id = '45' AND is_show = 1 [ RunTime:0.003208s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '45' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003315s ]
SELECT count(*) FROM cat WHERE parent_id = '46' AND is_show = 1 [ RunTime:0.004880s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '46' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003966s ]
SELECT count(*) FROM cat WHERE parent_id = '55' AND is_show = 1 [ RunTime:0.003213s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '55' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003254s ]
SELECT count(*) FROM cat WHERE parent_id = '56' AND is_show = 1 [ RunTime:0.003232s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '56' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003215s ]
SELECT count(*) FROM cat WHERE parent_id = '57' AND is_show = 1 [ RunTime:0.003533s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '57' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003207s ]
SELECT count(*) FROM cat WHERE parent_id = '1' [ RunTime:0.003224s ]
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.003296s ]
SELECT count(*) FROM cat WHERE parent_id = '26' AND is_show = 1 [ RunTime:0.003224s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '26' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003221s ]
SELECT count(*) FROM cat WHERE parent_id = '27' AND is_show = 1 [ RunTime:0.003179s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '27' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003220s ]
SELECT count(*) FROM cat WHERE parent_id = '59' AND is_show = 1 [ RunTime:0.003209s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '59' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003230s ]
SELECT count(*) FROM cat WHERE parent_id = '23' AND is_show = 1 [ RunTime:0.003215s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '23' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003189s ]
SELECT count(*) FROM cat WHERE parent_id = '28' AND is_show = 1 [ RunTime:0.003223s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '28' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003271s ]
SELECT count(*) FROM cat WHERE parent_id = '29' AND is_show = 1 [ RunTime:0.003180s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '29' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003176s ]
SELECT count(*) FROM cat WHERE parent_id = '30' AND is_show = 1 [ RunTime:0.003222s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '30' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003652s ]
SELECT count(*) FROM cat WHERE parent_id = '13' AND is_show = 1 [ RunTime:0.003211s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '13' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003193s ]
SELECT count(*) FROM cat WHERE parent_id = '25' AND is_show = 1 [ RunTime:0.003179s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '25' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003294s ]
SELECT count(*) FROM cat WHERE parent_id = '58' AND is_show = 1 [ RunTime:0.003167s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '58' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003223s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003178s ]
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.003275s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '26' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003221s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '27' 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 = '59' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003187s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '23' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003211s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '28' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003349s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '29' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003233s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '30' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003214s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '13' 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 = '25' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003199s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '58' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003240s ]
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','26','27','59','23','28','29','30','13','25','58') and attr.is_linked=1 GROUP BY a.attr_id,a.attr_value [ RunTime:0.003597s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003271s ]
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.003316s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '26' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003224s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '27' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003192s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '59' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003227s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '23' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003182s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '28' 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 = '29' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003228s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '30' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003231s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '13' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003185s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '25' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003247s ]
SELECT id, cat_name, parent_id, is_show FROM cat WHERE parent_id = '58' AND is_show = 1 ORDER BY sort_order ASC, id ASC [ RunTime:0.003217s ]
SELECT goods_id FROM goods_cat AS g WHERE g.cat_id IN ('1','26','27','59','23','28','29','30','13','25','58') [ RunTime:0.003363s ]
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','26','27','59','23','28','29','30','13','25','58') OR g.id IN ('') ) [ RunTime:0.011386s ]
SELECT g.id as goods_id, g.goods_name,g.goods_number, 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','26','27','59','23','28','29','30','13','25','58') OR g.id IN ('') ) ORDER BY g.id desc limit 0, 24 [ RunTime:0.017295s ]
select sum(num) as num from goods_buy_log where goods_id='8957' [ RunTime:0.003418s ]
select * from shop_config where code='currency_format' [ RunTime:0.003252s ]
select * from fa_type [ RunTime:0.003170s ]
select * from shop_config where code='currency_format' [ RunTime:0.003188s ]
select * from fa_type [ RunTime:0.003220s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8957 and is_main=1 [ RunTime:0.003348s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8957 and is_main2=1 [ RunTime:0.003288s ]
select sum(num) as num from goods_buy_log where goods_id='8956' [ RunTime:0.003262s ]
select * from shop_config where code='currency_format' [ RunTime:0.003222s ]
select * from fa_type [ RunTime:0.003218s ]
select * from shop_config where code='currency_format' [ RunTime:0.003214s ]
select * from fa_type [ RunTime:0.003190s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8956 and is_main=1 [ RunTime:0.003247s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8956 and is_main2=1 [ RunTime:0.003365s ]
select sum(num) as num from goods_buy_log where goods_id='8954' [ RunTime:0.003320s ]
select * from shop_config where code='currency_format' [ RunTime:0.003221s ]
select * from fa_type [ RunTime:0.003210s ]
select * from shop_config where code='currency_format' [ RunTime:0.003238s ]
select * from fa_type [ RunTime:0.003203s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8954 and is_main=1 [ RunTime:0.003323s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8954 and is_main2=1 [ RunTime:0.003335s ]
select sum(num) as num from goods_buy_log where goods_id='8952' [ RunTime:0.003315s ]
select * from shop_config where code='currency_format' [ RunTime:0.003307s ]
select * from fa_type [ RunTime:0.003228s ]
select * from shop_config where code='currency_format' [ RunTime:0.003235s ]
select * from fa_type [ RunTime:0.003173s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8952 and is_main=1 [ RunTime:0.003266s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8952 and is_main2=1 [ RunTime:0.003266s ]
select sum(num) as num from goods_buy_log where goods_id='8951' [ RunTime:0.003233s ]
select * from shop_config where code='currency_format' [ RunTime:0.003195s ]
select * from fa_type [ RunTime:0.003201s ]
select * from shop_config where code='currency_format' [ RunTime:0.003202s ]
select * from fa_type [ RunTime:0.003166s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8951 and is_main=1 [ RunTime:0.003293s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8951 and is_main2=1 [ RunTime:0.003298s ]
select sum(num) as num from goods_buy_log where goods_id='8949' [ RunTime:0.003806s ]
select * from shop_config where code='currency_format' [ RunTime:0.003281s ]
select * from fa_type [ RunTime:0.003149s ]
select * from shop_config where code='currency_format' [ RunTime:0.003182s ]
select * from fa_type [ RunTime:0.003179s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8949 and is_main=1 [ RunTime:0.003280s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8949 and is_main2=1 [ RunTime:0.003289s ]
select sum(num) as num from goods_buy_log where goods_id='8948' [ RunTime:0.003228s ]
select * from shop_config where code='currency_format' [ RunTime:0.003211s ]
select * from fa_type [ RunTime:0.003172s ]
select * from shop_config where code='currency_format' [ RunTime:0.003234s ]
select * from fa_type [ RunTime:0.003184s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8948 and is_main=1 [ RunTime:0.003269s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8948 and is_main2=1 [ RunTime:0.003235s ]
select sum(num) as num from goods_buy_log where goods_id='8947' [ RunTime:0.003335s ]
select * from shop_config where code='currency_format' [ RunTime:0.003234s ]
select * from fa_type [ RunTime:0.003205s ]
select * from shop_config where code='currency_format' [ RunTime:0.003201s ]
select * from fa_type [ RunTime:0.003153s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8947 and is_main=1 [ RunTime:0.003301s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8947 and is_main2=1 [ RunTime:0.003232s ]
select sum(num) as num from goods_buy_log where goods_id='8946' [ RunTime:0.003242s ]
select * from shop_config where code='currency_format' [ RunTime:0.003183s ]
select * from fa_type [ RunTime:0.003159s ]
select * from shop_config where code='currency_format' [ RunTime:0.003213s ]
select * from fa_type [ RunTime:0.003150s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8946 and is_main=1 [ RunTime:0.003290s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8946 and is_main2=1 [ RunTime:0.003298s ]
select sum(num) as num from goods_buy_log where goods_id='8945' [ RunTime:0.003296s ]
select * from shop_config where code='currency_format' [ RunTime:0.003294s ]
select * from fa_type [ RunTime:0.003181s ]
select * from shop_config where code='currency_format' [ RunTime:0.003196s ]
select * from fa_type [ RunTime:0.003135s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8945 and is_main=1 [ RunTime:0.012738s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8945 and is_main2=1 [ RunTime:0.003359s ]
select sum(num) as num from goods_buy_log where goods_id='8944' [ RunTime:0.003292s ]
select * from shop_config where code='currency_format' [ RunTime:0.003223s ]
select * from fa_type [ RunTime:0.003168s ]
select * from shop_config where code='currency_format' [ RunTime:0.003209s ]
select * from fa_type [ RunTime:0.003151s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8944 and is_main=1 [ RunTime:0.003321s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8944 and is_main2=1 [ RunTime:0.003346s ]
select sum(num) as num from goods_buy_log where goods_id='8942' [ RunTime:0.003223s ]
select * from shop_config where code='currency_format' [ RunTime:0.003180s ]
select * from fa_type [ RunTime:0.003162s ]
select * from shop_config where code='currency_format' [ RunTime:0.003135s ]
select * from fa_type [ RunTime:0.003130s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8942 and is_main=1 [ RunTime:0.003432s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8942 and is_main2=1 [ RunTime:0.003263s ]
select sum(num) as num from goods_buy_log where goods_id='8940' [ RunTime:0.003301s ]
select * from shop_config where code='currency_format' [ RunTime:0.003215s ]
select * from fa_type [ RunTime:0.003327s ]
select * from shop_config where code='currency_format' [ RunTime:0.003235s ]
select * from fa_type [ RunTime:0.003425s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8940 and is_main=1 [ RunTime:0.003352s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8940 and is_main2=1 [ RunTime:0.003249s ]
select sum(num) as num from goods_buy_log where goods_id='8939' [ RunTime:0.003250s ]
select * from shop_config where code='currency_format' [ RunTime:0.003204s ]
select * from fa_type [ RunTime:0.003183s ]
select * from shop_config where code='currency_format' [ RunTime:0.003208s ]
select * from fa_type [ RunTime:0.003167s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8939 and is_main=1 [ RunTime:0.003281s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8939 and is_main2=1 [ RunTime:0.003291s ]
select sum(num) as num from goods_buy_log where goods_id='8938' [ RunTime:0.003260s ]
select * from shop_config where code='currency_format' [ RunTime:0.003170s ]
select * from fa_type [ RunTime:0.003202s ]
select * from shop_config where code='currency_format' [ RunTime:0.003239s ]
select * from fa_type [ RunTime:0.003201s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8938 and is_main=1 [ RunTime:0.003308s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8938 and is_main2=1 [ RunTime:0.003290s ]
select sum(num) as num from goods_buy_log where goods_id='8937' [ RunTime:0.003282s ]
select * from shop_config where code='currency_format' [ RunTime:0.003252s ]
select * from fa_type [ RunTime:0.003247s ]
select * from shop_config where code='currency_format' [ RunTime:0.003295s ]
select * from fa_type [ RunTime:0.003252s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8937 and is_main=1 [ RunTime:0.003328s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8937 and is_main2=1 [ RunTime:0.003244s ]
select sum(num) as num from goods_buy_log where goods_id='8936' [ RunTime:0.003273s ]
select * from shop_config where code='currency_format' [ RunTime:0.003217s ]
select * from fa_type [ RunTime:0.003181s ]
select * from shop_config where code='currency_format' [ RunTime:0.003384s ]
select * from fa_type [ RunTime:0.003190s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8936 and is_main=1 [ RunTime:0.003263s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8936 and is_main2=1 [ RunTime:0.003236s ]
select sum(num) as num from goods_buy_log where goods_id='8935' [ RunTime:0.003323s ]
select * from shop_config where code='currency_format' [ RunTime:0.003215s ]
select * from fa_type [ RunTime:0.003165s ]
select * from shop_config where code='currency_format' [ RunTime:0.003152s ]
select * from fa_type [ RunTime:0.003179s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8935 and is_main=1 [ RunTime:0.003252s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8935 and is_main2=1 [ RunTime:0.003269s ]
select sum(num) as num from goods_buy_log where goods_id='8934' [ RunTime:0.003252s ]
select * from shop_config where code='currency_format' [ RunTime:0.003198s ]
select * from fa_type [ RunTime:0.003158s ]
select * from shop_config where code='currency_format' [ RunTime:0.003245s ]
select * from fa_type [ RunTime:0.003180s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8934 and is_main=1 [ RunTime:0.003324s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8934 and is_main2=1 [ RunTime:0.003354s ]
select sum(num) as num from goods_buy_log where goods_id='8933' [ RunTime:0.003348s ]
select * from shop_config where code='currency_format' [ RunTime:0.003278s ]
select * from fa_type [ RunTime:0.003256s ]
select * from shop_config where code='currency_format' [ RunTime:0.003273s ]
select * from fa_type [ RunTime:0.003191s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8933 and is_main=1 [ RunTime:0.003360s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8933 and is_main2=1 [ RunTime:0.003472s ]
select sum(num) as num from goods_buy_log where goods_id='8932' [ RunTime:0.003389s ]
select * from shop_config where code='currency_format' [ RunTime:0.003210s ]
select * from fa_type [ RunTime:0.003246s ]
select * from shop_config where code='currency_format' [ RunTime:0.003228s ]
select * from fa_type [ RunTime:0.003201s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8932 and is_main=1 [ RunTime:0.003278s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8932 and is_main2=1 [ RunTime:0.003279s ]
select sum(num) as num from goods_buy_log where goods_id='8931' [ RunTime:0.003273s ]
select * from shop_config where code='currency_format' [ RunTime:0.003232s ]
select * from fa_type [ RunTime:0.003211s ]
select * from shop_config where code='currency_format' [ RunTime:0.003259s ]
select * from fa_type [ RunTime:0.003201s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8931 and is_main=1 [ RunTime:0.003327s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8931 and is_main2=1 [ RunTime:0.003302s ]
select sum(num) as num from goods_buy_log where goods_id='8930' [ RunTime:0.003245s ]
select * from shop_config where code='currency_format' [ RunTime:0.003158s ]
select * from fa_type [ RunTime:0.003234s ]
select * from shop_config where code='currency_format' [ RunTime:0.003328s ]
select * from fa_type [ RunTime:0.003187s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8930 and is_main=1 [ RunTime:0.003312s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8930 and is_main2=1 [ RunTime:0.003308s ]
select sum(num) as num from goods_buy_log where goods_id='8929' [ RunTime:0.003351s ]
select * from shop_config where code='currency_format' [ RunTime:0.003279s ]
select * from fa_type [ RunTime:0.003165s ]
select * from shop_config where code='currency_format' [ RunTime:0.003292s ]
select * from fa_type [ RunTime:0.003132s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8929 and is_main=1 [ RunTime:0.003637s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8929 and is_main2=1 [ RunTime:0.003360s ]
SELECT id,keywords,cat_desc,parent_id FROM cat WHERE id='1' LIMIT 1 [ RunTime:0.003471s ]
SELECT id,keywords,cat_desc,parent_id FROM cat WHERE id='33' LIMIT 1 [ RunTime:0.003341s ]