SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449515 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449515 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327338,120798,630096,1020654,865569,341391,235124,14649,999246,396402,984879,16172,517970,502743,263816,400493,279902,798729,260250,25632,831159,524836,673540,638767,748737,42005,356468,798327,279437,381870,581707,659181,539772,774830,77291,108097,585255,834430,542561,802342,69731,199722,610891,806200,697880,840129,213963,775518,941931,203738,1042341,783518,88128,846945,615577,244117,496588,81816,339536,522542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]