SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341406 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341406 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713944,739194,597341,64075,494483,134239,652836,631430,58787,1023675,273326,787295,941915,286399,576184,394187,151183,539754,611913,730650,339666,216005,118019,1034007,318860,831157,436601,469535,947509,445644,394263,472420,806596,883300,744061,20627,70378,147432,729313,141571,950498,801368,831412,469750,1043137,821735,133790,206525,418449,430376,163425,898655,652794,470352,599263,771740,978196,8327,552950,621244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]