SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49208 LIMIT 1 [ RunTime:0.001466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49208 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850896,517481,522466,421245,404718,638393,578232,529999,975686,804974,121447,889968,769466,827467,979787,701693,990170,5459,336853,655718,28826,339100,371112,449665,453431,233503,48084,50766,763981,246095,997254,1031203,283594,8945,381320,683318,539269,363186,878829,234863,783609,981576,48992,742591,983248,280263,895402,997281,1031055,617308,175421,915985,479345,704979,173317,473256,847254,926877,1004105,196900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001254s ]