SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254488 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254488 [ RunTime:0.004359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710300,147628,52543,252575,662686,165280,915207,871773,698120,438530,190353,42642,1004170,288403,563674,905669,318140,599455,3773,261588,452291,693056,288931,23224,224487,345622,992159,192554,958410,143938,766711,188413,473953,114641,665342,939425,1042076,59746,290475,666104,261390,865941,253718,388864,941066,862014,862663,415712,40491,498071,506524,607020,640021,489981,13928,392937,996087,983967,569490,847498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]