SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001952s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541901 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541901 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920271,390191,542378,275599,314332,22633,105285,36353,564064,504326,1000214,540225,173143,581813,1006410,431322,1007856,739268,676533,731235,711961,97621,732361,355007,240495,888372,479572,675319,1034601,657906,999814,456786,357148,70945,318156,968787,92104,385827,461180,794320,394061,208564,848185,425994,259564,125079,402030,400606,231992,229900,322037,809411,587111,143802,1034136,170034,62561,253953,309663,547579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]