SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40423 LIMIT 1 [ RunTime:0.001269s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40423 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131148,373755,968187,994437,483650,125558,147969,85223,956478,655400,16521,972739,834285,737955,826020,219385,555635,840182,856020,664524,369788,169450,456300,783664,385233,133808,5319,186600,824772,701560,371198,932352,72786,741555,492670,672249,537420,74429,925725,318492,720759,674147,286739,132291,64947,365563,222655,777563,506965,62880,805208,177656,406071,251746,484497,710981,844479,208911,482862,106366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]