SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381241 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381241 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53679,431695,293852,784991,698050,219235,618229,772050,760525,722510,772674,1032600,994220,563266,805333,369814,83784,108271,100338,799384,1018512,300295,685679,651790,501683,933119,921900,782222,165686,571270,544791,403872,176025,328461,646858,1016402,822587,315292,530987,723727,326576,519684,1028109,1000287,864463,530810,668159,858160,31377,936507,524919,977656,335903,233385,79720,327056,657675,899913,1044347,586253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]