SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 377928 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 377928 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462596,351429,202008,181042,108627,760876,616572,167386,302356,680886,784410,208124,845551,751127,162781,573411,503392,874479,692241,540315,557242,265029,865744,287867,737821,508818,1003551,940094,221838,226882,725201,659595,1006105,594724,256932,597808,520952,84615,644426,760573,712768,670290,41892,673452,444738,409982,600541,600125,753590,686172,721735,585737,6675,852725,424645,803351,818621,729940,684893,792927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 377928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 377928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]