SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197414 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197414 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383153,783004,430796,92904,1042345,605599,406170,201120,393750,353163,162506,787864,243959,59617,825246,797221,69807,739296,127200,901166,504209,710486,32016,69583,292852,300789,294870,402979,98197,733585,673911,550862,719300,205475,874351,941997,716164,1013065,768736,1025587,726761,575902,347222,183660,774327,1008985,383796,213669,728975,691063,869361,291940,940454,339038,452270,62840,488372,224642,143219,683080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]