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` = 801471 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801471 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937942,552504,923371,66798,48955,882513,861922,369990,823136,1005168,72471,642520,596348,370844,909918,228967,339988,374463,514738,429244,505599,108201,171959,730585,204067,725838,673943,771621,48165,983749,697241,591339,227949,256355,120597,442599,150063,1044566,647425,479620,272251,844011,292798,772540,396297,480081,804586,180111,730378,70902,485001,949122,232817,713644,472975,640741,446404,704632,225607,251992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]