SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305904 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305904 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419553,799798,877048,697235,749919,102427,278456,220796,83767,706863,193024,101611,781851,19271,1009345,998046,678195,27443,852843,282546,12653,59788,393835,915797,281929,220889,908638,426036,551801,721595,787053,932213,483430,287348,209802,24318,1046409,542697,961223,870589,742322,721877,893888,336547,176212,186559,957574,182958,514772,331475,924682,987809,51101,484462,878164,937081,205764,961438,891371,510299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]