SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480395 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480395 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24887,846500,155987,268334,775465,1017389,16599,707605,615479,20779,582146,116001,708609,1031901,37417,849435,874902,600020,418031,634642,403046,291901,527583,349894,397395,34267,365921,602275,559488,550183,114812,44142,906548,950504,576460,143080,351500,160094,51378,799255,113657,475110,977997,172711,713432,941616,830275,706568,563916,367173,470805,615439,867542,451665,328008,792877,906434,610745,106677,4976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]