SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20109 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20109 [ RunTime:0.003400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339855,943745,1045403,267049,545627,640220,1038949,59758,517255,336742,19240,769258,66722,257975,840649,42522,938257,636981,573251,11571,60246,399648,570945,312144,82385,863101,112074,988581,841686,230964,401597,757250,93956,91207,471761,1042311,212841,500532,981890,908877,391505,569758,16537,404992,131984,218779,389969,910610,411606,662231,655332,232859,321848,497281,965558,570878,643842,821373,735601,268110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]