基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-09-20 06:16:12 HTTP/1.1 GET : http://www.ylexam.com/column-30.html
- 运行时间 : 0.022777s [ 吞吐率:43.90req/s ] 内存消耗:924.18kb 文件加载:148
- 查询信息 : 17 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=1735721455425df5b7543bcb755f9d5a
- CONNECT:[ UseTime:0.001022s ] mysql:host=127.0.0.1;port=3306;dbname=ylexam;charset=utf8
- SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.000818s ]
- SELECT `id`,`topid`,`cate_name` FROM `tp_category` ORDER BY `sortrank` ASC [ RunTime:0.000299s ]
- SELECT * FROM `tp_category` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000396s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (30,66,67,68,268,279) And FIND_IN_SET('cf', arc.flag)>0 ORDER BY arc.id DESC LIMIT 0,4 [ RunTime:0.000717s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (30,66,67,68,268,279) And FIND_IN_SET('cr', arc.flag)>0 ORDER BY arc.id DESC LIMIT 0,10 [ RunTime:0.000617s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (30,66,67,68,268,279) ORDER BY arc.click DESC LIMIT 0,10 [ RunTime:0.000661s ]
- SHOW FULL COLUMNS FROM `tp_archives` [ RunTime:0.000756s ]
- SELECT `id`,`title`,`color`,`typeid`,`flag` FROM `tp_archives` WHERE `typeid` IN (30,66,67,68,268,279) AND ( FIND_IN_SET('ch', flag)>0 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (30,66,67,68,268,279) And FIND_IN_SET('ch', arc.flag)>0 ORDER BY arc.id DESC LIMIT 1,3 [ RunTime:0.000935s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (30,66,67,68,268,279) And FIND_IN_SET('ch', arc.flag)>0 ORDER BY arc.id DESC LIMIT 4,9 [ RunTime:0.000658s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (30,66,67,68,268,279) And FIND_IN_SET('z', arc.flag)>0 ORDER BY arc.id DESC LIMIT 0,7 [ RunTime:0.000668s ]
- SELECT `id`,`cate_name` FROM `tp_category` WHERE `topid` = 30 ORDER BY `sortrank` ASC [ RunTime:0.000538s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (66) ORDER BY arc.id DESC LIMIT 0,10 [ RunTime:0.000559s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (67) ORDER BY arc.id DESC LIMIT 0,10 [ RunTime:0.000694s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (68) ORDER BY arc.id DESC LIMIT 0,10 [ RunTime:0.000664s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (268) ORDER BY arc.id DESC LIMIT 0,10 [ RunTime:0.000710s ]
- SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (279) ORDER BY arc.id DESC LIMIT 0,10 [ RunTime:0.000472s ]
0.023812s