SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398031 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398031 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185992,1015616,344130,872378,324278,869522,197188,268398,1007469,477717,912815,404823,178301,898638,355104,912793,405851,569085,972458,918544,161768,41973,923688,1019685,718128,117705,75841,719702,125397,485156,136688,561289,665681,431583,1013848,353348,771454,855959,459594,631541,106359,763593,1037986,597746,400211,288572,15664,66547,531563,819291,1048022,616993,947486,171597,901887,330895,173877,991464,1023456,542819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]