SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107731 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107731 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912386,16162,49876,999516,305583,534208,999243,337098,209046,62110,890647,248802,291170,970021,755975,303024,912521,467712,197101,1001295,248412,611011,267664,510105,766437,497622,841254,988251,36093,380487,773840,887745,599113,289193,655263,864387,1003967,135982,756816,42150,525064,356439,536094,171100,542531,519885,418698,307481,148141,1005235,508959,4662,100020,207902,109549,613461,579010,1025168,879027,463971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]