SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648914 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648914 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860900,765005,831526,908158,1036169,229590,820937,765337,253811,315305,1019625,81304,163433,607119,542145,291175,339121,422829,641430,182040,400242,566819,903796,8518,223840,117467,194260,205016,269404,564970,407676,427167,703470,217565,304594,113888,625362,262507,887261,936374,997807,9858,887309,1013470,288206,538626,344950,978054,130386,686982,416246,298801,615691,967033,629453,216348,710470,864206,8433,1000396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]