［SQL语句］

SELECT catid,catname,arrchildid,pclink,target FROM `v.hmccw.com` . `yzm_category` WHERE siteid = 0 AND `display`=1 AND parentid=0 ORDER BY listorder ASC LIMIT 20; [ RunTime:0.000935s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=11; [ RunTime:0.001083s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=11 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000638s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000695s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000130s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=11 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000748s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=14; [ RunTime:0.000321s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=14 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000347s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000201s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000378s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=14 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000475s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=15; [ RunTime:0.000724s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=15 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000364s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000357s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000210s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=15 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000241s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (18,40); [ RunTime:0.000211s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (18,40) ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000282s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000157s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000132s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (18,40) ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000428s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (7,22,23); [ RunTime:0.000317s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (7,22,23) ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000167s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000198s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000489s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (7,22,23) ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000183s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=10; [ RunTime:0.000120s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=10 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000173s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000162s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000395s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=10 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000235s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (8,30); [ RunTime:0.000144s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (8,30) ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000194s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000366s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000472s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid IN (8,30) ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000229s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=9; [ RunTime:0.000110s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=9 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000367s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000190s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000366s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=9 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000208s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=12; [ RunTime:0.000117s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=12 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000262s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000321s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000237s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=12 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000300s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=13; [ RunTime:0.000265s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=13 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000630s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000235s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000115s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=13 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000430s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=16; [ RunTime:0.000117s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=16 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000289s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000389s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000100s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=16 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000174s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=17; [ RunTime:0.000109s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=17 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000170s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000157s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000288s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=17 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000136s ]

SELECT COUNT(*) AS total FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=19; [ RunTime:0.000122s ]

SELECT * FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=19 ORDER BY listorder ASC,id DESC LIMIT 0,20; [ RunTime:0.000189s ]

SELECT arrchildid FROM `v.hmccw.com` . `yzm_category` WHERE (catid = '22') LIMIT 1; [ RunTime:0.000616s ]

SELECT sum(click) AS wzt FROM `v.hmccw.com` . `yzm_product` WHERE catid in (22) AND status = 1; [ RunTime:0.000112s ]

SELECT title,thumb,url,color FROM `v.hmccw.com` . `yzm_product` WHERE status=1 AND catid=19 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.000388s ]

［其他信息］

WEB服务器：nginx/1.20.2

PHP版本：7.2.33

路由信息：模块( index )，控制器( index )，方法( lists )，参数( catid=6 )

框架版本：2.9 查看新版