SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431984 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431984 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94095,139707,567426,166986,104329,529144,222698,384172,572437,105486,554918,836880,1015613,117255,200051,418336,220397,17711,769237,748443,757490,490661,860377,198420,133758,895163,1016067,731707,383287,760741,684572,504346,710974,894218,82573,235947,560556,551984,1044464,641843,147111,466572,350010,155397,469582,497093,761814,591890,1021855,538049,250531,340412,667280,858966,710905,883977,217663,506080,176940,776059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001443s ]