SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497296 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497296 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744404,176103,63291,9624,161234,380878,428014,973231,1007851,969942,708830,847982,109712,709258,867227,512944,872899,1040375,183578,800625,578498,773036,140857,956935,715024,682404,342584,1038204,1033641,1035631,40595,663449,274161,697467,733413,789083,720821,289105,66443,866402,544319,189414,163156,527667,36900,771451,1010702,953256,1014395,139435,89055,689523,468410,898751,113607,197015,755951,321981,362343,663150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497296 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497296 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]