SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508015 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508015 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885607,662951,692214,191719,436894,1032493,258740,422423,603753,984875,553467,14025,458733,722276,642926,668381,848766,697946,240478,562009,611741,322987,306187,338874,646835,837901,729929,455590,1012095,409460,825159,221351,672932,131429,444661,877040,979434,765902,511300,791827,77809,269167,763945,503127,1047870,907083,93529,135765,972438,33953,741797,562260,861385,1006737,607488,962832,611254,495447,931967,967433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]