SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261231 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261231 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249456,2073,51357,827111,436087,516601,498416,530169,870238,419789,48785,206418,351502,193120,103315,306527,12025,1024652,19227,520177,990614,714913,573624,594056,954038,706338,233630,693010,1047554,1006545,799950,491622,188784,351724,181987,197194,711370,851516,166093,142211,15835,1031915,500020,503802,920944,972175,856273,326103,508928,889613,930878,532910,203757,546455,699248,923532,173090,814601,155764,214892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]