SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520646 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520646 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680886,525375,942320,378100,437589,1020274,78544,54134,419688,565416,1008913,588320,824456,512541,40677,847976,913418,266023,925181,332875,1034118,663239,716891,487416,880215,87796,607993,881007,423111,789509,888892,306791,1029146,672110,927443,966454,223337,276875,120716,342586,506614,98910,189253,255077,422150,401089,73773,323052,387966,896315,380077,229210,922193,581292,121467,74225,716840,938137,843392,769483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]