SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418753 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418753 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260728,97785,630215,887216,880878,637559,456006,726269,971346,201231,922647,167114,706564,446321,796130,324118,193014,976804,808125,330889,492360,446901,362984,284723,21626,1321,246378,945399,1018302,452507,202233,901529,66942,860017,531101,505046,163237,731458,476686,759170,216834,205349,556122,226231,749915,614093,419234,288757,206068,455939,153138,874286,7540,762879,924339,282962,421638,510526,747413,574882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]