SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383223 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383223 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532591,571369,265702,58025,1014041,573190,1013712,340314,1041050,454403,702124,438222,615678,1004901,483317,1047633,91851,170259,549848,772735,769005,96941,708260,755199,789827,460649,892579,35576,439294,742213,194867,474159,354852,618928,309960,951975,480695,159490,672875,937952,11284,622118,524821,889495,300440,330376,522958,15764,698562,472997,692322,71364,940,951840,128351,717018,914955,951159,206725,810514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]