SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416705 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416705 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745107,808344,454074,489416,571071,545916,751646,317394,303722,582807,172848,971470,791012,631111,204171,838754,476017,406772,87663,148374,367067,873223,61229,840741,535168,905466,1015169,231343,312224,369050,943345,300494,360355,441876,780992,983362,340767,989002,873292,408966,364256,454443,847249,661059,620762,315215,722853,45615,642735,199821,769191,683442,829878,510041,449640,150221,18862,220823,127273,776615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]