SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196052 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196052 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431361,388714,750367,1040945,354242,453105,876585,670535,509882,728441,167,55038,797233,233887,826507,857477,551941,688620,941138,963697,194193,548139,181747,331466,996179,1004376,560614,664100,436343,297171,924762,676241,102683,669167,1006742,23845,802192,392404,557205,637545,488228,701632,951380,989379,537409,324749,369234,376893,89404,806110,487397,414047,492968,111966,230649,614424,193931,59882,463491,698949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002643s ]