基本
文件
流程
錯(cuò)誤
SQL
調(diào)試
- 請(qǐng)求信息 : 2025-06-02 19:12:25 HTTP/1.1 GET : http://m.pziu.cn/ask/1053.html
- 運(yùn)行時(shí)間 : 0.121707s [ 吞吐率:8.22req/s ] 內(nèi)存消耗:4,296.84kb 文件加載:147
- 查詢信息 : 28 queries
- 緩存信息 : 0 reads,0 writes
- 會(huì)話信息 : SESSION_ID=fb0375c54e858b92ef8f16cd13ce71cc
- CONNECT:[ UseTime:0.000330s ] mysql:host=127.0.0.1;port=3306;dbname=loowei_com;charset=utf8
- SHOW FULL COLUMNS FROM `jy_news_type` [ RunTime:0.000412s ]
- SELECT `id`,`name`,`ename` FROM `jy_news_type` WHERE `state` = 1 AND `pid` = 0 ORDER BY `sort` DESC,`id` LIMIT 12 [ RunTime:0.000249s ]
- SHOW FULL COLUMNS FROM `jy_ask` [ RunTime:0.000332s ]
- UPDATE `jy_ask` SET `hits` = `hits` + 1 WHERE `state` = 1 AND `id` = 1053 [ RunTime:0.001582s ]
- SELECT * FROM `jy_ask` WHERE `state` = 1 AND `id` = 1053 LIMIT 1 [ RunTime:0.000231s ]
- SHOW FULL COLUMNS FROM `jy_ask_type` [ RunTime:0.000283s ]
- SELECT `id`,`name`,`ename` FROM `jy_ask_type` WHERE `state` = 1 AND `pid` = 0 ORDER BY `sort` DESC,`id` LIMIT 99 [ RunTime:0.000183s ]
- SELECT `name` FROM `jy_ask_type` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000151s ]
- SELECT `ename` FROM `jy_ask_type` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000111s ]
- SELECT `name` FROM `jy_ask_type` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000109s ]
- SELECT `ename` FROM `jy_ask_type` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000103s ]
- SHOW FULL COLUMNS FROM `jy_ask_answers` [ RunTime:0.000275s ]
- SELECT * FROM `jy_ask_answers` WHERE `state` = 1 AND `question_id` = 1053 ORDER BY `add_time` DESC [ RunTime:0.016592s ]
- SHOW FULL COLUMNS FROM `jy_member` [ RunTime:0.000420s ]
- SELECT `nickname`,`headerimg`,`answer_count` FROM `jy_member` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000195s ]
- SHOW FULL COLUMNS FROM `jy_keywords` [ RunTime:0.000246s ]
- SELECT `keyword` FROM `jy_keywords` WHERE ( INSTR('高中孩子不想上學(xué)怎么辦家長(zhǎng)怎么開導(dǎo)',keyword)>0 ) [ RunTime:0.000607s ]
- SELECT id,one_type_id,title,member_id,hits,add_time,hide_member_id,answer_count,(IF(INSTR(`title`,'孩子')>0,1,0)+IF(INSTR(`title`,'怎么辦')>0,1,0)+IF(INSTR(`title`,'不想')>0,1,0)+IF(INSTR(`title`,'上學(xué)')>0,1,0)+IF(INSTR(`title`,'家長(zhǎng)')>0,1,0)+IF(INSTR(`title`,'怎么')>0,1,0)+IF(INSTR(`title`,'開導(dǎo)')>0,1,0)+IF(INSTR(`title`,'高中')>0,1,0)+IF(INSTR(`title`,'孩子不')>0,1,0)) AS scount FROM jy_ask WHERE state=1 ORDER BY scount DESC,add_time DESC LIMIT 0,7 [ RunTime:0.033419s ]
- SELECT `ename` FROM `jy_ask_type` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000260s ]
- SELECT `ename` FROM `jy_ask_type` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000165s ]
- SELECT `ename` FROM `jy_ask_type` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000145s ]
- SELECT `ename` FROM `jy_ask_type` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000125s ]
- SELECT `ename` FROM `jy_ask_type` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000143s ]
- SELECT `ename` FROM `jy_ask_type` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000160s ]
- SELECT `id`,`one_type_id`,`title`,`add_time` FROM `jy_ask` WHERE `state` = 1 AND `one_type_id` = 2 ORDER BY `add_time` DESC LIMIT 10 [ RunTime:0.005916s ]
- SELECT `id`,`one_type_id`,`title`,`add_time` FROM `jy_ask` WHERE `state` = 1 AND `one_type_id` = 2 ORDER BY `hits` DESC LIMIT 10 [ RunTime:0.006003s ]
- SELECT * FROM `jy_ask` WHERE `state` = 1 AND `id` < 1053 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000309s ]
- SELECT * FROM `jy_ask` WHERE `state` = 1 AND `id` > 1053 ORDER BY `id` LIMIT 1 [ RunTime:0.000271s ]