SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 936481 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 936481 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414868,498237,926053,811417,656913,216998,429688,626694,1030188,278028,507407,198619,204080,301079,585838,571090,86517,478880,103120,761910,955487,659764,398263,111128,377440,593116,587853,518839,590848,843683,807047,290403,594686,420188,755950,990845,740279,1045067,746864,879409,1040470,390890,745204,444957,637109,787498,1007677,69210,263842,1012889,841993,181279,977789,1048209,97246,960629,23161,609968,575311,514413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 936481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 936481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001148s ]