SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314774 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314774 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030243,924034,977357,633777,727728,963314,434563,518820,348616,367458,328917,409422,989666,323223,123169,155411,402705,749796,757096,205012,488961,130634,410141,825700,784902,979294,885429,668471,427165,734923,442877,602281,424640,292542,517689,950088,238536,806737,677069,148587,744914,267232,89183,956633,1012784,886728,467746,556970,252848,546379,567600,665316,183423,710394,828272,1029766,420075,675338,635173,634356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]