SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284400 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284400 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765233,369437,443376,184731,501284,990602,631348,738065,42210,854780,811200,345875,2159,550049,36105,436751,1038368,303169,921726,123831,70907,994963,465398,607071,221978,824771,463502,693696,422482,360099,795924,605182,459742,275154,928994,880830,592651,683393,955518,338198,963377,281007,930494,712483,439176,793189,84150,470039,445632,72023,660842,710947,211630,1040324,659041,41195,438707,478695,43139,742223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]