SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017411 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017411 [ RunTime:0.008958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111640,695243,487222,789588,422584,153579,297617,35839,219158,161139,437384,637521,141152,483284,752515,769339,727197,375945,856703,722417,515844,183227,286679,91282,291905,422164,354380,301106,210408,270523,372971,789757,393523,539267,835829,760444,709304,1048439,196621,799887,678679,532369,352362,510102,716739,212294,402987,500063,972715,1038334,921801,16933,304559,593899,742636,510790,402967,501299,664734,915934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002296s ]