SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842016 LIMIT 1 [ RunTime:0.001354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842016 [ RunTime:0.003455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039746,1018725,567476,685316,94279,335476,160694,454444,322550,381889,818490,1038865,990308,310222,830582,885657,648224,820911,928223,478545,6736,1028317,544941,835673,230710,1048886,212297,226118,594389,420034,534169,69641,323461,59705,914197,414547,209989,334375,19125,833135,532944,113601,767707,881121,313180,68553,290526,696446,732468,513528,26931,776526,654498,690124,15035,483715,406169,674313,408347,1007824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002355s ]