SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504696 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504696 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9405,180056,410595,465916,895592,422885,470677,935942,327290,974707,275584,811155,844789,399229,745794,32336,256268,1047872,707337,419438,773009,848149,20031,981929,633919,809159,469320,480110,1036936,453242,49175,334749,971796,26976,722064,328024,933782,60994,1035291,279092,392708,269214,93327,1025276,882518,924290,1045874,133146,95662,493143,25286,873716,388669,647082,442254,473586,700350,807554,478405,522035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]