SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436919 LIMIT 1 [ RunTime:0.001694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436919 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683438,485981,1002411,202986,830200,971912,959895,687496,1147,146050,250832,876646,256742,548587,964580,280593,193470,649836,406864,92155,712267,788779,666751,907344,452912,328840,5010,255341,299687,58998,967442,226361,549181,106981,221938,556934,991949,292998,404145,188856,272554,35260,629211,433207,70169,750687,474402,897164,757589,961750,138834,465892,500466,387317,3243,193996,83143,686240,1012476,788102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000911s ]