SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194028 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194028 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931675,98590,121776,289946,639877,442525,560892,874504,830995,748481,900856,144914,33913,272591,78779,751138,718036,575643,232884,995929,4161,183298,433764,827045,269241,128857,1001699,610672,1005543,519768,70680,369552,965120,267486,986779,965788,330415,432120,63475,504313,934008,229370,153244,322902,10746,218832,933129,589028,1045185,1011195,132807,277081,449231,41963,33348,764072,520059,400990,867178,738845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]