SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 132140 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 132140 [ RunTime:0.002901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247304,221095,226231,347652,862571,776514,738874,263777,875831,675525,861538,937282,369987,532903,755771,120213,297795,183784,794741,634931,349245,929043,309625,179467,544197,817318,170606,480470,411846,776208,875199,802709,409993,442856,245126,1019271,914311,315792,985771,166664,98337,438395,583478,634388,765483,74019,572148,316511,55663,1020309,685781,860601,379885,155007,758149,39093,14826,361020,525351,886591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 132140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 132140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]