米通格_现货

基本文件流程错误 SQL 调试

SELECT * FROM `tp_ml` WHERE `letter` = 'a' [ RunTime:0.0004s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'b' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'c' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'd' [ RunTime:0.0004s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'e' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'f' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'g' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'h' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'i' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'j' [ RunTime:0.0004s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'k' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'l' [ RunTime:0.0004s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'm' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'n' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'o' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'p' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'q' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'r' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 's' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 't' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'u' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'v' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'w' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'x' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'y' [ RunTime:0.0003s ]
SELECT * FROM `tp_ml` WHERE `letter` = 'z' [ RunTime:0.0003s ]
UPDATE `tp_ml` SET `lv`=lv+1 WHERE `id` = 170 [ RunTime:0.0002s ]
SELECT * FROM `tp_ml` WHERE `id` = 170 LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `tp_draper_type` WHERE `id` = 12 LIMIT 1 [ RunTime:0.0002s ]
SELECT COUNT(*) AS tp_count FROM tp_draper_ml d left JOIN tp_draper as r ON d.did=r.id left JOIN tp_draper_role as dr ON dr.did=r.id WHERE d.ml_id = '170' AND dr.type_id = '12' LIMIT 1 [ RunTime:0.0006s ]
SELECT r.*,d.ml_id,r.sid FROM tp_draper_ml d left JOIN tp_draper as r ON d.did=r.id left JOIN tp_draper_role as dr ON dr.did=r.id WHERE d.ml_id = '170' AND dr.type_id = '12' ORDER BY r.vip desc,r.level desc,r.sort desc,r.id desc [ RunTime:0.0016s ]
SELECT * FROM `tp_draper_type` ORDER BY sort asc,id asc [ RunTime:0.0002s ]
SELECT * FROM `tp_ml` WHERE `id` = 170 LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `tp_ml` ORDER BY hot asc ,id desc LIMIT 8 [ RunTime:0.0004s ]