SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409015 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409015 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395897,229660,889844,272059,100167,589468,328963,318836,693048,593355,1023296,731369,279680,735711,596843,219965,161200,87297,862930,433625,560220,700498,214823,479542,921682,661193,240611,1006465,206393,831838,1035789,638526,805781,864100,706260,240440,865680,887081,109238,867000,909628,871387,254246,402414,218264,639364,98409,546379,695608,990238,257496,706053,175670,763812,707178,847490,576558,620187,135265,614311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001092s ]