SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198092 LIMIT 1 [ RunTime:0.001998s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198092 [ RunTime:0.006711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684979,439864,217979,372200,662722,574187,463866,219560,304765,997611,46083,855901,527053,882052,829635,1042974,898738,690616,51719,957689,972875,50004,446096,343588,347842,892526,50088,575338,784764,582583,819993,467899,975435,478047,407402,1041909,984954,659777,834630,267824,1030825,953565,155847,849883,485530,660441,395218,1001909,647697,303906,810987,1044263,308542,716558,613644,761163,310355,711411,416020,903280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002095s ]