SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311404 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311404 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196943,897813,573464,15235,591229,1034639,324206,129017,739555,106382,94007,977719,623967,1022423,168772,200948,447525,521607,331585,609711,141949,692823,137928,486319,381914,710813,133814,210111,815622,62747,872495,854149,511151,146554,366501,792698,822225,525219,94097,835870,416869,791146,416244,295928,623024,442298,460534,691346,833604,199978,161353,976723,321932,117713,253059,877800,210133,1033284,551853,401269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]