SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564291 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564291 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365624,488583,391116,65444,745981,39678,5247,611795,386547,993185,865728,216338,728411,769503,7851,332512,35789,553826,673933,78778,819127,410667,307715,216350,31522,334114,642146,245379,730806,616462,816725,485780,495264,222653,449667,44024,430564,106652,385139,1017157,949959,17683,835915,928420,1001635,428019,201932,619426,766065,493477,383063,525286,719853,568534,952399,144245,575889,618842,1044150,743887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]