SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455371 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455371 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595909,33641,100768,695294,838903,321671,438243,770329,267893,54627,341290,87959,673489,209521,82050,593931,438720,31808,107570,994503,271366,687844,399115,24041,223414,49824,1004211,31441,654973,124421,223857,960305,178325,275807,477753,64368,648001,551160,205754,426323,162254,65180,509003,770791,833336,594263,837399,900191,232212,776123,918026,932833,154007,853448,664225,984192,117007,202089,438274,1013524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]