SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431518 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431518 [ RunTime:0.003013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788285,1010618,482603,708735,56502,9237,567147,182247,280412,928696,489620,485576,189179,991652,479398,568034,31202,266569,976436,903289,356073,26339,603881,447867,187613,677405,712334,784145,289382,112839,553945,593593,477412,872143,321355,243362,34715,526848,737946,423301,977857,532441,221695,401108,847005,692503,91326,536836,571400,425204,466463,901075,515234,991871,851383,693611,537856,928305,738668,463481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]