SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409017 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409017 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227589,288704,434972,1048722,563146,303180,827991,301290,797821,166857,1006026,701629,444964,583945,1013608,285972,871030,406889,244771,782619,883502,962315,885995,648584,845846,901184,231803,498116,20369,178756,932076,468460,996688,53545,797691,639018,54300,702720,579393,43446,345336,252498,542870,37885,984008,831318,417969,615444,160569,324010,332140,656158,427638,117823,596426,748746,592274,428359,247180,967966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]