select id,url_name from article where url_name !='' [ RunTime:0.003627s ]
select id,url_name from article where url_name !='' [ RunTime:0.003423s ]
select * from sys_pc_pages where flag='foot_help' [ RunTime:0.003572s ]
select id,title from article where cat_id=4 and is_open=1 limit 0,7 [ RunTime:0.003399s ]
select id,url_name from article where id='7' [ RunTime:0.003304s ]
select * from article_cat where id='4' [ RunTime:0.003322s ]
select id,title from article where cat_id=7 and is_open=1 limit 0,7 [ RunTime:0.003333s ]
select id,url_name from article where id='9' [ RunTime:0.003298s ]
select id,url_name from article where id='12' [ RunTime:0.003308s ]
select * from article_cat where id='7' [ RunTime:0.003259s ]
select id,title from article where cat_id=5 and is_open=1 limit 0,7 [ RunTime:0.003298s ]
select id,url_name from article where id='8' [ RunTime:0.003252s ]
select * from article_cat where id='5' [ RunTime:0.003256s ]
select * from friend_link order by sort_order desc limit 0,5 [ RunTime:0.003386s ]
select * from sys_pc_pages where flag='header_nav' [ RunTime:0.003338s ]
select * from cat where parent_id='33' and is_show=1 order by sort_order asc [ RunTime:0.003387s ]
select * from cat where parent_id='1' and is_show=1 order by sort_order asc [ RunTime:0.003457s ]
select * from cat where parent_id='26' and is_show=1 order by sort_order asc [ RunTime:0.003308s ]
select * from cat where parent_id='27' and is_show=1 order by sort_order asc [ RunTime:0.003315s ]
select * from cat where parent_id='59' and is_show=1 order by sort_order asc [ RunTime:0.003311s ]
select * from cat where parent_id='23' and is_show=1 order by sort_order asc [ RunTime:0.003363s ]
select * from cat where parent_id='28' and is_show=1 order by sort_order asc [ RunTime:0.003331s ]
select * from cat where parent_id='29' and is_show=1 order by sort_order asc [ RunTime:0.003307s ]
select * from cat where parent_id='30' and is_show=1 order by sort_order asc [ RunTime:0.003369s ]
select * from cat where parent_id='13' and is_show=1 order by sort_order asc [ RunTime:0.003277s ]
select * from cat where parent_id='25' and is_show=1 order by sort_order asc [ RunTime:0.003392s ]
select * from cat where parent_id='58' and is_show=1 order by sort_order asc [ RunTime:0.003329s ]
select * from cat where parent_id='2' and is_show=1 order by sort_order asc [ RunTime:0.003343s ]
select * from cat where parent_id='5' and is_show=1 order by sort_order asc [ RunTime:0.003298s ]
select * from cat where parent_id='10' and is_show=1 order by sort_order asc [ RunTime:0.003295s ]
select * from cat where parent_id='11' and is_show=1 order by sort_order asc [ RunTime:0.003370s ]
select * from cat where parent_id='12' and is_show=1 order by sort_order asc [ RunTime:0.003336s ]
select * from cat where parent_id='22' and is_show=1 order by sort_order asc [ RunTime:0.003379s ]
select * from cat where parent_id='32' and is_show=1 order by sort_order asc [ RunTime:0.003325s ]
select * from cat where parent_id='51' and is_show=1 order by sort_order asc [ RunTime:0.003306s ]
select * from cat where parent_id='52' and is_show=1 order by sort_order asc [ RunTime:0.003369s ]
select * from cat where parent_id='3' and is_show=1 order by sort_order asc [ RunTime:0.003343s ]
select * from cat where parent_id='15' and is_show=1 order by sort_order asc [ RunTime:0.003306s ]
select * from cat where parent_id='14' and is_show=1 order by sort_order asc [ RunTime:0.003295s ]
select * from cat where parent_id='4' and is_show=1 order by sort_order asc [ RunTime:0.003419s ]
select * from cat where parent_id='20' and is_show=1 order by sort_order asc [ RunTime:0.003335s ]
select * from cat where parent_id='21' and is_show=1 order by sort_order asc [ RunTime:0.003286s ]
select * from cat where parent_id='34' and is_show=1 order by sort_order asc [ RunTime:0.003381s ]
select * from cat where parent_id='35' and is_show=1 order by sort_order asc [ RunTime:0.003394s ]
select * from cat where parent_id='36' and is_show=1 order by sort_order asc [ RunTime:0.003326s ]
select * from cat where parent_id='37' and is_show=1 order by sort_order asc [ RunTime:0.003397s ]
select * from cat where parent_id='38' and is_show=1 order by sort_order asc [ RunTime:0.003332s ]
select * from cat where parent_id='39' and is_show=1 order by sort_order asc [ RunTime:0.003355s ]
select * from cat where parent_id='40' and is_show=1 order by sort_order asc [ RunTime:0.003389s ]
select * from cat where parent_id='41' and is_show=1 order by sort_order asc [ RunTime:0.003349s ]
select * from cat where parent_id='42' and is_show=1 order by sort_order asc [ RunTime:0.003330s ]
select * from cat where parent_id='43' and is_show=1 order by sort_order asc [ RunTime:0.003298s ]
select * from cat where parent_id='44' and is_show=1 order by sort_order asc [ RunTime:0.003368s ]
select * from cat where parent_id='45' and is_show=1 order by sort_order asc [ RunTime:0.003348s ]
select * from cat where parent_id='46' and is_show=1 order by sort_order asc [ RunTime:0.003323s ]
select * from cat where parent_id='55' and is_show=1 order by sort_order asc [ RunTime:0.003321s ]
select * from cat where parent_id='56' and is_show=1 order by sort_order asc [ RunTime:0.003328s ]
select * from cat where parent_id='57' and is_show=1 order by sort_order asc [ RunTime:0.003373s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003364s ]
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.003355s ]
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.003326s ]
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.003418s ]
select b.* from goods as g left join brand b on g.brand_id=b.id where g.cat_id IN ('3','15','14') and b.id >0 group by b.id [ RunTime:0.007217s ]
SELECT id, cat_name, parent_id FROM cat [ RunTime:0.003344s ]
SELECT * FROM cat WHERE id='3' LIMIT 1 [ RunTime:0.003333s ]
select pic,parent_id from cat where id='3' [ RunTime:0.003264s ]
select pic,parent_id from cat where id='33' [ RunTime:0.003328s ]
select pic,parent_id from cat where id='0' [ RunTime:0.003295s ]
select pic,parent_id from cat where id='' [ RunTime:0.003243s ]
SELECT count(*) FROM cat WHERE parent_id = '0' [ RunTime:0.003307s ]
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.003358s ]
SELECT count(*) FROM cat WHERE parent_id = '33' AND is_show = 1 [ RunTime:0.003322s ]
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.003391s ]
SELECT count(*) FROM cat WHERE parent_id = '1' AND is_show = 1 [ RunTime:0.003320s ]
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.003312s ]
SELECT count(*) FROM cat WHERE parent_id = '26' AND is_show = 1 [ RunTime:0.003313s ]
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.003299s ]
SELECT count(*) FROM cat WHERE parent_id = '27' AND is_show = 1 [ RunTime:0.003378s ]
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.003298s ]
SELECT count(*) FROM cat WHERE parent_id = '59' AND is_show = 1 [ RunTime:0.003308s ]
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.003272s ]
SELECT count(*) FROM cat WHERE parent_id = '23' AND is_show = 1 [ RunTime:0.003252s ]
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.003316s ]
SELECT count(*) FROM cat WHERE parent_id = '28' AND is_show = 1 [ RunTime:0.003339s ]
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.003283s ]
SELECT count(*) FROM cat WHERE parent_id = '29' AND is_show = 1 [ RunTime:0.003312s ]
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.003332s ]
SELECT count(*) FROM cat WHERE parent_id = '30' AND is_show = 1 [ RunTime:0.003282s ]
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.003290s ]
SELECT count(*) FROM cat WHERE parent_id = '13' AND is_show = 1 [ RunTime:0.003317s ]
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.003361s ]
SELECT count(*) FROM cat WHERE parent_id = '25' AND is_show = 1 [ RunTime:0.003255s ]
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.003284s ]
SELECT count(*) FROM cat WHERE parent_id = '58' AND is_show = 1 [ RunTime:0.003239s ]
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.003303s ]
SELECT count(*) FROM cat WHERE parent_id = '2' AND is_show = 1 [ RunTime:0.003367s ]
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.003326s ]
SELECT count(*) FROM cat WHERE parent_id = '5' AND is_show = 1 [ RunTime:0.003313s ]
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.003300s ]
SELECT count(*) FROM cat WHERE parent_id = '8' AND is_show = 1 [ RunTime:0.003272s ]
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.003346s ]
SELECT count(*) FROM cat WHERE parent_id = '9' AND is_show = 1 [ RunTime:0.003352s ]
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.003355s ]
SELECT count(*) FROM cat WHERE parent_id = '10' AND is_show = 1 [ RunTime:0.003270s ]
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.003276s ]
SELECT count(*) FROM cat WHERE parent_id = '11' AND is_show = 1 [ RunTime:0.003325s ]
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.003336s ]
SELECT count(*) FROM cat WHERE parent_id = '12' AND is_show = 1 [ RunTime:0.003268s ]
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.003235s ]
SELECT count(*) FROM cat WHERE parent_id = '22' AND is_show = 1 [ RunTime:0.003334s ]
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.003297s ]
SELECT count(*) FROM cat WHERE parent_id = '32' AND is_show = 1 [ RunTime:0.003244s ]
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.003348s ]
SELECT count(*) FROM cat WHERE parent_id = '51' AND is_show = 1 [ RunTime:0.003283s ]
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.003318s ]
SELECT count(*) FROM cat WHERE parent_id = '52' AND is_show = 1 [ RunTime:0.003322s ]
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.003289s ]
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.003337s ]
SELECT count(*) FROM cat WHERE parent_id = '15' AND is_show = 1 [ RunTime:0.003281s ]
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.003263s ]
SELECT count(*) FROM cat WHERE parent_id = '14' AND is_show = 1 [ RunTime:0.003326s ]
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.003317s ]
SELECT count(*) FROM cat WHERE parent_id = '4' AND is_show = 1 [ RunTime:0.003302s ]
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.003381s ]
SELECT count(*) FROM cat WHERE parent_id = '20' AND is_show = 1 [ RunTime:0.003320s ]
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.003269s ]
SELECT count(*) FROM cat WHERE parent_id = '21' AND is_show = 1 [ RunTime:0.003303s ]
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.003278s ]
SELECT count(*) FROM cat WHERE parent_id = '34' AND is_show = 1 [ RunTime:0.003362s ]
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.003282s ]
SELECT count(*) FROM cat WHERE parent_id = '35' AND is_show = 1 [ RunTime:0.003301s ]
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.003297s ]
SELECT count(*) FROM cat WHERE parent_id = '36' AND is_show = 1 [ RunTime:0.003301s ]
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.003286s ]
SELECT count(*) FROM cat WHERE parent_id = '37' AND is_show = 1 [ RunTime:0.003287s ]
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.003327s ]
SELECT count(*) FROM cat WHERE parent_id = '38' AND is_show = 1 [ RunTime:0.003278s ]
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.003312s ]
SELECT count(*) FROM cat WHERE parent_id = '39' AND is_show = 1 [ RunTime:0.003351s ]
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.003297s ]
SELECT count(*) FROM cat WHERE parent_id = '40' AND is_show = 1 [ RunTime:0.003292s ]
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.003337s ]
SELECT count(*) FROM cat WHERE parent_id = '41' AND is_show = 1 [ RunTime:0.003354s ]
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.003306s ]
SELECT count(*) FROM cat WHERE parent_id = '42' AND is_show = 1 [ RunTime:0.003260s ]
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.003330s ]
SELECT count(*) FROM cat WHERE parent_id = '43' AND is_show = 1 [ RunTime:0.003335s ]
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.003301s ]
SELECT count(*) FROM cat WHERE parent_id = '44' AND is_show = 1 [ RunTime:0.003306s ]
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.003329s ]
SELECT count(*) FROM cat WHERE parent_id = '45' AND is_show = 1 [ RunTime:0.003297s ]
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.003350s ]
SELECT count(*) FROM cat WHERE parent_id = '46' AND is_show = 1 [ RunTime:0.003340s ]
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.003397s ]
SELECT count(*) FROM cat WHERE parent_id = '55' AND is_show = 1 [ RunTime:0.003374s ]
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.003403s ]
SELECT count(*) FROM cat WHERE parent_id = '56' AND is_show = 1 [ RunTime:0.003493s ]
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.003724s ]
SELECT count(*) FROM cat WHERE parent_id = '57' AND is_show = 1 [ RunTime:0.003371s ]
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.003397s ]
SELECT count(*) FROM cat WHERE parent_id = '3' [ RunTime:0.003332s ]
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.003405s ]
SELECT count(*) FROM cat WHERE parent_id = '15' AND is_show = 1 [ RunTime:0.003324s ]
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.003378s ]
SELECT count(*) FROM cat WHERE parent_id = '14' AND is_show = 1 [ RunTime:0.003310s ]
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.003316s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003265s ]
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.003322s ]
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.003388s ]
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.003368s ]
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 ('3','15','14') and attr.is_linked=1 GROUP BY a.attr_id,a.attr_value [ RunTime:0.003741s ]
SELECT count(*) FROM cat WHERE parent_id = '3' AND is_show = 1 [ RunTime:0.003344s ]
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.003394s ]
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.003302s ]
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.003334s ]
SELECT goods_id FROM goods_cat AS g WHERE g.cat_id IN ('3','15','14') [ RunTime:0.003341s ]
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','15','14') OR g.id IN ('6758','7057','7058','7059','7477','7478','7479','7482','7487','7519','7523','7539','7540','7542','7574','7592','7599','7603','7607','7611','7620','7647','7663','7667','7683','7684','7691','7692','7703','7723','7727','7731','7735','7771','7774','7801','7802','7810','7822','7827','7832','7838','7842','7875','7876','7891','7892','7903','7907','7915','7920','7928','7931','7939','7940','7943','7952','7963','7964','7967','7979','7987','7995','7996','8002','8003','8007','8014','8026','8031','8038','8053','8054','8066','8080','8103','8104','8164','8182','8185','8213','8235','8243','8281','8356','8390','8402','8403','8409','8416','8422','8426','8430','8438','8458','8460','8486','8502','8508','8518','8528','8529','8556','8560','8564','8565','8568','8580','8590','8596','8602','8624','8637','8652','8658','8662','8668','8678','8707','8709','8714','8722','8724','8727','8747','8763','8776','8779','8785','8825','8827','8832','8833','8836','8837','8839','8843','8845','8850','8859','8861','8880','8900','8911','8919','8921','8922','8941','8953','8964','9003') ) [ RunTime:0.010730s ]
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 ('3','15','14') OR g.id IN ('6758','7057','7058','7059','7477','7478','7479','7482','7487','7519','7523','7539','7540','7542','7574','7592','7599','7603','7607','7611','7620','7647','7663','7667','7683','7684','7691','7692','7703','7723','7727','7731','7735','7771','7774','7801','7802','7810','7822','7827','7832','7838','7842','7875','7876','7891','7892','7903','7907','7915','7920','7928','7931','7939','7940','7943','7952','7963','7964','7967','7979','7987','7995','7996','8002','8003','8007','8014','8026','8031','8038','8053','8054','8066','8080','8103','8104','8164','8182','8185','8213','8235','8243','8281','8356','8390','8402','8403','8409','8416','8422','8426','8430','8438','8458','8460','8486','8502','8508','8518','8528','8529','8556','8560','8564','8565','8568','8580','8590','8596','8602','8624','8637','8652','8658','8662','8668','8678','8707','8709','8714','8722','8724','8727','8747','8763','8776','8779','8785','8825','8827','8832','8833','8836','8837','8839','8843','8845','8850','8859','8861','8880','8900','8911','8919','8921','8922','8941','8953','8964','9003') ) ORDER BY g.id desc limit 0, 24 [ RunTime:0.014946s ]
select sum(num) as num from goods_buy_log where goods_id='9003' [ RunTime:0.003377s ]
select * from shop_config where code='currency_format' [ RunTime:0.003295s ]
select * from fa_type [ RunTime:0.003247s ]
select * from shop_config where code='currency_format' [ RunTime:0.003275s ]
select * from fa_type [ RunTime:0.003209s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 9003 and is_main=1 [ RunTime:0.003344s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 9003 and is_main2=1 [ RunTime:0.003291s ]
select sum(num) as num from goods_buy_log where goods_id='8964' [ RunTime:0.003313s ]
select * from shop_config where code='currency_format' [ RunTime:0.003275s ]
select * from fa_type [ RunTime:0.003234s ]
select * from shop_config where code='currency_format' [ RunTime:0.003340s ]
select * from fa_type [ RunTime:0.003336s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8964 and is_main=1 [ RunTime:0.003394s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8964 and is_main2=1 [ RunTime:0.003374s ]
select sum(num) as num from goods_buy_log where goods_id='8953' [ RunTime:0.003301s ]
select * from shop_config where code='currency_format' [ RunTime:0.003334s ]
select * from fa_type [ RunTime:0.003276s ]
select * from shop_config where code='currency_format' [ RunTime:0.003307s ]
select * from fa_type [ RunTime:0.003211s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8953 and is_main=1 [ RunTime:0.003327s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8953 and is_main2=1 [ RunTime:0.003348s ]
select sum(num) as num from goods_buy_log where goods_id='8941' [ RunTime:0.003264s ]
select * from shop_config where code='currency_format' [ RunTime:0.003200s ]
select * from fa_type [ RunTime:0.003206s ]
select * from shop_config where code='currency_format' [ RunTime:0.003286s ]
select * from fa_type [ RunTime:0.003265s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8941 and is_main=1 [ RunTime:0.003321s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8941 and is_main2=1 [ RunTime:0.003288s ]
select sum(num) as num from goods_buy_log where goods_id='8922' [ RunTime:0.003312s ]
select * from shop_config where code='currency_format' [ RunTime:0.003269s ]
select * from fa_type [ RunTime:0.003276s ]
select * from shop_config where code='currency_format' [ RunTime:0.003260s ]
select * from fa_type [ RunTime:0.003239s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8922 and is_main=1 [ RunTime:0.003305s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8922 and is_main2=1 [ RunTime:0.003358s ]
select sum(num) as num from goods_buy_log where goods_id='8921' [ RunTime:0.003626s ]
select * from shop_config where code='currency_format' [ RunTime:0.003265s ]
select * from fa_type [ RunTime:0.003265s ]
select * from shop_config where code='currency_format' [ RunTime:0.003301s ]
select * from fa_type [ RunTime:0.003238s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8921 and is_main=1 [ RunTime:0.003305s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8921 and is_main2=1 [ RunTime:0.003307s ]
select sum(num) as num from goods_buy_log where goods_id='8919' [ RunTime:0.003345s ]
select * from shop_config where code='currency_format' [ RunTime:0.003271s ]
select * from fa_type [ RunTime:0.003282s ]
select * from shop_config where code='currency_format' [ RunTime:0.003301s ]
select * from fa_type [ RunTime:0.003259s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8919 and is_main=1 [ RunTime:0.003345s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8919 and is_main2=1 [ RunTime:0.003329s ]
select sum(num) as num from goods_buy_log where goods_id='8916' [ RunTime:0.003311s ]
select * from shop_config where code='currency_format' [ RunTime:0.003304s ]
select * from fa_type [ RunTime:0.003309s ]
select * from shop_config where code='currency_format' [ RunTime:0.003285s ]
select * from fa_type [ RunTime:0.003262s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8916 and is_main=1 [ RunTime:0.003541s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8916 and is_main2=1 [ RunTime:0.003378s ]
select sum(num) as num from goods_buy_log where goods_id='8915' [ RunTime:0.003310s ]
select * from shop_config where code='currency_format' [ RunTime:0.003274s ]
select * from fa_type [ RunTime:0.003236s ]
select * from shop_config where code='currency_format' [ RunTime:0.003235s ]
select * from fa_type [ RunTime:0.003303s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8915 and is_main=1 [ RunTime:0.003313s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8915 and is_main2=1 [ RunTime:0.003303s ]
select sum(num) as num from goods_buy_log where goods_id='8911' [ RunTime:0.003303s ]
select * from shop_config where code='currency_format' [ RunTime:0.003288s ]
select * from fa_type [ RunTime:0.003211s ]
select * from shop_config where code='currency_format' [ RunTime:0.003329s ]
select * from fa_type [ RunTime:0.003280s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8911 and is_main=1 [ RunTime:0.003315s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8911 and is_main2=1 [ RunTime:0.003357s ]
select sum(num) as num from goods_buy_log where goods_id='8900' [ RunTime:0.003322s ]
select * from shop_config where code='currency_format' [ RunTime:0.003248s ]
select * from fa_type [ RunTime:0.003218s ]
select * from shop_config where code='currency_format' [ RunTime:0.003278s ]
select * from fa_type [ RunTime:0.003264s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8900 and is_main=1 [ RunTime:0.003310s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8900 and is_main2=1 [ RunTime:0.003277s ]
select sum(num) as num from goods_buy_log where goods_id='8898' [ RunTime:0.003267s ]
select * from shop_config where code='currency_format' [ RunTime:0.003329s ]
select * from fa_type [ RunTime:0.003270s ]
select * from shop_config where code='currency_format' [ RunTime:0.003294s ]
select * from fa_type [ RunTime:0.003277s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8898 and is_main=1 [ RunTime:0.003314s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8898 and is_main2=1 [ RunTime:0.003380s ]
select sum(num) as num from goods_buy_log where goods_id='8890' [ RunTime:0.003321s ]
select * from shop_config where code='currency_format' [ RunTime:0.003302s ]
select * from fa_type [ RunTime:0.003247s ]
select * from shop_config where code='currency_format' [ RunTime:0.003274s ]
select * from fa_type [ RunTime:0.003237s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8890 and is_main=1 [ RunTime:0.003369s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8890 and is_main2=1 [ RunTime:0.004196s ]
select sum(num) as num from goods_buy_log where goods_id='8887' [ RunTime:0.005662s ]
select * from shop_config where code='currency_format' [ RunTime:0.003371s ]
select * from fa_type [ RunTime:0.004164s ]
select * from shop_config where code='currency_format' [ RunTime:0.003281s ]
select * from fa_type [ RunTime:0.003220s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8887 and is_main=1 [ RunTime:0.003330s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8887 and is_main2=1 [ RunTime:0.003327s ]
select sum(num) as num from goods_buy_log where goods_id='8880' [ RunTime:0.003304s ]
select * from shop_config where code='currency_format' [ RunTime:0.003227s ]
select * from fa_type [ RunTime:0.003245s ]
select * from shop_config where code='currency_format' [ RunTime:0.003295s ]
select * from fa_type [ RunTime:0.003236s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8880 and is_main=1 [ RunTime:0.003312s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8880 and is_main2=1 [ RunTime:0.003298s ]
select sum(num) as num from goods_buy_log where goods_id='8877' [ RunTime:0.003300s ]
select * from shop_config where code='currency_format' [ RunTime:0.003244s ]
select * from fa_type [ RunTime:0.003293s ]
select * from shop_config where code='currency_format' [ RunTime:0.003313s ]
select * from fa_type [ RunTime:0.003266s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8877 and is_main=1 [ RunTime:0.003355s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8877 and is_main2=1 [ RunTime:0.003302s ]
select sum(num) as num from goods_buy_log where goods_id='8865' [ RunTime:0.003315s ]
select * from shop_config where code='currency_format' [ RunTime:0.003272s ]
select * from fa_type [ RunTime:0.003197s ]
select * from shop_config where code='currency_format' [ RunTime:0.003272s ]
select * from fa_type [ RunTime:0.003239s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8865 and is_main=1 [ RunTime:0.003323s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8865 and is_main2=1 [ RunTime:0.003288s ]
select sum(num) as num from goods_buy_log where goods_id='8861' [ RunTime:0.003350s ]
select * from shop_config where code='currency_format' [ RunTime:0.003267s ]
select * from fa_type [ RunTime:0.003194s ]
select * from shop_config where code='currency_format' [ RunTime:0.003376s ]
select * from fa_type [ RunTime:0.003237s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8861 and is_main=1 [ RunTime:0.003320s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8861 and is_main2=1 [ RunTime:0.003277s ]
select sum(num) as num from goods_buy_log where goods_id='8859' [ RunTime:0.003318s ]
select * from shop_config where code='currency_format' [ RunTime:0.003261s ]
select * from fa_type [ RunTime:0.003230s ]
select * from shop_config where code='currency_format' [ RunTime:0.003260s ]
select * from fa_type [ RunTime:0.003238s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8859 and is_main=1 [ RunTime:0.003460s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8859 and is_main2=1 [ RunTime:0.003351s ]
select sum(num) as num from goods_buy_log where goods_id='8850' [ RunTime:0.003316s ]
select * from shop_config where code='currency_format' [ RunTime:0.003291s ]
select * from fa_type [ RunTime:0.003228s ]
select * from shop_config where code='currency_format' [ RunTime:0.003269s ]
select * from fa_type [ RunTime:0.003251s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8850 and is_main=1 [ RunTime:0.003363s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8850 and is_main2=1 [ RunTime:0.003348s ]
select sum(num) as num from goods_buy_log where goods_id='8845' [ RunTime:0.003314s ]
select * from shop_config where code='currency_format' [ RunTime:0.003274s ]
select * from fa_type [ RunTime:0.003258s ]
select * from shop_config where code='currency_format' [ RunTime:0.003270s ]
select * from fa_type [ RunTime:0.003264s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8845 and is_main=1 [ RunTime:0.004164s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8845 and is_main2=1 [ RunTime:0.003534s ]
select sum(num) as num from goods_buy_log where goods_id='8843' [ RunTime:0.003313s ]
select * from shop_config where code='currency_format' [ RunTime:0.003247s ]
select * from fa_type [ RunTime:0.003260s ]
select * from shop_config where code='currency_format' [ RunTime:0.003255s ]
select * from fa_type [ RunTime:0.003215s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8843 and is_main=1 [ RunTime:0.003296s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8843 and is_main2=1 [ RunTime:0.003313s ]
select sum(num) as num from goods_buy_log where goods_id='8839' [ RunTime:0.003317s ]
select * from shop_config where code='currency_format' [ RunTime:0.003264s ]
select * from fa_type [ RunTime:0.003286s ]
select * from shop_config where code='currency_format' [ RunTime:0.003272s ]
select * from fa_type [ RunTime:0.003288s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8839 and is_main=1 [ RunTime:0.003406s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8839 and is_main2=1 [ RunTime:0.003340s ]
select sum(num) as num from goods_buy_log where goods_id='8837' [ RunTime:0.003319s ]
select * from shop_config where code='currency_format' [ RunTime:0.003424s ]
select * from fa_type [ RunTime:0.003244s ]
select * from shop_config where code='currency_format' [ RunTime:0.003223s ]
select * from fa_type [ RunTime:0.003197s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8837 and is_main=1 [ RunTime:0.003317s ]
select goods_id,big_url,middle_url,thumb_url,little_url from goods_images where goods_id = 8837 and is_main2=1 [ RunTime:0.003338s ]
SELECT id,keywords,cat_desc,parent_id FROM cat WHERE id='3' LIMIT 1 [ RunTime:0.003336s ]
SELECT id,keywords,cat_desc,parent_id FROM cat WHERE id='33' LIMIT 1 [ RunTime:0.003252s ]