SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445420 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445420 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783689,916079,199996,273087,260278,85114,316875,415916,352399,654465,38865,214832,69849,848378,295977,1039164,595444,554874,254183,821885,590416,935448,645579,572777,668695,15208,656951,327266,158618,97352,164758,405396,26267,369300,897139,717515,172507,43839,1005257,265494,889870,320415,237344,429541,144269,647363,100014,593937,158485,710954,994068,153252,725872,266524,354762,279920,639249,178906,957592,612195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]