SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405911 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405911 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563860,409709,223471,926848,730056,949685,910003,234074,98315,461088,1005579,535643,374189,589127,728895,613149,402735,1397,334112,340697,394864,213031,775563,385126,975760,582902,61229,334518,581669,114751,71041,718942,990654,429387,332245,75523,450765,323172,16880,398082,585001,494418,73505,672308,396297,126492,827638,668606,217783,877804,320576,75684,391393,120531,904884,595367,1019614,220639,220687,697041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]