SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196118 LIMIT 1 [ RunTime:0.002001s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196118 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631423,387805,194563,531809,250680,352351,403242,42240,478125,542159,926825,894495,202193,650858,511728,69463,801370,210048,684316,34563,266037,522994,698738,337742,175463,397856,481321,309740,75013,628791,801102,447192,613866,458646,298918,780843,280410,358981,345536,303852,474206,934153,556628,58705,934706,840065,678298,1010892,395415,706294,602383,497025,715587,177951,829124,991781,865611,629760,69400,465509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]